PACKAGE: APPS.CTO_UPDATE_BOM_RTG_PK

Source

1 package CTO_UPDATE_BOM_RTG_PK AUTHID CURRENT_USER as
2 /* $Header: CTOUBOMS.pls 115.3 2004/01/22 19:45:57 ssawant noship $ */
3 
4 gDebugLevel NUMBER :=  to_number(nvl(FND_PROFILE.value('ONT_DEBUG_LEVEL'),0));
5 gDropItem	number	     := 1;
6 --gApplyHold	varchar2(1)  := 'N';
7 G_SUB_BATCH_SIZE NUMBER := 10;
8 
9 PROCEDURE Update_Boms_Rtgs(
10 	errbuf OUT NOCOPY varchar2,
11 	retcode OUT NOCOPY varchar2,
12 	p_seq IN number,
13 	p_changed_src IN varchar2);
14 
15 
16 PROCEDURE Update_In_Src_Orgs(
17         pLineId         in  number, -- Current Model Line ID
18         pModelId        in  number,
19         pConfigId       in  number,
20         pFlowCalc       in  number,
21         xReturnStatus   out NOCOPY varchar2,
22         xMsgCount       out NOCOPY number,
23         xMsgData        out NOCOPY varchar2
24         );
25 
26 
27 PROCEDURE WriteToLog (p_message in varchar2 default null,
28 		      p_level   in number default 0);
29 
30 
31 FUNCTION Update_Bom_Rtg_Loop(
32         pModelId        in       number,
33         pConfigId       in       number,
34         pOrgId          in       number,
35         pLineId         in       number,
36 	pLeadTime       in       number,
37 	pFlowCalc	in	 number,
38         xBillId         out NOCOPY   number,
39     	xRtgId	    	out NOCOPY   number,
40         xErrorMessage   out NOCOPY   varchar2 ,
41         xMessageName    out NOCOPY   varchar2 ,
42         xTableName      out NOCOPY   varchar2 )
43 return integer;
44 
45 
46 PROCEDURE Update_Bom_Rtg_Bulk(
47 	p_seq in number,
48 	xReturnStatus   out NOCOPY varchar2,
49         xMsgCount       out NOCOPY number,
50         xMsgData        out NOCOPY varchar2);
51 
52 
53 function get_model_lead_time
54 (       pModelId in number,
55         pOrgId   in number,
56         pQty     in number,
57         pLeadTime out NOCOPY number,
58         pErrBuf  out NOCOPY varchar2
59 )
60 return integer;
61 
62 
63 function inherit_op_seq_ml (
64   pLineId        in   oe_order_lines.line_id%TYPE := NULL,
65   pOrgId         in   oe_order_lines.ship_from_org_id%TYPE := NULL,
66   PModelId	 in   bom_bill_of_materials.assembly_item_id%TYPE := NULL,
67   pConfigBillId  in   bom_inventory_components.bill_sequence_id%TYPE := NULL,
68   xErrorMessage  out  NOCOPY VARCHAR2,
69   xMessageName   out  NOCOPY VARCHAR2)
70 return integer;
71 
72 
73 function bmlupid_update_item_desc
74 (
75         item_id                 NUMBER,
76         org_id                  NUMBER,
77         err_buf         out   NOCOPY VARCHAR2
78 )
79 return integer;
80 
81 function check_routing (
82         pItemId        in      number,
83         pOrgId         in      number,
84         xRtgId         out     NOCOPY number,
85         xRtgType       out     NOCOPY number)
86 return integer;
87 
88 function check_bom(
89         pItemId        in      number,
90         pOrgId         in      number,
91         xBillID        out     NOCOPY number)
92 return integer;
93 
94 END CTO_UPDATE_BOM_RTG_PK;