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_MPFS_PROCESS_PKG dependencies on IGC_CC_DET_PF_V

Line 213: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,

209: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_Ids are not required*/
210: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
211: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
212: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
213: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,
214: p_enc_type IN VARCHAR2,
215: p_enc_date IN DATE,
216: p_enc_amt IN NUMBER,
217: x_return_status OUT NOCOPY VARCHAR2,

Line 390: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

386: l_interface_row_count NUMBER;
387:
388: l_cc_headers_rec igc_cc_headers%ROWTYPE;
389: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
390: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
391:
392: l_enc_amt NUMBER := 0;
393: l_enc_date DATE;
394:

Line 416: -- FROM igc_cc_det_pf_v

412:
413: /* Contract Commitment detail payment forecast */
414:
415: -- SELECT *
416: -- FROM igc_cc_det_pf_v
417: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
418:
419: --Replaced the above query with the one below.
420: --Performance Tuning project. The record definition remains

Line 610: -- the use of igc_cc_det_pf_v

606: a.cc_det_pf_date >= p_target_date AND
607: a.cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
608:
609: -- Replaced the following sql with the one below to eliminate
610: -- the use of igc_cc_det_pf_v
611: -- SELECT *
612: -- INTO l_cc_pmt_fcst_rec
613: -- FROM igc_cc_det_pf_v
614: -- WHERE cc_det_pf_line_id = l_cc_det_pf_line_id;

Line 613: -- FROM igc_cc_det_pf_v

609: -- Replaced the following sql with the one below to eliminate
610: -- the use of igc_cc_det_pf_v
611: -- SELECT *
612: -- INTO l_cc_pmt_fcst_rec
613: -- FROM igc_cc_det_pf_v
614: -- WHERE cc_det_pf_line_id = l_cc_det_pf_line_id;
615:
616: SELECT ccdpf.ROWID,
617: ccdpf.cc_det_pf_line_id,

Line 670: -- Replaced igc_cc_det_pf_v with igc_cc_det_pf

666: END;
667:
668: /* Get target pf encumbrance amt */
669:
670: -- Replaced igc_cc_det_pf_v with igc_cc_det_pf
671: -- Also replaced the following line
672: -- SELECT NVL(SUM(NVL(cc_det_pf_func_amt,0) - NVL(cc_det_pf_func_billed_amt,0)) ,0)
673: SELECT NVL(SUM(NVL(a.cc_det_pf_func_amt,0) -
674: NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_PF_FUNC_BILLED_AMT(a.cc_det_pf_line_id, a.cc_det_pf_line_num, a.cc_acct_line_id),0)) ,0)

Line 1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

1096: RETURN VARCHAR2
1097: IS
1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;
1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1103: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
1104: l_DUMMY VARCHAR2(1);

Line 1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;

1097: IS
1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;
1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1103: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
1104: l_DUMMY VARCHAR2(1);
1105:

Line 1111: -- and igc_cc_det_pf_v with igc_cc_det_pf

1107: -- modified for bug 2876467
1108: -- ccdpf.cc_det_pf_billed_amt changed to ccdpf.cc_det_pf_func_billed_amt
1109: -- Performance Tuning project. Replaced selection from views
1110: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1111: -- and igc_cc_det_pf_v with igc_cc_det_pf
1112: -- Replaced the following line as well
1113: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1114: CURSOR c_acct_lines(p_cc_header_id NUMBER)
1115: IS

Line 1120: -- ( Select 'x' FROM igc_cc_det_pf_v ccdpf

1116: -- SELECT *
1117: -- FROM igc_cc_acct_lines_v ccal
1118: -- WHERE ccal.cc_header_id = p_cc_header_id
1119: -- AND exists
1120: -- ( Select 'x' FROM igc_cc_det_pf_v ccdpf
1121: -- WHERE ccdpf.cc_acct_line_id = ccal.cc_acct_line_id
1122: -- AND ccdpf.cc_det_pf_date >= p_start_date AND ccdpf.cc_det_pf_date <= p_end_date
1123: -- AND (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) >0);
1124:

Line 1204: -- FROM igc_cc_det_pf_v ccdpf

1200: IS
1201:
1202: -- Modified the following sql for performance tuning.
1203: -- SELECT *
1204: -- FROM igc_cc_det_pf_v ccdpf
1205: -- WHERE ccdpf.cc_acct_line_id = p_cc_acct_line_id
1206: -- AND ccdpf.cc_det_pf_date >= p_start_date AND ccdpf.cc_det_pf_date <= p_end_date
1207: -- AND (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) >0;
1208:

Line 1257: -- Performance Tuning, replaced the view igc_cc_det_pf_v

1253: AND (ccdpf.cc_det_pf_func_amt-IGC_CC_COMP_AMT_PKG.COMPUTE_PF_FUNC_BILLED_AMT(ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_line_num, ccdpf.cc_acct_line_id)) >0;
1254:
1255: CURSOR c_pf_amt_shift(p_cc_acct_line_id NUMBER,p_start_date DATE,p_end_date DATE)
1256: IS
1257: -- Performance Tuning, replaced the view igc_cc_det_pf_v
1258: -- igc_cc_det_pf. Also replaced the following 2 lines
1259: -- SELECT sum(ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) func_amt_shift, sum(ccdpf.cc_det_pf_entered_amt - ccdpf.cc_det_pf_billed_amt) amt_shift
1260: -- AND (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) >0;
1261:

Line 1274: -- Replaced view igc_cc_det_pf_v with igc_cc_det_pf

1270: AND ccdpf.cc_det_pf_date <= p_end_date
1271: AND (ccdpf.cc_det_pf_func_amt -
1272: IGC_CC_COMP_AMT_PKG.COMPUTE_PF_FUNC_BILLED_AMT(ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_line_num, ccdpf.cc_acct_line_id)) >0;
1273:
1274: -- Replaced view igc_cc_det_pf_v with igc_cc_det_pf
1275: CURSOR c_pf_target (p_cc_acct_line_id NUMBER,p_target_date DATE)
1276: IS
1277: -- SELECT *
1278: -- FROM igc_cc_det_pf_v ccdpf

Line 1278: -- FROM igc_cc_det_pf_v ccdpf

1274: -- Replaced view igc_cc_det_pf_v with igc_cc_det_pf
1275: CURSOR c_pf_target (p_cc_acct_line_id NUMBER,p_target_date DATE)
1276: IS
1277: -- SELECT *
1278: -- FROM igc_cc_det_pf_v ccdpf
1279:
1280: SELECT ccdpf.ROWID,
1281: ccdpf.cc_det_pf_line_id,
1282: ccdpf.cc_det_pf_line_num,

Line 1970: -- and igc_cc_det_pf_v with igc_cc_det_pf

1966: l_sob_name VARCHAR2(30);
1967:
1968: -- Performance Tuning project. Replaced selection from views
1969: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1970: -- and igc_cc_det_pf_v with igc_cc_det_pf
1971: -- Replaced the following 2 lines a well
1972: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
1973: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1974: CURSOR c1 (

Line 2019: -- and igc_cc_det_pf_v with igc_cc_det_pf

2015: GROUP BY cchd.cc_header_id, cchd.cc_apprvl_status;
2016:
2017: -- Performance Tuning project. Replaced selection from views
2018: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2019: -- and igc_cc_det_pf_v with igc_cc_det_pf
2020: -- Replaced the following 2 lines a well
2021: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
2022: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
2023: CURSOR c2 (

Line 2076: -- and igc_cc_det_pf_v with igc_cc_det_pf

2072: AND (ccpd.processed <> 'Y' OR ccpd.processed IS NULL);
2073:
2074: -- Performance Tuning project. Replaced selection from views
2075: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2076: -- and igc_cc_det_pf_v with igc_cc_det_pf
2077: -- Replaced the following line as well
2078: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
2079: CURSOR c4 (
2080: p_org_id NUMBER,

Line 2179: -- FROM igc_cc_det_pf_v ccdpf1

2175: -- AND NOT EXISTS (SELECT 'X'
2176: -- FROM igc_cc_acct_lines_v ccal1
2177: -- WHERE ccal1.cc_header_id = cchd.cc_header_id
2178: -- AND NOT EXISTS (SELECT 'X'
2179: -- FROM igc_cc_det_pf_v ccdpf1
2180: -- WHERE ccdpf1.cc_acct_line_id = ccal1.cc_acct_line_id
2181: -- AND ccdpf1.cc_det_pf_date >= p_target_date )
2182: -- );
2183: CURSOR c7 (

Line 2190: -- FROM igc_cc_det_pf_v ccdpf

2186: p_cc_header_id NUMBER
2187: )
2188: IS
2189: -- SELECT *
2190: -- FROM igc_cc_det_pf_v ccdpf
2191: SELECT ccdpf.ROWID, ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_line_num,
2192: NULL cc_acct_line_num, ccdpf.cc_acct_line_id,
2193: NULL parent_det_pf_line_num, ccdpf.parent_det_pf_line_id,
2194: ccdpf.parent_acct_line_id, ccdpf.cc_det_pf_entered_amt,