APPS.PO_REQAPPROVAL_ACTION dependencies on PO_ONLINE_REPORT_TEXT

Line 1740: FROM PO_ONLINE_REPORT_TEXT

1736: SELECT 'E'
1737: INTO l_error
1738: FROM dual
1739: WHERE EXISTS (SELECT 1
1740: FROM PO_ONLINE_REPORT_TEXT
1741: WHERE online_report_id = x_online_report_id
1742: AND NVL(message_type, 'E') = 'E'); -- Bug 3906870
1743: EXCEPTION
1744: WHEN NO_DATA_FOUND THEN

Line 3075: FROM po_online_report_text

3071:
3072: -- Bulk collect text lines for the online report in question.
3073: SELECT substr(text_line, 1, 2000)
3074: BULK COLLECT INTO l_report_text_lines
3075: FROM po_online_report_text
3076: WHERE online_report_id = p_online_report_id
3077: ORDER BY sequence;
3078:
3079: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.020.ON_LINE_REPORT_ID= '

Line 3354: -- po_online_report_text table

3350: -- None.
3351: --Modifies:
3352: -- Creates encumbrance entries in the gl_bc_packets table
3353: -- Adds distribution-specific transaction information into the
3354: -- po_online_report_text table
3355: --Locks:
3356: -- None.
3357: --Function:
3358: -- Calls PO_DOCUMENT_FUNDS_PVT.do_reserve as an autonomous call

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

3379: --x_po_return_code
3380: -- Indicates whether PO is classifying this transaction as an
3381: -- Error/Warning/Partial Success/Success
3382: --x_online_report_id
3383: -- Unique id into po_online_report_text rows that store distribution specific
3384: -- reporting information for a specific encumbrance transaction
3385: --Testing:
3386: --
3387: --End of Comments

Line 3710: -- in PO_ONLINE_REPORT_TEXT

3706: );
3707:
3708: -- bug3539651
3709: -- Issue a commit instead of rollback, otherwise we will lose all the data
3710: -- in PO_ONLINE_REPORT_TEXT
3711: COMMIT;
3712:
3713:
3714: END po_submission_check_autonomous;