APPS.PO_COPYDOC_S1 dependencies on DUAL

Line 483: --SELECT po_ame_approvals_s.NEXTVAL into l_ame_approval_id FROM dual;

479: p_message => 'header ID: '||x_po_header_record.po_header_id||
480: ' online_report ID: '||x_online_report_id);
481: END IF;
482:
483: --SELECT po_ame_approvals_s.NEXTVAL into l_ame_approval_id FROM dual;
484: /* PO AME Approval workflow change : Fetch next sequence value of ame_approval_id
485: in case AME transaction type is populated in Style Headers page*/
486: -- Start : PO AME Approval workflow
487: l_ame_approval_id := null;

Line 1611: -- if item is dual uom control , derive shipment secondary quantity and

1607:
1608: l_progress := '130';
1609:
1610: --
1611: -- if item is dual uom control , derive shipment secondary quantity and
1612: -- secondary uom if it is null
1613: x_secondary_unit_of_measure := x_po_shipment_record.secondary_unit_of_measure ;
1614: x_secondary_quantity := x_po_shipment_record.secondary_quantity ;
1615:

Line 3594: FROM SYS.DUAL;

3590: x_progress := '000';
3591: BEGIN
3592: SELECT po_online_report_text_s.nextval
3593: INTO x_online_report_id
3594: FROM SYS.DUAL;
3595: EXCEPTION
3596: WHEN OTHERS THEN
3597: x_online_report_id := NULL;
3598: po_copydoc_s1.COPYDOC_sql_error('copy_documents', x_progress, sqlcode,