APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 432: p_po_line_locs_rec IN OUT NOCOPY po_line_locations_all%ROWTYPE)

428: PROCEDURE Initialize_Line_Locs_Row(p_mode IN VARCHAR2,
429: p_encumbrance_on IN VARCHAR2,
430: p_po_headers_rec IN po_headers_all%ROWTYPE,
431: p_po_lines_rec IN po_lines_all%ROWTYPE,
432: p_po_line_locs_rec IN OUT NOCOPY po_line_locations_all%ROWTYPE)
433: IS
434: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
435:
436: BEGIN

Line 434: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

430: p_po_headers_rec IN po_headers_all%ROWTYPE,
431: p_po_lines_rec IN po_lines_all%ROWTYPE,
432: p_po_line_locs_rec IN OUT NOCOPY po_line_locations_all%ROWTYPE)
433: IS
434: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
435:
436: BEGIN
437: /* Insert */
438: IF (p_mode = 'I') THEN

Line 602: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE,

598: p_encumbrance_on IN VARCHAR2,
599: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
600: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
601: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
602: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE,
603: p_po_dist_rec IN OUT NOCOPY po_distributions_all%ROWTYPE )
604: IS
605: l_po_dist_rec po_distributions_all%ROWTYPE;
606: E_CC_GL_PERIOD EXCEPTION;

Line 785: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

781: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
782:
783: l_po_headers_rec po_headers_all%ROWTYPE;
784: l_po_lines_rec po_lines_all%ROWTYPE;
785: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
786:
787: l_po_found BOOLEAN;
788: l_new_account_line BOOLEAN;
789: l_encumbrance_on VARCHAR2(1);

Line 1062: FROM po_line_locations_all pll

1058: THEN
1059: BEGIN
1060:
1061: SELECT * INTO l_po_line_locs_rec
1062: FROM po_line_locations_all pll
1063: WHERE
1064: pll.po_header_id = l_po_headers_rec.po_header_id AND
1065: pll.po_line_id = l_po_lines_rec.po_line_id;
1066: EXCEPTION

Line 1178: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

1174: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
1175:
1176: l_po_headers_rec po_headers_all%ROWTYPE;
1177: l_po_lines_rec po_lines_all%ROWTYPE;
1178: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
1179: l_po_dist_rec po_distributions_all%ROWTYPE;
1180:
1181: l_encumbered_period_name gl_periods.period_name%TYPE;
1182:

Line 1467: FROM po_line_locations_all pll

1463: BEGIN
1464:
1465: SELECT *
1466: INTO l_po_line_locs_rec
1467: FROM po_line_locations_all pll
1468: WHERE pll.po_header_id = l_po_headers_rec.po_header_id
1469: AND pll.po_line_id = l_po_lines_rec.po_line_id;
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND

Line 1803: /* Insert row into PO_LINE_LOCATIONS_ALL */

1799: THEN
1800: RAISE e_internal_error;
1801: END IF;
1802:
1803: /* Insert row into PO_LINE_LOCATIONS_ALL */
1804:
1805: Initialize_Line_Locs_Row('I',
1806: l_encumbrance_on,
1807: l_po_headers_rec,