APPS.PO_AUTOCREATE_UTIL_PVT dependencies on PO_TBL_NUMBER

Line 35: p_req_list IN PO_TBL_NUMBER

31: --End of Comments
32: -----------------------------------------------------------------------
33: PROCEDURE add_to_builder_reqs_gt
34: ( p_key IN NUMBER,
35: p_req_list IN PO_TBL_NUMBER
36: ) IS
37:
38: BEGIN
39:

Line 81: p_req_list IN PO_TBL_NUMBER

77: --End of Comments
78: -----------------------------------------------------------------------
79: PROCEDURE synchronize_builder_reqs
80: ( p_key IN NUMBER,
81: p_req_list IN PO_TBL_NUMBER
82: ) IS
83:
84: l_api_name CONSTANT VARCHAR2(30) := 'synchronize_builder_reqs';
85: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

Line 146: -- PO_TBL_NUMBER of Requisition Line IDs to add to the GT table

142: -- the GT key for which the values were added.
143: --Parameters:
144: --IN:
145: --p_req_line_id_tbl
146: -- PO_TBL_NUMBER of Requisition Line IDs to add to the GT table
147: --Returns:
148: -- NUMBER representing the key value for which the input values were added
149: --Notes:
150: -- None

Line 158: p_req_line_id_tbl IN PO_TBL_NUMBER

154: -------------------------------------------------------------------------------
155: -------------------------------------------------------------------------------
156: FUNCTION add_req_lines_gt
157: (
158: p_req_line_id_tbl IN PO_TBL_NUMBER
159: )
160: RETURN NUMBER
161: IS
162: l_key NUMBER;

Line 230: -- PO_TBL_NUMBER of Requisition Line IDs to add to the GT table

226: -- nested table and are in the Req Pool.
227: --Parameters:
228: --IN:
229: --p_req_line_id_tbl
230: -- PO_TBL_NUMBER of Requisition Line IDs to add to the GT table
231: --p_lock_records
232: -- 'Y' or 'N' indicating whether to lock the records that are being retrieved
233: --OUT:
234: --x_req_line_id_in_pool_tbl

Line 235: -- PO_TBL_NUMBER of Req Line IDs which exist in the input nested table

231: --p_lock_records
232: -- 'Y' or 'N' indicating whether to lock the records that are being retrieved
233: --OUT:
234: --x_req_line_id_in_pool_tbl
235: -- PO_TBL_NUMBER of Req Line IDs which exist in the input nested table
236: -- as well as the Req Pool
237: --x_records_locked
238: -- BOOLEAN indicating whether the records were successfully locked
239: --Notes:

Line 248: p_req_line_id_tbl IN PO_TBL_NUMBER

244: -------------------------------------------------------------------------------
245: -------------------------------------------------------------------------------
246: PROCEDURE get_and_lock_req_lines_in_pool
247: (
248: p_req_line_id_tbl IN PO_TBL_NUMBER
249: , p_lock_records IN VARCHAR2
250: , x_req_line_id_in_pool_tbl OUT NOCOPY PO_TBL_NUMBER
251: , x_records_locked OUT NOCOPY VARCHAR2
252: )

Line 250: , x_req_line_id_in_pool_tbl OUT NOCOPY PO_TBL_NUMBER

246: PROCEDURE get_and_lock_req_lines_in_pool
247: (
248: p_req_line_id_tbl IN PO_TBL_NUMBER
249: , p_lock_records IN VARCHAR2
250: , x_req_line_id_in_pool_tbl OUT NOCOPY PO_TBL_NUMBER
251: , x_records_locked OUT NOCOPY VARCHAR2
252: )
253: IS
254: l_key NUMBER;