APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_ONLINE_REPORT_TEXT

Line 367: -- PO_ONLINE_REPORT_TEXT.

363: --Pre-reqs:
364: -- FND_MSG_PUB has been initialized if p_init_msg_list is false.
365: --Modifies:
366: -- All columns related to the control action, and WHO columns.
367: -- PO_ONLINE_REPORT_TEXT.
368: -- FND_MSG_PUB.
369: --Locks:
370: -- Document at header level, and at entity level(s) specified.
371: --Function:

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

3725: /**
3726: * Public Procedure: add_online_report_msgs
3727: * Requires: API message list has been initialized if p_init_msg_list is false.
3728: * Modifies: API message list
3729: * Effects: Retrieves all text lines from PO_ONLINE_REPORT_TEXT for
3730: * p_online_report_id, and appends each one to the API message list. Does not
3731: * append to API message list upon expected error, just unexpected error.
3732: * Returns:
3733: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

Line 3748: FROM po_online_report_text poort

3744: l_api_name CONSTANT VARCHAR2(30) := 'add_online_report_msgs';
3745: l_api_version CONSTANT NUMBER := 1.0;
3746: CURSOR l_get_online_report_csr IS
3747: SELECT poort.text_line
3748: FROM po_online_report_text poort
3749: WHERE poort.online_report_id = p_online_report_id;
3750: TYPE text_line_tbl_type IS TABLE OF PO_ONLINE_REPORT_TEXT.text_line%TYPE
3751: INDEX BY BINARY_INTEGER;
3752: l_text_line_tbl text_line_tbl_type;

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

3746: CURSOR l_get_online_report_csr IS
3747: SELECT poort.text_line
3748: FROM po_online_report_text poort
3749: WHERE poort.online_report_id = p_online_report_id;
3750: TYPE text_line_tbl_type IS TABLE OF PO_ONLINE_REPORT_TEXT.text_line%TYPE
3751: INDEX BY BINARY_INTEGER;
3752: l_text_line_tbl text_line_tbl_type;
3753:
3754: BEGIN

Line 4039: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

4035: l_busdocdates_tbl busdocdates_tbl_type;
4036: l_exc_msg VARCHAR2(2000);
4037: l_msg_count NUMBER;
4038: l_msg_data VARCHAR2(2000);
4039: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4040: l_return_code VARCHAR2(25);
4041: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;
4042: d_pos NUMBER;
4043: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';