APPS.PO_REQAPPROVAL_ACTION dependencies on PO_ONLINE_REPORT_TEXT

Line 1873: FROM PO_ONLINE_REPORT_TEXT

1869: SELECT 'E'
1870: INTO l_error
1871: FROM dual
1872: WHERE EXISTS (SELECT 1
1873: FROM PO_ONLINE_REPORT_TEXT
1874: WHERE online_report_id = x_online_report_id
1875: AND NVL(message_type, 'E') = 'E'); -- Bug 3906870
1876: EXCEPTION
1877: WHEN NO_DATA_FOUND THEN

Line 3310: FROM po_online_report_text

3306:
3307: -- Bulk collect text lines for the online report in question.
3308: SELECT substr(text_line, 1, 2000)
3309: BULK COLLECT INTO l_report_text_lines
3310: FROM po_online_report_text
3311: WHERE online_report_id = p_online_report_id
3312: ORDER BY sequence;
3313:
3314: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.020.ON_LINE_REPORT_ID= '

Line 3589: -- po_online_report_text table

3585: -- None.
3586: --Modifies:
3587: -- Creates encumbrance entries in the gl_bc_packets table
3588: -- Adds distribution-specific transaction information into the
3589: -- po_online_report_text table
3590: --Locks:
3591: -- None.
3592: --Function:
3593: -- Calls PO_DOCUMENT_FUNDS_PVT.do_reserve as an autonomous call

Line 3618: -- Unique id into po_online_report_text rows that store distribution specific

3614: --x_po_return_code
3615: -- Indicates whether PO is classifying this transaction as an
3616: -- Error/Warning/Partial Success/Success
3617: --x_online_report_id
3618: -- Unique id into po_online_report_text rows that store distribution specific
3619: -- reporting information for a specific encumbrance transaction
3620: --Testing:
3621: --
3622: --End of Comments

Line 3961: -- in PO_ONLINE_REPORT_TEXT

3957: );
3958:
3959: -- bug3539651
3960: -- Issue a commit instead of rollback, otherwise we will lose all the data
3961: -- in PO_ONLINE_REPORT_TEXT
3962: COMMIT;
3963:
3964:
3965: END po_submission_check_autonomous;