eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_REP_YEP_PVT dependencies on IGC_CC_ACCT_LINES

Line 285: FROM IGC_CC_ACCT_LINES

281: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
282:
283: CURSOR C4(HEADER_ID NUMBER) IS
284: SELECT *
285: FROM IGC_CC_ACCT_LINES
286: WHERE IGC_CC_ACCT_LINES.CC_HEADER_ID = HEADER_ID;
287:
288: CURSOR C5(ACCT_LINE_ID NUMBER) IS
289: SELECT *

Line 286: WHERE IGC_CC_ACCT_LINES.CC_HEADER_ID = HEADER_ID;

282:
283: CURSOR C4(HEADER_ID NUMBER) IS
284: SELECT *
285: FROM IGC_CC_ACCT_LINES
286: WHERE IGC_CC_ACCT_LINES.CC_HEADER_ID = HEADER_ID;
287:
288: CURSOR C5(ACCT_LINE_ID NUMBER) IS
289: SELECT *
290: FROM IGC_CC_DET_PF_V

Line 2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,

2515: -- p_req_encumbrance_type_id IN financials_system_params_all.req_encumbrance_type_id%TYPE,
2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
2517: p_currency_code IN VARCHAR2,
2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
2520: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
2521: p_mode IN VARCHAR2,
2522: p_type IN VARCHAR2,
2523: p_process_type IN VARCHAR2,

Line 2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;

2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;
2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;
2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;
2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
2566:
2567:

Line 2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;

2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;
2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;
2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
2566:
2567:
2568: /* Begin for fix for bug 1689924*/

Line 2570: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

2566:
2567:
2568: /* Begin for fix for bug 1689924*/
2569: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2570: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
2571: /* End for fix for bug 1689924*/
2572: P_Error_Code VARCHAR2(32); /*EB Tax uptake - Bug No : 6472296*/
2573: l_taxable_flag VARCHAR2(2); /*Bug 6472296 EB Tax uptake - CC*/
2574:

Line 2587: FROM igc_cc_acct_lines

2583: WHERE cc_header_id = p_cc_headers_rec.parent_header_id;
2584:
2585: SELECT cc_acct_desc, cc_budget_code_combination_id
2586: INTO l_cover_cc_acct_desc, l_cover_budg_code_comb_id
2587: FROM igc_cc_acct_lines
2588: WHERE cc_acct_line_id = p_cc_acct_lines_rec.parent_acct_line_id;
2589: END IF;
2590:
2591: l_cc_interface_rec.cbc_result_code := NULL;

Line 2698: FROM igc_cc_acct_lines_v

2694: -- below.
2695: /*
2696: SELECT cc_acct_func_amt , cc_acct_func_billed_amt
2697: INTO l_func_amt, l_func_billed_amt
2698: FROM igc_cc_acct_lines_v
2699: WHERE cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id;
2700: */
2701: SELECT Nvl(cc_acct_func_amt,0) , Nvl(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)
2702: INTO l_func_amt, l_func_billed_amt

Line 2703: FROM igc_cc_acct_lines ccal

2699: WHERE cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id;
2700: */
2701: SELECT Nvl(cc_acct_func_amt,0) , Nvl(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)
2702: INTO l_func_amt, l_func_billed_amt
2703: FROM igc_cc_acct_lines ccal
2704: WHERE ccal.cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id;
2705:
2706: l_unbilled_amt := l_func_amt - l_func_billed_amt;
2707:

Line 3437: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;

3433: IS
3434: l_interface_row_count NUMBER;
3435: l_insert_status VARCHAR2(1);
3436: l_cc_headers_rec igc_cc_headers%ROWTYPE;
3437: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
3438: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
3439:
3440: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
3441:

Line 3468: FROM igc_cc_acct_lines ccac

3464: /* Contract Commitment account lines */
3465:
3466: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
3467: SELECT *
3468: FROM igc_cc_acct_lines ccac
3469: WHERE ccac.cc_header_id = t_cc_header_id;
3470:
3471: BEGIN
3472: SAVEPOINT Execute_Budgetary_Ctrl1;