1 package CTO_ITEM_PK as
2 /* $Header: CTOCCFGS.pls 120.1 2005/06/21 16:13:06 appldev ship $ */
3
4 /*-----------------------------------------------------------------------------
5 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA
6 | All rights reserved.
7 | Oracle Manufacturing
8 |-----------------------------------------------------------------------------
9 |
10 | File name : CTOCCFGS.pls
11 | Description : Creates new inventory item for CTO orders. Performs
12 | the same functions as BOMLDCIB.pls and INVPRCIB.pls
13 | for streamlined CTO supported with new OE architecture.
14 |
15 | History : Created based on BOMLDCIB.pls and INVPRCIB.pls
16 | Created On : 09-JUL-1999 by Usha Arora
17 |
18 +------------------------------------------------------------------------------*/
19 gUserID number ;
20 gLoginId number ;
21
22
23 /*-------------------------------------------------------------------
24 Name : create_and_link_item
25
26 Description : This function starts the Configuration item process.
27 It recieves the order_line_id of the sales order as
28 input and retrieves the model and organization data
29 It then calls all necessary functions to create the
30 new configuration item and the BOM.
31
32 Returns : TRUE if function completed successfully
33 FALSE if function encountered an error.
34 -----------------------------------------------------------------------*/
35
36 FUNCTION Create_And_Link_Item(pTopAtoLineId in number,
37 xReturnStatus out NOCOPY varchar2,
38 xMsgCount out NOCOPY number,
39 xMsgData out NOCOPY varchar2,
40 p_mode in varchar2 default 'AUTOCONFIG' )
41 RETURN integer;
42
43
44 FUNCTION Create_All_Items(pTopAtoLineId in number,
45 xReturnStatus out NOCOPY varchar2,
46 xMsgCount out NOCOPY number,
47 xMsgData out NOCOPY varchar2,
48 p_mode in varchar2 default 'AUTOCONFIG' )
49 RETURN integer;
50
51
52
53
54 procedure perform_match(
55 p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
56 x_match_found out NOCOPY varchar2,
57 x_matching_config_id out NOCOPY number,
58 x_error_message out NOCOPY VARCHAR2,
59 x_message_name out NOCOPY varchar2
60 );
61
62
63
64 end CTO_ITEM_PK;