APPS.PO_AUTOCREATE_UTIL_PVT dependencies on PO_SESSION_GT

Line 14: --Modifies: PO_SESSION_GT

10: -----------------------------------------------------------------------
11: --Start of Comments
12: --Name: add_to_builder_reqs_gt
13: --Pre-reqs: None
14: --Modifies: PO_SESSION_GT
15: --Locks:
16: -- None
17: --Function:
18: -- Insert rows to PO_SESSION_GT. This is done to track builder reqs on

Line 18: -- Insert rows to PO_SESSION_GT. This is done to track builder reqs on

14: --Modifies: PO_SESSION_GT
15: --Locks:
16: -- None
17: --Function:
18: -- Insert rows to PO_SESSION_GT. This is done to track builder reqs on
19: -- the server side
20: --Parameters:
21: --IN:
22: --p_key

Line 23: -- key in PO_SESSION_GT

19: -- the server side
20: --Parameters:
21: --IN:
22: --p_key
23: -- key in PO_SESSION_GT
24: --p_req_list
25: -- table containing requisition_line_id
26: --IN OUT:
27: --OUT:

Line 41: INSERT INTO PO_SESSION_GT

37:
38: BEGIN
39:
40: FORALL i IN 1..p_req_list.COUNT
41: INSERT INTO PO_SESSION_GT
42: ( key,
43: index_num1
44: )
45: VALUES

Line 59: --Modifies: PO_SESSION_GT

55: -----------------------------------------------------------------------
56: --Start of Comments
57: --Name: add_to_builder_reqs_gt
58: --Pre-reqs: None
59: --Modifies: PO_SESSION_GT
60: --Locks:
61: -- None
62: --Function:
63: -- Synchronize PO_SESSION_GT with builder reqs. This procedure

Line 63: -- Synchronize PO_SESSION_GT with builder reqs. This procedure

59: --Modifies: PO_SESSION_GT
60: --Locks:
61: -- None
62: --Function:
63: -- Synchronize PO_SESSION_GT with builder reqs. This procedure
64: -- first cleans up the gt table and then insert into the table with the
65: -- rows passed in
66: --Parameters:
67: --IN:

Line 69: -- key in PO_SESSION_GT

65: -- rows passed in
66: --Parameters:
67: --IN:
68: --p_key
69: -- key in PO_SESSION_GT
70: --p_req_list
71: -- table containing requisition_line_id
72: --IN OUT:
73: --OUT:

Line 137: -- po_session_gt

133: --Name: add_req_lines_gt
134: --Pre-reqs:
135: -- None
136: --Modifies:
137: -- po_session_gt
138: --Locks:
139: -- None
140: --Function:
141: -- Adds the input table of numbers to the PO_SESSION_GT table and returns

Line 141: -- Adds the input table of numbers to the PO_SESSION_GT table and returns

137: -- po_session_gt
138: --Locks:
139: -- None
140: --Function:
141: -- Adds the input table of numbers to the PO_SESSION_GT table and returns
142: -- the GT key for which the values were added.
143: --Parameters:
144: --IN:
145: --p_req_line_id_tbl

Line 170: INSERT INTO po_session_gt

166: l_key := PO_CORE_S.get_session_gt_nextval;
167:
168: FORALL i IN 1..p_req_line_id_tbl.COUNT
169:
170: INSERT INTO po_session_gt
171: ( key
172: , index_num1
173: ) VALUES
174: ( l_key

Line 186: --Modifies: PO_SESSION_GT

182: -----------------------------------------------------------------------
183: --Start of Comments
184: --Name: clear_builder_reqs_gt
185: --Pre-reqs: None
186: --Modifies: PO_SESSION_GT
187: --Locks:
188: -- None
189: --Function:
190: -- Remove all builder reqs from PO_SESSION_GT table

Line 190: -- Remove all builder reqs from PO_SESSION_GT table

186: --Modifies: PO_SESSION_GT
187: --Locks:
188: -- None
189: --Function:
190: -- Remove all builder reqs from PO_SESSION_GT table
191: --Parameters:
192: --IN:
193: --p_key
194: -- key in PO_SESSION_GT

Line 194: -- key in PO_SESSION_GT

190: -- Remove all builder reqs from PO_SESSION_GT table
191: --Parameters:
192: --IN:
193: --p_key
194: -- key in PO_SESSION_GT
195: --IN OUT:
196: --OUT:
197: --Returns:
198: --Notes:

Line 209: DELETE FROM PO_SESSION_GT

205: )
206: IS
207: BEGIN
208:
209: DELETE FROM PO_SESSION_GT
210: WHERE key = p_key;
211:
212: END clear_builder_reqs_gt;
213:

Line 273: FROM po_session_gt selected

269: SELECT pool.requisition_line_id
270: BULK COLLECT INTO x_req_line_id_in_pool_tbl
271: FROM po_req_lines_in_pool_sec_v pool
272: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
273: FROM po_session_gt selected
274: WHERE selected.key = l_key
275: )
276: FOR UPDATE NOWAIT;
277:

Line 288: FROM po_session_gt selected

284: SELECT pool.requisition_line_id
285: BULK COLLECT INTO x_req_line_id_in_pool_tbl
286: FROM po_req_lines_in_pool_sec_v pool
287: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
288: FROM po_session_gt selected
289: WHERE selected.key = l_key
290: );
291:
292: END IF;