APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 603: p_po_dist_rec IN OUT NOCOPY po_distributions_all%ROWTYPE )

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;
607: BEGIN

Line 605: l_po_dist_rec po_distributions_all%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;
607: BEGIN
608: IF (p_mode = 'I') THEN
609: SELECT po_distributions_s.nextval

Line 1179: l_po_dist_rec po_distributions_all%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:
1183: l_new_account_line BOOLEAN;

Line 1635: /* Check PO_DISTRIBUTIONS_ALL for the record */

1631:
1632: LOOP
1633: FETCH c_payment_forecast INTO l_cc_pmt_fcst_rec;
1634: EXIT WHEN c_payment_forecast%NOTFOUND;
1635: /* Check PO_DISTRIBUTIONS_ALL for the record */
1636: l_new_payment_forecast_line := FALSE;
1637:
1638: BEGIN
1639:

Line 1643: po_distributions_all pod

1639:
1640: SELECT *
1641: INTO l_po_dist_rec
1642: FROM
1643: po_distributions_all pod
1644: WHERE
1645: pod.po_header_id = l_po_headers_rec.po_header_id AND
1646: pod.po_line_id = l_po_lines_rec.po_line_id AND
1647: pod.line_location_id = l_po_line_locs_rec.line_location_id AND