DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on DUAL

Line 28: FROM dual;

24:
25: IF (p_mode = 'I') THEN
26: SELECT po_headers_s.NEXTVAL
27: INTO l_po_headers_rec.po_header_id
28: FROM dual;
29: ELSE
30: /* Update */
31: l_po_headers_rec := p_po_headers_rec;
32: END IF;

Line 237: FROM dual;

233: /* Insert */
234: IF (p_mode = 'I') THEN
235: SELECT po_lines_s.NEXTVAL
236: INTO l_po_lines_rec.po_line_id
237: FROM dual;
238: ELSE
239: /* Update */
240: l_po_lines_rec := p_po_lines_rec;
241: END IF;

Line 441: FROM DUAL;

437: /* Insert */
438: IF (p_mode = 'I') THEN
439: SELECT po_line_locations_s.nextval
440: INTO l_po_line_locs_rec.line_location_id
441: FROM DUAL;
442: ELSE
443: l_po_line_locs_rec := p_po_line_locs_rec;
444: END IF;
445:

Line 611: FROM DUAL;

607: BEGIN
608: IF (p_mode = 'I') THEN
609: SELECT po_distributions_s.nextval
610: INTO l_po_dist_rec.po_distribution_id
611: FROM DUAL;
612: ELSE
613: l_po_dist_rec := p_po_dist_rec ; /* CC */
614: END IF;
615: