PL SQL Script: Sample Package Body
whenever sqlerror exit failure rollback;
create or replace package cz_user_autoselection as
/**********************************************************************************/
/* $Header: CZUASLTB.pls 110.2 97/07/15 17:52:53 appldev ship $ */
/**********************************************************************************/
/* Copyright (c) 1997 Oracle Corporation Redwood Shores, California,USA */
/* All rights reserved. */
/* Oracle Manufacturing */
/**********************************************************************************/
/* */
/* Program: CZUASLTB.pls */
/* Description: This file contains the prototypes for the following function */
/* */
/* 1. User_AutoSelection */
/* This serves as an extension to the built in capabilities */
/* of Oracle Product Configurator. */
/* */
/* The User AutoSelection function is enabled by selecting the */
/* User Function Based Items and Quantities AutoSelection */
/* Option from the Assign Constraints form. The Name of the */
/* PL/SQL Package is entered in the Function field of the */
/* AutoSelection Items window. The Product Configurator engine */
/* calls the named package and validates your items and */
/* quantities against the orderable bill of material. Items */
/* must exist uniquely and the quantity must be permitted for */
/* that item in the orderable bill of material. */
/* */
/* 2. User_Optimize_Expression */
/* A packaged function that evaluates a complex optimization */
/* expression that is external to the Product Configurator, */
/* and returns the value to the Product Configurator */
/* to be used for the range based autoselection/autoexclusion */
/* types Range Based Items and Quantities, Optimized Quantities */
/* and Optimized Items and Quantities. */
/* */
/* The User_Optimize_Expression function is enabled by checking */
/* the User Function check box on the AutoSelection Items window */
/* and entering the Name of the PL/SQL Package in the */
/* Optimization Expression field of the same window. */
/* The Product Configurator engine calls the named package and */
/* returns a character or numeric value to be used for */
/* evaluation with the defined ranges of the specified */
/* AutoSelection/AutoExclusion Type. */
/* */
/* 3. User_Clause_Function */
/* A packaged function that evaluates and returns a value of */
/* true/false/stop to the Product Configurator to be used by */
/* the evaluating class. */
/* */
/* The User_Clause_Function is invoked by entering name of the */
/* package.function in the User Validate Function column of the */
/* constraints form. The function column in the Defined */
/* Constraint form should be 'User Validate' and the operator */
/* should be 'NA'. */
/* */
/* Context Information: */
/* The previous autoselections that have occured for the sales */
/* order line in this run of Configuration validation, are */
/* viewable through the view CZ_COMPONENT_SELECTIONS_V, */
/* filtered based on the group_id which is passed in to the */
/* User_AutoSelection function. Item_svrid column contains the */
/* constraint assignment_id that has autoselected the item, */
/* while those with NULL value represent customer selections */
/* */
/* Called By: CZ_VALIDATE_CONFIGURATION (CZVCFGRS/B.pls) */
/* */
/* Changed by: Who When What */
/* Tony Gaughan 9/17/97 Updated layout (standards) */
/* */
/**********************************************************************************/
function User_AutoSelections( pnLineID in number,
pnAssignmentID in number,
pnGroupID in number,
xcErrorMessage out varchar2 )
return integer;
function User_Optimization_Expression( pnLineID in NUMBER,
pnAssignmentID in NUMBER,
pnGroupID in NUMBER,
xcExpressionValue out VARCHAR2,
xcDataType out VARCHAR2,
xcErrorMessage out VARCHAR2 )
return integer;
function User_Clause_Function( pnLineID in number,
pnAssignmentID in number,
pnGroupID in number,
xnReturnedValue out number,
xcErrorMessage out varchar2 )
return integer;
end CZ_User_Autoselection;
/
exit;
