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_BUDGETARY_CTRL_PKG dependencies on IGC_CC_ACCT_LINES_V

Line 511: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

507: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Rel_Budgetary_Ctrl';
508: l_api_version CONSTANT NUMBER := 1.0;
509:
510: l_cc_headers_rec igc_cc_headers%ROWTYPE;
511: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
513:
514: l_transaction_date DATE;
515:

Line 516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
513:
514: l_transaction_date DATE;
515:
516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
518:
519: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
520: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

Line 517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

513:
514: l_transaction_date DATE;
515:
516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
518:
519: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
520: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
521:

Line 552: -- FROM igc_cc_acct_lines_v ccac

548:
549: -- Bug 2885953 - amended cursor below for performance enhancements
550: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
551: -- SELECT *
552: -- FROM igc_cc_acct_lines_v ccac
553: -- WHERE ccac.cc_header_id = t_cc_header_id;
554: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
555: SELECT ccac.ROWID,
556: ccac.cc_header_id,

Line 806: -- igc_cc_acct_lines_v with

802:
803: l_billed_amt := 0;
804: l_func_billed_amt := 0;
805: -- Performance Tuning, Replaced view
806: -- igc_cc_acct_lines_v with
807: -- igc_cc_acct_lines and replaced the line
808: -- below.
809: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt
810: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 1430: p_cc_acct_lines_rec IN igc_cc_acct_lines_v%ROWTYPE,

1426:
1427: PROCEDURE Process_Interface_Row(
1428: p_currency_code IN VARCHAR2,
1429: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
1430: p_cc_acct_lines_rec IN igc_cc_acct_lines_v%ROWTYPE,
1431: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,
1432: p_mode IN VARCHAR2,
1433: p_type IN VARCHAR2,
1434: p_accounting_date IN DATE,

Line 1538: -- igc_cc_acct_lines_v with

1534: l_func_billed_amt := 0;
1535: l_func_amt := 0;
1536:
1537: -- Performance Tuning, Replaced view
1538: -- igc_cc_acct_lines_v with
1539: -- igc_cc_acct_lines and replaced the line
1540: -- below.
1541: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt, cc_acct_func_amt
1542: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 1579: -- igc_cc_acct_lines_v with

1575: l_func_billed_amt := 0;
1576: l_func_amt := 0;
1577:
1578: -- Performance Tuning, Replaced view
1579: -- igc_cc_acct_lines_v with
1580: -- igc_cc_acct_lines and replaced the line
1581: -- below.
1582: -- SELECT cc_det_pf_billed_amt, cc_det_pf_func_billed_amt , cc_det_pf_func_amt
1583: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_line_num, ccdpf.cc_acct_line_id) cc_det_pf_billed_amt,

Line 2034: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;

2030: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2031: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2032:
2033: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2034: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;
2035: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2036: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2037: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2038:

Line 2039: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

2035: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2036: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2037: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2038:
2039: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2040: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2041:
2042: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2043: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

Line 2040: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

2036: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2037: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2038:
2039: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2040: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2041:
2042: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2043: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
2044:

Line 2064: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

2060: l_sob_id NUMBER;
2061: l_cc_state VARCHAR2(2);
2062:
2063: l_cc_headers_rec igc_cc_headers%ROWTYPE;
2064: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
2065: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
2066: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2067:
2068: l_debug VARCHAR2(1);

Line 2185: -- FROM igc_cc_acct_lines_v ccac

2181:
2182: -- Bug 2885953 - cursor below amended for performance enhancements
2183: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
2184: -- SELECT *
2185: -- FROM igc_cc_acct_lines_v ccac
2186: -- WHERE ccac.cc_header_id = t_cc_header_id;
2187: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
2188: SELECT ccac.ROWID,
2189: ccac.cc_header_id,

Line 2819: -- igc_cc_acct_lines_v with

2815: (l_budget_dest_flag = 'C'))
2816: THEN */--Bug 5464993. Update amounts even when cbc is disabled
2817:
2818: -- Performance Tuning, Replaced view
2819: -- igc_cc_acct_lines_v with
2820: -- igc_cc_acct_lines and replaced the line
2821: -- below.
2822: -- SELECT cc_acct_comp_func_amt
2823: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_acct_entered_amt,0)) cc_acct_comp_func_amt

Line 2897: -- igc_cc_acct_lines_v with

2893: l_billed_amt := 0;
2894: l_func_billed_amt := 0;
2895:
2896: -- Performance Tuning, Replaced view
2897: -- igc_cc_acct_lines_v with
2898: -- igc_cc_acct_lines and replaced the line
2899: -- below.
2900: -- SELECT cc_acct_billed_amt ,cc_acct_func_billed_amt
2901: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 4190: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

4186: l_api_name CONSTANT VARCHAR2(30) := 'Set_Encumbrance_Status';
4187: l_api_version CONSTANT NUMBER := 1.0;
4188:
4189: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4190: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4191: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4192:
4193: l_error_message VARCHAR2(2000);
4194:

Line 4277: -- FROM igc_cc_acct_lines_v ccac

4273:
4274: -- Bug 2885953 - cursor below amended for performance enhancements
4275: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4276: -- SELECT *
4277: -- FROM igc_cc_acct_lines_v ccac
4278: -- WHERE ccac.cc_header_id = t_cc_header_id;
4279: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4280: SELECT ccac.ROWID,
4281: ccac.cc_header_id,

Line 4679: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

4675: IS
4676: l_api_name CONSTANT VARCHAR2(30) := 'Validate_CC';
4677: l_api_version CONSTANT NUMBER := 1.0;
4678: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4679: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4680: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4681: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4682: l_cc_acct_cnt NUMBER := 0;
4683: l_total_pf_entered_amt NUMBER := 0;

Line 4718: -- FROM igc_cc_acct_lines_v ccac

4714:
4715: -- Bug 2885953 - cursor below amended for performance enhancements
4716: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4717: -- SELECT *
4718: -- FROM igc_cc_acct_lines_v ccac
4719: -- WHERE ccac.cc_header_id = t_cc_header_id;
4720: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4721: SELECT ccac.ROWID,
4722: ccac.cc_header_id,