APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on DUAL

Line 466: --If item is dual uom control and secondary quantity is NULL, derive it

462: p_lines.amount_tbl(i) := l_cc_amount;
463:
464: END IF;
465: --
466: --If item is dual uom control and secondary quantity is NULL, derive it
467: l_progress:='130';
468: IF x_secondary_unit_of_measure IS NOT NULL THEN
469: IF p_lines.secondary_quantity_tbl(i) IS NULL THEN
470: PO_UOM_S.uom_convert (x_quantity,

Line 643: SELECT po_line_locations_s.nextval INTO x_line_location_id FROM sys.dual;

639: p_message => 'Create shipment: Create a new shipment');
640: END IF;
641:
642: l_progress:='240';
643: SELECT po_line_locations_s.nextval INTO x_line_location_id FROM sys.dual;
644:
645: -- Get the taxable_flag based on the following priority
646: -- 1. preferences (global.po_taxable_flag)
647: -- 2. ship_to_org (x_ship_to_org_taxable_flag)

Line 1715: FROM sys.dual;

1711: d_progress := 240;
1712: -- Bug9441838: Added variable to pass sequence current value
1713: SELECT PO_LINE_LOCATIONS_S.currval
1714: INTO x_line_location_id
1715: FROM sys.dual;
1716:
1717: IF (PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET')) THEN
1718: d_progress := 250;
1719: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'SHIPMENT', x_line_location_id);

Line 1829: SELECT po_line_locations_s.nextval INTO x_line_location_id FROM sys.dual;

1825: END IF;
1826:
1827: BEGIN
1828: l_progress := '030';
1829: SELECT po_line_locations_s.nextval INTO x_line_location_id FROM sys.dual;
1830:
1831: EXCEPTION
1832: WHEN OTHERS THEN
1833: IF g_debug_unexp THEN