DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_TBL_NUMBER

Line 22: -- p_req_header_id_tbl IN PO_TBL_NUMBER Required

18: -- p_employee_id IN NUMBER Required
19: -- The employee_id to whom we will send a notification.
20: -- p_grouping_method IN varchar2 Required
21: -- The req grouping selected from the UI
22: -- p_req_header_id_tbl IN PO_TBL_NUMBER Required
23: -- The table containing the req_header_id column.
24: -- OUT : x_result OUT NUMBER
25: -- x_error_message OUT VARCHAR2
26: -- x_online_report_id_tbl OUT PO_TBL_NUMBER

Line 26: -- x_online_report_id_tbl OUT PO_TBL_NUMBER

22: -- p_req_header_id_tbl IN PO_TBL_NUMBER Required
23: -- The table containing the req_header_id column.
24: -- OUT : x_result OUT NUMBER
25: -- x_error_message OUT VARCHAR2
26: -- x_online_report_id_tbl OUT PO_TBL_NUMBER
27: -- The online report ids that have been generated.
28: -- x_req_header_id_succ_tbl OUT PO_TBL_NUMBER
29: -- Contains all the header_ids of the successful reqs.
30: -- Version : Current version 1.0

Line 28: -- x_req_header_id_succ_tbl OUT PO_TBL_NUMBER

24: -- OUT : x_result OUT NUMBER
25: -- x_error_message OUT VARCHAR2
26: -- x_online_report_id_tbl OUT PO_TBL_NUMBER
27: -- The online report ids that have been generated.
28: -- x_req_header_id_succ_tbl OUT PO_TBL_NUMBER
29: -- Contains all the header_ids of the successful reqs.
30: -- Version : Current version 1.0
31: -- Previous version 1.0
32: -- Initial version 1.0

Line 40: p_req_header_id_tbl IN PO_TBL_NUMBER,

36: x_result OUT NOCOPY NUMBER,
37: x_error_message OUT NOCOPY VARCHAR2,
38: p_reason IN VARCHAR2 := NULL,
39: p_employee_id IN NUMBER,
40: p_req_header_id_tbl IN PO_TBL_NUMBER,
41: x_online_report_id_tbl OUT NOCOPY PO_TBL_NUMBER,
42: x_req_header_id_succ_tbl OUT NOCOPY PO_TBL_NUMBER
43: ) IS
44: -- Standard api variables

Line 41: x_online_report_id_tbl OUT NOCOPY PO_TBL_NUMBER,

37: x_error_message OUT NOCOPY VARCHAR2,
38: p_reason IN VARCHAR2 := NULL,
39: p_employee_id IN NUMBER,
40: p_req_header_id_tbl IN PO_TBL_NUMBER,
41: x_online_report_id_tbl OUT NOCOPY PO_TBL_NUMBER,
42: x_req_header_id_succ_tbl OUT NOCOPY PO_TBL_NUMBER
43: ) IS
44: -- Standard api variables
45: l_api_name CONSTANT VARCHAR2(30) := 'po_request_action_bulk';

Line 42: x_req_header_id_succ_tbl OUT NOCOPY PO_TBL_NUMBER

38: p_reason IN VARCHAR2 := NULL,
39: p_employee_id IN NUMBER,
40: p_req_header_id_tbl IN PO_TBL_NUMBER,
41: x_online_report_id_tbl OUT NOCOPY PO_TBL_NUMBER,
42: x_req_header_id_succ_tbl OUT NOCOPY PO_TBL_NUMBER
43: ) IS
44: -- Standard api variables
45: l_api_name CONSTANT VARCHAR2(30) := 'po_request_action_bulk';
46: l_api_version CONSTANT NUMBER := 1.0;

Line 144: x_online_report_id_tbl := PO_TBL_NUMBER();

140: l_out_online_count := 0;
141: l_out_header_count := 0;
142:
143: -- Initialise the two tables
144: x_online_report_id_tbl := PO_TBL_NUMBER();
145: x_req_header_id_succ_tbl := PO_TBL_NUMBER();
146:
147:
148: --

Line 145: x_req_header_id_succ_tbl := PO_TBL_NUMBER();

141: l_out_header_count := 0;
142:
143: -- Initialise the two tables
144: x_online_report_id_tbl := PO_TBL_NUMBER();
145: x_req_header_id_succ_tbl := PO_TBL_NUMBER();
146:
147:
148: --
149: -- Use PO_DOCUMENT_ACTION_PVT.do_return instead of po_request_action call