1 package CTO_BOM_RTG_PK AUTHID CURRENT_USER as
2 /* $Header: CTOBMRTS.pls 115.16 2002/12/15 21:20:14 ssawant ship $ */
3
4 gUserID number ;
5 gLoginId number ;
6
7 /*-------------------------------------------------------------+
8 Name : Create_all_boms_and_routings
9 This procedure loops through all the configuration
10 items in bom_cto_order_lines and calls create_in_src_orgs
11 for each item.
12 +-------------------------------------------------------------*/
13
14 procedure create_all_boms_and_routings(
15 pAtoLineId in number, -- top ATO line id
16 pFlowCalc in number,
17 xReturnStatus out NOCOPY varchar2,
18 xMsgCount out NOCOPY number,
19 xMsgData out NOCOPY varchar2
20 );
21
22 /*-------------------------------------------------------------+
23 Name : create_in_src_orgs
24 This procedure creates a config item's bom and routing
25 in all of the proper sourcing orgs based on the base
26 model's sourcing rules.
27 +-------------------------------------------------------------*/
28
29 procedure create_in_src_orgs(
30 pLineId in number, -- Model Line ID
31 pModelId in number,
32 pConfigId in number,
33 pFlowCalc in number,
34 xReturnStatus out NOCOPY varchar2,
35 xMsgCount out NOCOPY number,
36 xMsgData out NOCOPY varchar2
37 );
38
39
40 /*-------------------------------------------------------------+
41 Name : update_atp
42 This function Obtains and passes the ATPable Mandatory
43 components for the config bom to ATP engine. lete successfully, it
44 calls re-scheduling API to reschedule order line if
45 needed.
46 +-------------------------------------------------------------*/
47 function update_atp( pLineId in number,
48 xErrorMessage out NOCOPY varchar2,
49 xMessageName out NOCOPY varchar2,
50 xTableName out NOCOPY varchar2)
51 return integer;
52
53 END CTO_BOM_RTG_PK;