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

Line 62: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,

58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: x_rowid IN OUT NOCOPY VARCHAR2,
61: p_action_flag IN VARCHAR2,
62: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
63: p_update_flag IN OUT NOCOPY VARCHAR2
64: );
65:
66: PROCEDURE Header_Wrapper

Line 267: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,

263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: x_rowid IN OUT NOCOPY VARCHAR2,
266: p_action_flag IN VARCHAR2,
267: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
268: p_update_flag IN OUT NOCOPY VARCHAR2
269: ) IS
270:
271: l_api_name CONSTANT VARCHAR2(30) := 'Det_Pf_Wrapper';

Line 285: IGC_CC_DET_PF_PKG.Update_Row (

281: -- Make sure that the action requested to be performed is to UPDATE a row.
282: -- ---------------------------------------------------------------------------------
283: IF (p_action_flag = 'U') THEN
284:
285: IGC_CC_DET_PF_PKG.Update_Row (
286: p_api_version,
287: p_init_msg_list,
288: p_commit,
289: p_validation_level,

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 544: l_det_pf_rec igc_cc_det_pf%ROWTYPE;

540: -- Record definitions to be used for CURSORS getting single record for
541: -- the table wrappers. These record definitions are NOT the same as the
542: -- ones above when getting data from the views.
543: -- -------------------------------------------------------------------------
544: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
545: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
546:
547: /* Contract Commitment account lines */
548:

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 625: -- igc_cc_det_pf

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;
629: SELECT ccdpf.ROWID,

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 669: FROM igc_cc_det_pf ccdpf

665: ccdpf.last_updated_by,
666: ccdpf.last_update_login,
667: ccdpf.creation_date,
668: ccdpf.created_by
669: FROM igc_cc_det_pf ccdpf
670: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
671:
672: -- -------------------------------------------------------------------------
673: -- Cursors used for obtaining a single line to be passed into the wrapper

Line 683: FROM igc_cc_det_pf

679: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
680:
681: CURSOR c_det_pf_line IS
682: SELECT *
683: FROM igc_cc_det_pf
684: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
685:
686: l_full_path VARCHAR2(255);
687:

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 999: -- igc_cc_det_pf and replaced the line

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,
1003: 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) cc_det_pf_func_billed_amt

Line 1005: FROM igc_cc_det_pf ccdpf

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,
1003: 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) cc_det_pf_func_billed_amt
1004: INTO l_billed_amt, l_func_billed_amt
1005: FROM igc_cc_det_pf ccdpf
1006: WHERE ccdpf.cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
1007:
1008: l_transaction_date := NULL;
1009:

Line 1090: FROM igc_cc_det_pf

1086: END IF;
1087:
1088: SELECT rowid
1089: INTO l_row_id
1090: FROM igc_cc_det_pf
1091: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
1092:
1093: Det_Pf_Wrapper (p_api_version => l_api_version,
1094: p_init_msg_list => FND_API.G_FALSE,

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 1587: FROM igc_cc_det_pf ccdpf

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,
1584: 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) cc_det_pf_func_billed_amt,
1585: ccdpf.cc_det_pf_func_amt
1586: INTO l_billed_amt, l_func_billed_amt, l_func_amt
1587: FROM igc_cc_det_pf ccdpf
1588: WHERE ccdpf.cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
1589:
1590: l_unbilled_amt := l_func_amt - l_func_billed_amt;
1591: END IF;

Line 2035: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%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:
2039: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

Line 2042: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%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:
2045: l_flag BOOLEAN := FALSE;
2046: l_cbc_on BOOLEAN := FALSE;

Line 2043: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

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:
2045: l_flag BOOLEAN := FALSE;
2046: l_cbc_on BOOLEAN := FALSE;
2047:

Line 2065: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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);
2069:

Line 2098: l_det_pf_rec igc_cc_det_pf%ROWTYPE;

2094: -- Record definitions to be used for CURSORS getting single record for
2095: -- the table wrappers. These record definitions are NOT the same as the
2096: -- ones above when getting data from the views.
2097: -- -------------------------------------------------------------------------
2098: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
2099: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
2100:
2101: e_cc_invalid_set_up EXCEPTION;
2102: e_no_budgetary_control EXCEPTION;

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

2124: /* Current year payment forecast lines only */
2125:
2126: /* Contract Commitment detail payment forecast */
2127: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
2128: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
2129: -- igc_cc_det_pf
2130: -- SELECT *
2131: -- FROM igc_cc_det_pf_v
2132: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 2129: -- igc_cc_det_pf

2125:
2126: /* Contract Commitment detail payment forecast */
2127: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
2128: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
2129: -- igc_cc_det_pf
2130: -- SELECT *
2131: -- FROM igc_cc_det_pf_v
2132: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
2133:

Line 2131: -- FROM igc_cc_det_pf_v

2127: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
2128: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
2129: -- igc_cc_det_pf
2130: -- SELECT *
2131: -- FROM igc_cc_det_pf_v
2132: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
2133:
2134: SELECT ccdpf.ROWID,
2135: ccdpf.cc_det_pf_line_id,

Line 2175: FROM igc_cc_det_pf ccdpf

2171: ccdpf.last_updated_by,
2172: ccdpf.last_update_login,
2173: ccdpf.creation_date,
2174: ccdpf.created_by
2175: FROM igc_cc_det_pf ccdpf
2176: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
2177:
2178: /* Current year payment forecast lines only */
2179:

Line 2265: FROM igc_cc_det_pf

2261: WHERE cc_acct_line_id = l_cc_acct_line_id;
2262:
2263: CURSOR c_det_pf_line IS
2264: SELECT *
2265: FROM igc_cc_det_pf
2266: WHERE cc_det_pf_line_id = l_cc_det_pf_line_id;
2267:
2268: CURSOR c_cc_acct_line_rec_input IS
2269: SELECT *

Line 2275: FROM igc_cc_det_pf

2271: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
2272:
2273: CURSOR c_det_pf_line_rec_input IS
2274: SELECT *
2275: FROM igc_cc_det_pf
2276: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
2277:
2278: -- bug 2689651, start 2
2279: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)

Line 2283: FROM igc_cc_det_pf

2279: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)
2280: IS
2281: SELECT SUM(( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(cp_cc_header_id, NVL(cc_det_pf_entered_amt,0) ) -
2282: NVL(cc_det_pf_encmbrnc_amt,0) )) cc_det_pf_unencmbrd_amt
2283: FROM igc_cc_det_pf
2284: WHERE cc_acct_line_id IN (SELECT cc_acct_line_id
2285: FROM igc_cc_acct_lines
2286: WHERE cc_header_id = cp_cc_header_id);
2287: -- bug 2689651, end 2

Line 3015: -- igc_cc_det_pf_v with

3011: IF ((l_cc_det_pf_line_id IS NOT NULL) AND
3012: (l_budget_dest_flag = 'S'))
3013: THEN
3014: -- Performance Tuning, Replaced view
3015: -- igc_cc_det_pf_v with
3016: -- igc_cc_det_pf and replaced the line
3017: -- below.
3018: -- SELECT cc_det_pf_comp_func_amt
3019: 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 3016: -- igc_cc_det_pf and replaced the line

3012: (l_budget_dest_flag = 'S'))
3013: THEN
3014: -- Performance Tuning, Replaced view
3015: -- igc_cc_det_pf_v with
3016: -- igc_cc_det_pf and replaced the line
3017: -- below.
3018: -- SELECT cc_det_pf_comp_func_amt
3019: 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
3020: INTO l_cc_det_pf_comp_func_amt

Line 3021: FROM igc_cc_det_pf ccdpf

3017: -- below.
3018: -- SELECT cc_det_pf_comp_func_amt
3019: 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
3020: INTO l_cc_det_pf_comp_func_amt
3021: FROM igc_cc_det_pf ccdpf
3022: WHERE ccdpf.cc_det_pf_line_id = l_cc_det_pf_line_id;
3023:
3024: -- ----------------------------------------------------------------------------------
3025: -- Obtain the actual Det PF line record based upon the data that was just retrieved

Line 3086: -- igc_cc_det_pf_v with

3082: l_billed_amt := 0;
3083: l_func_billed_amt := 0;
3084:
3085: -- Performance Tuning, Replaced view
3086: -- igc_cc_det_pf_v with
3087: -- igc_cc_det_pf and replaced the line
3088: -- below.
3089: -- SELECT cc_det_pf_billed_amt , cc_det_pf_func_billed_amt
3090: 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 3087: -- igc_cc_det_pf and replaced the line

3083: l_func_billed_amt := 0;
3084:
3085: -- Performance Tuning, Replaced view
3086: -- igc_cc_det_pf_v with
3087: -- igc_cc_det_pf and replaced the line
3088: -- below.
3089: -- SELECT cc_det_pf_billed_amt , cc_det_pf_func_billed_amt
3090: 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,
3091: 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) cc_det_pf_func_billed_amt

Line 3093: FROM igc_cc_det_pf ccdpf

3089: -- SELECT cc_det_pf_billed_amt , cc_det_pf_func_billed_amt
3090: 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,
3091: 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) cc_det_pf_func_billed_amt
3092: INTO l_billed_amt, l_func_billed_amt
3093: FROM igc_cc_det_pf ccdpf
3094: WHERE ccdpf.cc_det_pf_line_id = l_cc_det_pf_line_id;
3095:
3096: IF (l_currency_code <> l_cc_headers_rec.currency_code) THEN
3097:

Line 3155: FROM igc_cc_det_pf

3151: END IF;
3152:
3153: SELECT rowid
3154: INTO l_row_id
3155: FROM igc_cc_det_pf
3156: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
3157:
3158: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3159: IF (g_debug_mode = 'Y') THEN

Line 3489: FROM igc_cc_det_pf

3485: l_det_pf_rec.last_updated_by := l_update_by;
3486:
3487: SELECT rowid
3488: INTO l_row_id
3489: FROM igc_cc_det_pf
3490: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
3491:
3492: Det_Pf_Wrapper (p_api_version => l_api_version,
3493: p_init_msg_list => FND_API.G_FALSE,

Line 4191: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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:
4195: -- -------------------------------------------------------------------------

Line 4212: l_det_pf_rec igc_cc_det_pf%ROWTYPE;

4208: -- Record definitions to be used for CURSORS getting single record for
4209: -- the table wrappers. These record definitions are NOT the same as the
4210: -- ones above when getting data from the views.
4211: -- -------------------------------------------------------------------------
4212: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
4213: l_header_rec igc_cc_headers%ROWTYPE;
4214: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
4215:
4216: e_cc_not_found EXCEPTION;

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

4218:
4219: /* Contract Commitment detail payment forecast */
4220: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
4221:
4222: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
4223: -- igc_cc_det_pf and replaced the line below.
4224: -- SELECT *
4225: -- FROM igc_cc_det_pf_v
4226: -- WHERE cc_acct_line_id = t_cc_acct_line_id;

Line 4223: -- igc_cc_det_pf and replaced the line below.

4219: /* Contract Commitment detail payment forecast */
4220: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
4221:
4222: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
4223: -- igc_cc_det_pf and replaced the line below.
4224: -- SELECT *
4225: -- FROM igc_cc_det_pf_v
4226: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
4227:

Line 4225: -- FROM igc_cc_det_pf_v

4221:
4222: -- Performance Tuning, Replaced view igc_cc_det_pf_v with
4223: -- igc_cc_det_pf and replaced the line below.
4224: -- SELECT *
4225: -- FROM igc_cc_det_pf_v
4226: -- WHERE cc_acct_line_id = t_cc_acct_line_id;
4227:
4228: SELECT ccdpf.ROWID,
4229: ccdpf.cc_det_pf_line_id,

Line 4269: FROM igc_cc_det_pf ccdpf

4265: ccdpf.last_updated_by,
4266: ccdpf.last_update_login,
4267: ccdpf.creation_date,
4268: ccdpf.created_by
4269: FROM igc_cc_det_pf ccdpf
4270: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4271:
4272: /* Contract Commitment account lines */
4273:

Line 4357: FROM igc_cc_det_pf

4353: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
4354:
4355: CURSOR c_det_pf_line IS
4356: SELECT *
4357: FROM igc_cc_det_pf
4358: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
4359:
4360: l_full_path VARCHAR2(255);
4361:

Line 4498: FROM igc_cc_det_pf

4494: l_det_pf_rec.last_updated_by := l_update_by;
4495:
4496: SELECT rowid
4497: INTO l_row_id
4498: FROM igc_cc_det_pf
4499: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
4500:
4501: Det_Pf_Wrapper (p_api_version => l_api_version,
4502: p_init_msg_list => FND_API.G_FALSE,

Line 4680: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;

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;
4684: l_cc_det_pf_cnt NUMBER := 0;

Line 4681: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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;
4684: l_cc_det_pf_cnt NUMBER := 0;
4685: l_min_pf_date DATE;

Line 4789: -- igc_cc_det_pf_v with

4785: WHERE ccac.cc_header_id = t_cc_header_id;
4786:
4787: CURSOR c_det_pf_lines(t_cc_acct_line_id NUMBER) IS
4788: -- Performance Tuning, Replaced view
4789: -- igc_cc_det_pf_v with
4790: -- igc_cc_det_pf and replaced the line
4791: -- below.
4792: -- SELECT *
4793: -- FROM igc_cc_det_pf_v ccdpf

Line 4790: -- igc_cc_det_pf and replaced the line

4786:
4787: CURSOR c_det_pf_lines(t_cc_acct_line_id NUMBER) IS
4788: -- Performance Tuning, Replaced view
4789: -- igc_cc_det_pf_v with
4790: -- igc_cc_det_pf and replaced the line
4791: -- below.
4792: -- SELECT *
4793: -- FROM igc_cc_det_pf_v ccdpf
4794: -- WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;

Line 4793: -- FROM igc_cc_det_pf_v ccdpf

4789: -- igc_cc_det_pf_v with
4790: -- igc_cc_det_pf and replaced the line
4791: -- below.
4792: -- SELECT *
4793: -- FROM igc_cc_det_pf_v ccdpf
4794: -- WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4795:
4796: SELECT ccdpf.ROWID,
4797: ccdpf.cc_det_pf_line_id,

Line 4837: FROM igc_cc_det_pf ccdpf

4833: ccdpf.last_updated_by,
4834: ccdpf.last_update_login,
4835: ccdpf.creation_date,
4836: ccdpf.created_by
4837: FROM igc_cc_det_pf ccdpf
4838: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4839:
4840: -- Bug 1830385, Bidisha S, 2 Jul 2001
4841: CURSOR c_gl_app_id IS

Line 5195: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

5191:
5192: IF (p_cc_det_pf_date < p_start_date) THEN
5193: x_valid_cc := FND_API.G_FALSE;
5194: x_return_status := FND_API.G_RET_STS_ERROR;
5195: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5196: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5197: IF(g_error_level >= g_debug_level) THEN
5198: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5199: END IF;

Line 5207: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

5203: (p_end_date IS NOT NULL)
5204: ) THEN
5205: x_valid_cc := FND_API.G_FALSE;
5206: x_return_status := FND_API.G_RET_STS_ERROR;
5207: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5208: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5209: IF(g_error_level >= g_debug_level) THEN
5210: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5211: END IF;

Line 5249: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

5245: END;
5246: IF NVL(l_COUNT,0) = 0 THEN
5247: x_valid_cc := FND_API.G_FALSE;
5248: x_return_status := FND_API.G_RET_STS_ERROR;
5249: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5250: IF(g_error_level >= g_debug_level) THEN
5251: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5252: END IF;
5253: fnd_msg_pub.add;

Line 5751: -- igc_cc_det_pf_v with

5747: l_cc_det_pf_cnt := 0;
5748:
5749: BEGIN
5750: -- Performance Tuning, Replaced view
5751: -- igc_cc_det_pf_v with
5752: -- igc_cc_det_pf
5753: SELECT count(*)
5754: INTO l_cc_det_pf_cnt
5755: FROM igc_cc_det_pf

Line 5752: -- igc_cc_det_pf

5748:
5749: BEGIN
5750: -- Performance Tuning, Replaced view
5751: -- igc_cc_det_pf_v with
5752: -- igc_cc_det_pf
5753: SELECT count(*)
5754: INTO l_cc_det_pf_cnt
5755: FROM igc_cc_det_pf
5756: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;

Line 5755: FROM igc_cc_det_pf

5751: -- igc_cc_det_pf_v with
5752: -- igc_cc_det_pf
5753: SELECT count(*)
5754: INTO l_cc_det_pf_cnt
5755: FROM igc_cc_det_pf
5756: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
5757: EXCEPTION
5758: WHEN NO_DATA_FOUND THEN
5759: l_cc_det_pf_cnt := 0;

Line 5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');

5786:
5787: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5788: x_valid_cc := FND_API.G_FALSE;
5789: x_return_status := FND_API.G_RET_STS_ERROR;
5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5791: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5793: IF(g_error_level >= g_debug_level) THEN
5794: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5867: -- igc_cc_det_pf_v with

5863: l_cc_det_pf_cnt := 0;
5864:
5865: BEGIN
5866: -- Performance Tuning, Replaced view
5867: -- igc_cc_det_pf_v with
5868: -- igc_cc_det_pf and replaced the line
5869: -- below.
5870: SELECT count(*)
5871: INTO l_cc_det_pf_cnt

Line 5868: -- igc_cc_det_pf and replaced the line

5864:
5865: BEGIN
5866: -- Performance Tuning, Replaced view
5867: -- igc_cc_det_pf_v with
5868: -- igc_cc_det_pf and replaced the line
5869: -- below.
5870: SELECT count(*)
5871: INTO l_cc_det_pf_cnt
5872: FROM igc_cc_det_pf

Line 5872: FROM igc_cc_det_pf

5868: -- igc_cc_det_pf and replaced the line
5869: -- below.
5870: SELECT count(*)
5871: INTO l_cc_det_pf_cnt
5872: FROM igc_cc_det_pf
5873: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
5874: EXCEPTION
5875: WHEN NO_DATA_FOUND THEN
5876: l_cc_det_pf_cnt := 0;

Line 5907: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

5903:
5904: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5905: x_valid_cc := FND_API.G_FALSE;
5906: x_return_status := FND_API.G_RET_STS_ERROR;
5907: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5908: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5909: IF (g_error_level >= g_debug_level) THEN
5910: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5911: END IF;

Line 5922: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

5918: (p_end_date IS NOT NULL)
5919: ) THEN
5920: x_valid_cc := FND_API.G_FALSE;
5921: x_return_status := FND_API.G_RET_STS_ERROR;
5922: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5923: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5924: IF(g_error_level >= g_debug_level) THEN
5925: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5926: END IF;

Line 5972: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

5968: END;
5969: IF NVL(l_COUNT,0) = 0 THEN
5970: x_valid_cc := FND_API.G_FALSE;
5971: x_return_status := FND_API.G_RET_STS_ERROR;
5972: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5973: IF(g_error_level >= g_debug_level) THEN
5974: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5975: END IF;
5976: fnd_msg_pub.add;

Line 6034: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');

6030: TRUNC(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6031: THEN
6032: x_valid_cc := FND_API.G_FALSE;
6033: x_return_status := FND_API.G_RET_STS_ERROR;
6034: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6035: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6036: IF(g_error_level >= g_debug_level) THEN
6037: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6038: END IF;

Line 6125: -- igc_cc_det_pf_v with

6121: CLOSE c_det_pf_lines;
6122:
6123: END IF;
6124: -- Performance Tuning, Replaced view
6125: -- igc_cc_det_pf_v with
6126: -- igc_cc_det_pf and replaced the line
6127: -- below.
6128: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6129: INTO l_total_pf_entered_amt

Line 6126: -- igc_cc_det_pf and replaced the line

6122:
6123: END IF;
6124: -- Performance Tuning, Replaced view
6125: -- igc_cc_det_pf_v with
6126: -- igc_cc_det_pf and replaced the line
6127: -- below.
6128: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6129: INTO l_total_pf_entered_amt
6130: FROM igc_cc_det_pf

Line 6130: FROM igc_cc_det_pf

6126: -- igc_cc_det_pf and replaced the line
6127: -- below.
6128: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6129: INTO l_total_pf_entered_amt
6130: FROM igc_cc_det_pf
6131: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
6132:
6133: IF ( l_total_pf_entered_amt +
6134: NVL(l_cc_acct_lines_rec.cc_ent_withheld_amt,0)) <> NVL(l_cc_acct_lines_rec.cc_acct_entered_amt,0)

Line 6211: -- igc_cc_det_pf_v with

6207: l_cc_det_pf_cnt := 0;
6208:
6209: BEGIN
6210: -- Performance Tuning, Replaced view
6211: -- igc_cc_det_pf_v with
6212: -- igc_cc_det_pf and replaced the line
6213: -- below.
6214: SELECT count(*)
6215: INTO l_cc_det_pf_cnt

Line 6212: -- igc_cc_det_pf and replaced the line

6208:
6209: BEGIN
6210: -- Performance Tuning, Replaced view
6211: -- igc_cc_det_pf_v with
6212: -- igc_cc_det_pf and replaced the line
6213: -- below.
6214: SELECT count(*)
6215: INTO l_cc_det_pf_cnt
6216: FROM igc_cc_det_pf

Line 6216: FROM igc_cc_det_pf

6212: -- igc_cc_det_pf and replaced the line
6213: -- below.
6214: SELECT count(*)
6215: INTO l_cc_det_pf_cnt
6216: FROM igc_cc_det_pf
6217: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
6218: EXCEPTION
6219: WHEN NO_DATA_FOUND THEN
6220: l_cc_det_pf_cnt := 0;

Line 6257: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

6253:
6254: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6255: x_valid_cc := FND_API.G_FALSE;
6256: x_return_status := FND_API.G_RET_STS_ERROR;
6257: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6258: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6259: IF(g_error_level >= g_debug_level) THEN
6260: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6261: END IF;

Line 6272: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

6268: (p_end_date IS NOT NULL)
6269: ) THEN
6270: x_valid_cc := FND_API.G_FALSE;
6271: x_return_status := FND_API.G_RET_STS_ERROR;
6272: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6273: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6274: IF(g_error_level >= g_debug_level) THEN
6275: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6276: END IF;

Line 6322: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

6318: END;
6319: IF NVL(l_COUNT,0) = 0 THEN
6320: x_valid_cc := FND_API.G_FALSE;
6321: x_return_status := FND_API.G_RET_STS_ERROR;
6322: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6323: IF(g_error_level >= g_debug_level) THEN
6324: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6325: END IF;
6326: fnd_msg_pub.add;

Line 6384: 'IGC_CC_DET_PF_DATE_NO_UPDATE');

6380: THEN
6381: x_valid_cc := FND_API.G_FALSE;
6382: x_return_status := FND_API.G_RET_STS_ERROR;
6383: fnd_message.set_name('IGC',
6384: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6385: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6386: IF(g_error_level >= g_debug_level) THEN
6387: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6388: END IF;

Line 6475: -- igc_cc_det_pf_v with igc_cc_det_pf

6471: CLOSE c_det_pf_lines;
6472:
6473: END IF;
6474: -- Performance Tuning, Replaced view
6475: -- igc_cc_det_pf_v with igc_cc_det_pf
6476: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6477: INTO l_total_pf_entered_amt
6478: FROM igc_cc_det_pf
6479: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;

Line 6478: FROM igc_cc_det_pf

6474: -- Performance Tuning, Replaced view
6475: -- igc_cc_det_pf_v with igc_cc_det_pf
6476: SELECT SUM(NVL(CC_DET_PF_ENTERED_AMT,0))
6477: INTO l_total_pf_entered_amt
6478: FROM igc_cc_det_pf
6479: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
6480:
6481: IF ( l_total_pf_entered_amt
6482: + NVL(l_cc_acct_lines_rec.cc_ent_withheld_amt,0) )