1 package body CTO_CUSTOM_MATCH_PK as
2 /* $Header: CTOCUSMB.pls 120.1 2005/06/02 13:53:56 appldev $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : CTOCUSMB.pls |
10 | |
11 | DESCRIPTION : This pcakage is a customization hook to facilitate |
12 | development of customized configuration Match logic. |
13 | |
14 | It is CTO equivalent of the old BOMCEDCB.pls. This function |
15 | is used in CTOCCFGB.pls instead of CTO_MATCH_CONFIG.check |
16 | _config_match whern the BOM:Check Duplicate Configuration |
17 | is set to '2' (Match). |
18 | |
19 | |
20 | HISTORY : 10/12/99 Usha Arora |
21 | 06/01/05 Renga Kannan Added NOCOPY Hint |
22 | |
23 *============================================================================*/
24
25 /*---------------------------------------------------------------------------+
26 This function tries to find a match for an existing config item
27 using the customized logic. The function accepts Model's line_id
28 in oe_order_lines_all table and returns the inventory_item_id
29 of the matched config item. If match is not found, XmatchedITemId
30 should return null. Function returns 1 if it was successfully executed
31 and returns a 0 (Zero), if it encountered errors.
32 +----------------------------------------------------------------------------*/
33
34 function find_matching_config(
35 pModelLineId in number, -- Model Line Id in oe_order_lines_all
36 xMatchedItemId out NOCOPY number, -- Item ID of Matched Config
37 xErrorMessage out NOCOPY VARCHAR2,
38 xMessageName out NOCOPY VARCHAR2,
39 xTableName out NOCOPY VARCHAR2 )
40 return integer -- 1 = OK, 0 = Error
41 is
42 begin
43 /*----------------------------------------------------------------+
44 This function can be replaced by custom code that will search
45 for an existing configuration that meets the requirements
46 specified by the demand for a new configuration.
47 +-----------------------------------------------------------------*/
48
49 xMatchedItemId := NULL;
50 return (1);
51 end;
52
53 end CTO_CUSTOM_MATCH_PK;