APPS.IGC_CC_PO_INTERFACE_PKG dependencies on IGC_CC_ACCT_LINES

Line 214: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,

210:
211: PROCEDURE Initialize_Lines_Row(p_mode IN VARCHAR2,
212: p_po_header_id IN NUMBER,
213: p_org_id IN NUMBER,
214: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
215: p_po_lines_rec IN OUT NOCOPY po_lines_all%ROWTYPE,
216: p_yr_start_date IN DATE,
217: p_yr_end_date IN DATE)
218: IS

Line 293: /* tax_classif_code of igc_cc_acct_lines is assigned to tax_name of po_lines_all

289: l_po_lines_rec.taxable_flag := p_cc_acct_lines_rec.cc_acct_taxable_flag ;
290:
291: l_po_lines_rec.tax_name := p_cc_acct_lines_rec.tax_classif_code;
292:
293: /* tax_classif_code of igc_cc_acct_lines is assigned to tax_name of po_lines_all
294: for r12 EBtax uptake for CC */
295:
296: /* Commented for bug 6472296 - r12 EBtax uptake for CC
297: BEGIN

Line 300: FROM igc_cc_acct_lines ccal,

296: /* Commented for bug 6472296 - r12 EBtax uptake for CC
297: BEGIN
298: SELECT apt.name,ccal.tax_id
299: INTO l_po_lines_rec.tax_name, l_po_lines_rec.tax_code_id
300: FROM igc_cc_acct_lines ccal,
301: ap_tax_codes apt
302: WHERE ccal.cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id
303: AND apt.tax_id = ccal.tax_id;
304: EXCEPTION -- 3326801

Line 600: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,

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 )
604: IS

Line 781: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;

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;
785: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

Line 828: FROM igc_cc_acct_lines

824: /* Contract Commitment account lines */
825:
826: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
827: SELECT *
828: FROM igc_cc_acct_lines
829: WHERE cc_header_id = t_cc_header_id;
830:
831: BEGIN
832: -- Bug 3605536 GSCC Warnings fixed

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 1173: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;

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;
1177: l_po_lines_rec po_lines_all%ROWTYPE;

Line 1235: FROM igc_cc_acct_lines ccac

1231: /* Contract Commitment account lines */
1232:
1233: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
1234: SELECT *
1235: FROM igc_cc_acct_lines ccac
1236: WHERE ccac.cc_header_id = t_cc_header_id;
1237:
1238:
1239: BEGIN

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