APPS.IGC_CC_PO_INTERFACE_PKG dependencies on IGC_CC_HEADERS

Line 11: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,

7: g_debug_flag VARCHAR2(1);
8:
9: PROCEDURE Initialize_Header_Row(p_mode IN VARCHAR2,
10: p_encumbrance_on IN VARCHAR2,
11: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
12: p_po_headers_rec IN OUT NOCOPY po_headers_all%ROWTYPE)
13: IS
14:
15: l_po_headers_rec po_headers_all%ROWTYPE;

Line 599: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,

595:
596:
597: PROCEDURE Initialize_Distributions_Row(p_mode IN VARCHAR2,
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 )

Line 780: l_cc_headers_rec igc_cc_headers%ROWTYPE;

776:
777: l_api_name CONSTANT VARCHAR2(30) := 'Update_PO_Approved_Flag';
778: l_api_version CONSTANT NUMBER := 1.0;
779:
780: l_cc_headers_rec igc_cc_headers%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;

Line 865: FROM igc_cc_headers

861:
862: BEGIN
863:
864: SELECT * INTO l_cc_headers_rec
865: FROM igc_cc_headers
866: WHERE cc_header_id = p_cc_header_id;
867:
868: EXCEPTION
869: WHEN no_data_found

Line 908: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c

904: l_curr_year_pf_lines := 0;
905:
906: SELECT count(cc_det_pf_line_id)
907: INTO l_curr_year_pf_lines
908: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c
909: WHERE
910: NVL(a.cc_det_pf_date,l_end_date + 1) <= l_end_date AND
911: a.cc_acct_line_id = b.cc_acct_line_id AND
912: b.cc_header_id = c.cc_header_id AND

Line 1172: l_cc_headers_rec igc_cc_headers%ROWTYPE;

1168:
1169: l_api_name CONSTANT VARCHAR2(30) := 'Convert_CC_To_PO';
1170: l_api_version CONSTANT NUMBER := 1.0;
1171:
1172: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1173: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
1174: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
1175:
1176: l_po_headers_rec po_headers_all%ROWTYPE;

Line 1275: FROM igc_cc_headers

1271:
1272: BEGIN
1273:
1274: SELECT * INTO l_cc_headers_rec
1275: FROM igc_cc_headers
1276: WHERE cc_header_id = p_cc_header_id;
1277:
1278: EXCEPTION
1279: WHEN no_data_found

Line 1392: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c

1388: /* begin fix for bug 1578214 */
1389:
1390: SELECT count(cc_det_pf_line_id)
1391: INTO l_curr_year_pf_lines
1392: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c
1393: WHERE
1394: NVL(a.cc_det_pf_date,l_end_date + 1) <= l_end_date AND
1395: a.cc_acct_line_id = b.cc_acct_line_id AND
1396: b.cc_header_id = c.cc_header_id AND

Line 1944: l_cc_headers_rec igc_cc_headers%ROWTYPE;

1940:
1941: l_api_name CONSTANT VARCHAR2(30) := 'Lock_PO_Row';
1942: l_api_version CONSTANT NUMBER := 1.0;
1943:
1944: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1945: e_cc_not_found EXCEPTION;
1946: e_po_not_found EXCEPTION;
1947:
1948:

Line 1990: FROM igc_cc_headers

1986:
1987: BEGIN
1988:
1989: SELECT * INTO l_cc_headers_rec
1990: FROM igc_cc_headers
1991: WHERE cc_header_id = p_cc_header_id;
1992:
1993: EXCEPTION
1994: WHEN no_data_found