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_DET_PF_V

Line 512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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:
516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

Line 519: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;

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:
522: l_billed_amt NUMBER;
523: l_func_billed_amt NUMBER;

Line 520: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

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:
522: l_billed_amt NUMBER;
523: l_func_billed_amt NUMBER;
524: l_encumbrance_status VARCHAR2(1);

Line 624: -- Performance Tuning, Replaced view igc_cc_det_pf_v with

620:
621: /* Contract Detail Payment Forecast lines */
622:
623: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
624: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
625: -- igc_cc_det_pf
626: -- SELECT *
627: -- FROM igc_cc_det_pf_v
628: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 627: -- FROM igc_cc_det_pf_v

623: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
624: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
625: -- igc_cc_det_pf
626: -- SELECT *
627: -- FROM igc_cc_det_pf_v
628: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
629: SELECT ccdpf.ROWID,
630: ccdpf.cc_det_pf_line_id,
631: ccdpf.cc_det_pf_line_num,

Line 998: -- igc_cc_det_pf_v with

994: l_billed_amt := 0;
995: l_func_billed_amt := 0;
996:
997: -- Performance Tuning, Replaced view
998: -- igc_cc_det_pf_v with
999: -- igc_cc_det_pf and replaced the line
1000: -- below.
1001: -- SELECT cc_det_pf_billed_amt ,cc_det_pf_func_billed_amt
1002: 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 1431: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,

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,
1435: x_msg_count OUT NOCOPY NUMBER,

Line 2093: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;

2089: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2090:
2091: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2092: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;
2093: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2094: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2096:
2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

Line 2100: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;

2096:
2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2099:
2100: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2101: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
2102:
2103: l_flag BOOLEAN := FALSE;
2104: l_cbc_on BOOLEAN := FALSE;

Line 2101: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2099:
2100: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2101: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
2102:
2103: l_flag BOOLEAN := FALSE;
2104: l_cbc_on BOOLEAN := FALSE;
2105:

Line 2123: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

2119: l_cc_state VARCHAR2(2);
2120:
2121: l_cc_headers_rec igc_cc_headers%ROWTYPE;
2122: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
2123: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
2124: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2125:
2126: l_debug VARCHAR2(1);
2127:

Line 2186: -- Performance Tuning, Replaced view igc_cc_det_pf_v with

2182: /* Current year payment forecast lines only */
2183:
2184: /* Contract Commitment detail payment forecast */
2185: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
2186: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
2187: -- igc_cc_det_pf
2188: -- SELECT *
2189: -- FROM igc_cc_det_pf_v
2190: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 2189: -- FROM igc_cc_det_pf_v

2185: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
2186: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
2187: -- igc_cc_det_pf
2188: -- SELECT *
2189: -- FROM igc_cc_det_pf_v
2190: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
2191:
2192: SELECT ccdpf.ROWID,
2193: ccdpf.cc_det_pf_line_id,

Line 3073: -- igc_cc_det_pf_v with

3069: IF ((l_cc_det_pf_line_id IS NOT NULL) AND
3070: (l_budget_dest_flag = 'S'))
3071: THEN
3072: -- Performance Tuning, Replaced view
3073: -- igc_cc_det_pf_v with
3074: -- igc_cc_det_pf and replaced the line
3075: -- below.
3076: -- SELECT cc_det_pf_comp_func_amt
3077: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(p_cc_header_id,NVL(ccdpf.cc_det_pf_entered_amt,0)) cc_det_pf_comp_func_amt

Line 3144: -- igc_cc_det_pf_v with

3140: l_billed_amt := 0;
3141: l_func_billed_amt := 0;
3142:
3143: -- Performance Tuning, Replaced view
3144: -- igc_cc_det_pf_v with
3145: -- igc_cc_det_pf and replaced the line
3146: -- below.
3147: -- SELECT cc_det_pf_billed_amt , cc_det_pf_func_billed_amt
3148: 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 4249: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

4245: l_api_version CONSTANT NUMBER := 1.0;
4246:
4247: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4248: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4249: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4250:
4251: l_error_message VARCHAR2(2000);
4252:
4253: -- -------------------------------------------------------------------------

Line 4280: -- Performance Tuning, Replaced view igc_cc_det_pf_v with

4276:
4277: /* Contract Commitment detail payment forecast */
4278: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
4279:
4280: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
4281: -- igc_cc_det_pf and replaced the line below.
4282: -- SELECT *
4283: -- FROM igc_cc_det_pf_v
4284: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 4283: -- FROM igc_cc_det_pf_v

4279:
4280: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
4281: -- igc_cc_det_pf and replaced the line below.
4282: -- SELECT *
4283: -- FROM igc_cc_det_pf_v
4284: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
4285:
4286: SELECT ccdpf.ROWID,
4287: ccdpf.cc_det_pf_line_id,

Line 4738: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;

4734: l_api_name CONSTANT VARCHAR2(30) := 'Validate_CC';
4735: l_api_version CONSTANT NUMBER := 1.0;
4736: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4737: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4738: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4739: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4740: l_cc_acct_cnt NUMBER := 0;
4741: l_total_pf_entered_amt NUMBER := 0;
4742: l_cc_det_pf_cnt NUMBER := 0;

Line 4739: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

4735: l_api_version CONSTANT NUMBER := 1.0;
4736: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4737: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4738: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4739: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4740: l_cc_acct_cnt NUMBER := 0;
4741: l_total_pf_entered_amt NUMBER := 0;
4742: l_cc_det_pf_cnt NUMBER := 0;
4743: l_min_pf_date DATE;

Line 4847: -- igc_cc_det_pf_v with

4843: WHERE ccac.cc_header_id = t_cc_header_id;
4844:
4845: CURSOR c_det_pf_lines(t_cc_acct_line_id NUMBER) IS
4846: -- Performance Tuning, Replaced view
4847: -- igc_cc_det_pf_v with
4848: -- igc_cc_det_pf and replaced the line
4849: -- below.
4850: -- SELECT *
4851: -- FROM igc_cc_det_pf_v ccdpf

Line 4851: -- FROM igc_cc_det_pf_v ccdpf

4847: -- igc_cc_det_pf_v with
4848: -- igc_cc_det_pf and replaced the line
4849: -- below.
4850: -- SELECT *
4851: -- FROM igc_cc_det_pf_v ccdpf
4852: -- WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4853:
4854: SELECT ccdpf.ROWID,
4855: ccdpf.cc_det_pf_line_id,

Line 5809: -- igc_cc_det_pf_v with

5805: l_cc_det_pf_cnt := 0;
5806:
5807: BEGIN
5808: -- Performance Tuning, Replaced view
5809: -- igc_cc_det_pf_v with
5810: -- igc_cc_det_pf
5811: SELECT count(*)
5812: INTO l_cc_det_pf_cnt
5813: FROM igc_cc_det_pf

Line 5925: -- igc_cc_det_pf_v with

5921: l_cc_det_pf_cnt := 0;
5922:
5923: BEGIN
5924: -- Performance Tuning, Replaced view
5925: -- igc_cc_det_pf_v with
5926: -- igc_cc_det_pf and replaced the line
5927: -- below.
5928: SELECT count(*)
5929: INTO l_cc_det_pf_cnt

Line 6185: -- igc_cc_det_pf_v with

6181: CLOSE c_det_pf_lines;
6182:
6183: END IF;
6184: -- Performance Tuning, Replaced view
6185: -- igc_cc_det_pf_v with
6186: -- igc_cc_det_pf and replaced the line
6187: -- below.
6188: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6189: INTO l_total_pf_entered_amt

Line 6271: -- igc_cc_det_pf_v with

6267: l_cc_det_pf_cnt := 0;
6268:
6269: BEGIN
6270: -- Performance Tuning, Replaced view
6271: -- igc_cc_det_pf_v with
6272: -- igc_cc_det_pf and replaced the line
6273: -- below.
6274: SELECT count(*)
6275: INTO l_cc_det_pf_cnt

Line 6537: -- igc_cc_det_pf_v with igc_cc_det_pf

6533: CLOSE c_det_pf_lines;
6534:
6535: END IF;
6536: -- Performance Tuning, Replaced view
6537: -- igc_cc_det_pf_v with igc_cc_det_pf
6538: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6539: INTO l_total_pf_entered_amt
6540: FROM igc_cc_det_pf
6541: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;