APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_ONLINE_REPORT_TEXT

Line 131: -- PO_ONLINE_REPORT_TEXT.

127: --Pre-reqs:
128: -- FND_MSG_PUB has been initialized if p_init_msg_list is false.
129: --Modifies:
130: -- All columns related to the control action, and WHO columns.
131: -- PO_ONLINE_REPORT_TEXT.
132: -- FND_MSG_PUB.
133: --Locks:
134: -- Document at header level, and at entity level(s) specified.
135: --Function:

Line 3862: * Effects: Retrieves all text lines from PO_ONLINE_REPORT_TEXT for

3858: /**
3859: * Public Procedure: add_online_report_msgs
3860: * Requires: API message list has been initialized if p_init_msg_list is false.
3861: * Modifies: API message list
3862: * Effects: Retrieves all text lines from PO_ONLINE_REPORT_TEXT for
3863: * p_online_report_id, and appends each one to the API message list. Does not
3864: * append to API message list upon expected error, just unexpected error.
3865: * Returns:
3866: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

Line 3881: FROM po_online_report_text poort

3877: l_api_name CONSTANT VARCHAR2(30) := 'add_online_report_msgs';
3878: l_api_version CONSTANT NUMBER := 1.0;
3879: CURSOR l_get_online_report_csr IS
3880: SELECT poort.text_line
3881: FROM po_online_report_text poort
3882: WHERE poort.online_report_id = p_online_report_id;
3883: TYPE text_line_tbl_type IS TABLE OF PO_ONLINE_REPORT_TEXT.text_line%TYPE
3884: INDEX BY BINARY_INTEGER;
3885: l_text_line_tbl text_line_tbl_type;

Line 3883: TYPE text_line_tbl_type IS TABLE OF PO_ONLINE_REPORT_TEXT.text_line%TYPE

3879: CURSOR l_get_online_report_csr IS
3880: SELECT poort.text_line
3881: FROM po_online_report_text poort
3882: WHERE poort.online_report_id = p_online_report_id;
3883: TYPE text_line_tbl_type IS TABLE OF PO_ONLINE_REPORT_TEXT.text_line%TYPE
3884: INDEX BY BINARY_INTEGER;
3885: l_text_line_tbl text_line_tbl_type;
3886:
3887: BEGIN

Line 4200: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

4196: l_exc_msg VARCHAR2(2000);
4197: l_launch_approvals_flag VARCHAR2(1);
4198: l_msg_count NUMBER;
4199: l_msg_data VARCHAR2(2000);
4200: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4201: l_return_code VARCHAR2(25);
4202: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;
4203: d_pos NUMBER;
4204: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';