[Home] [Help]
8: |FILE NAME : CTOUTILS.pls
9: |
10: |DESCRIPTION : Contains modules to :
11: | 1. Populate temporary tables bom_cto_order_lines and
12: | bom_cto_src_orgs, used for intermediate CTO processing
13: | 2. Update these tables with the config_item_id
14: | 3. Copy sourcing rule assignments from model to config item
15: |
16: |HISTORY : Created on 04-MAY-2000 by Sajani Sheth
98:
99:
100: /*--------------------------------------------------------------------------+
101: This function identifies the model items for which configuration items need
102: to be created and populates the temporary table bom_cto_src_orgs with all the
103: organizations that each configuration item needs to be created in.
104: +-------------------------------------------------------------------------*/
105: FUNCTION Populate_Src_Orgs( pTopAtoLineId in number,
106: x_return_status out NOCOPY varchar2,
109: RETURN integer;
110:
111:
112: /*--------------------------------------------------------------------------+
113: This function populates the table bom_cto_src_orgs with all the organizations
114: in which a configuration item needs to be created.
115: The organizations include all potential sourcing orgs, receiving orgs,
116: OE validation org and PO validation org.
117: The line_id, rcv_org_id, organization_id combination is unique.
137: RETURN integer;
138:
139:
140: /*--------------------------------------------------------------------------+
141: This function updates table bom_cto_src_orgs with the config_item_id for
142: a given model item.
143: It is called by "Match" and "Create_Item" programs.
144: +-------------------------------------------------------------------------*/
145: FUNCTION Update_Src_Orgs(pLineId in number,
269:
270:
271:
272: PROCEDURE GENERATE_BOM_ATTACH_TEXT
273: (p_line_id bom_cto_src_orgs.line_id%type ,
274: x_text in out NOCOPY long,
275: x_return_status out NOCOPY Varchar2
276: );
277: