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

1609: /* 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,
1610: 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,
1611: ccdpf.cc_det_pf_func_amt
1612: INTO l_billed_amt, l_func_billed_amt, l_func_amt
1613: FROM igc_cc_det_pf ccdpf
1614: WHERE ccdpf.cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
1615:
1616: l_unbilled_amt := l_func_amt - l_func_billed_amt;
1617: */

Line 1624: FROM igc_cc_det_pf ccdpf

1620: 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,
1621: ccdpf.CC_DET_PF_ENCMBRNC_AMT cc_det_pf_func_billed_amt,
1622: ccdpf.cc_det_pf_func_amt
1623: INTO l_billed_amt, l_func_billed_amt, l_func_amt
1624: FROM igc_cc_det_pf ccdpf
1625: WHERE ccdpf.cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
1626:
1627: l_unbilled_amt := l_func_billed_amt- l_func_amt ;
1628:

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

2152: -- Record definitions to be used for CURSORS getting single record for
2153: -- the table wrappers. These record definitions are NOT the same as the
2154: -- ones above when getting data from the views.
2155: -- -------------------------------------------------------------------------
2156: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
2157: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
2158:
2159: e_cc_invalid_set_up EXCEPTION;
2160: e_no_budgetary_control EXCEPTION;

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

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;
2191:

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

2229: ccdpf.last_updated_by,
2230: ccdpf.last_update_login,
2231: ccdpf.creation_date,
2232: ccdpf.created_by
2233: FROM igc_cc_det_pf ccdpf
2234: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
2235:
2236: /* Current year payment forecast lines only */
2237:

Line 2323: FROM igc_cc_det_pf

2319: WHERE cc_acct_line_id = l_cc_acct_line_id;
2320:
2321: CURSOR c_det_pf_line IS
2322: SELECT *
2323: FROM igc_cc_det_pf
2324: WHERE cc_det_pf_line_id = l_cc_det_pf_line_id;
2325:
2326: CURSOR c_cc_acct_line_rec_input IS
2327: SELECT *

Line 2333: FROM igc_cc_det_pf

2329: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
2330:
2331: CURSOR c_det_pf_line_rec_input IS
2332: SELECT *
2333: FROM igc_cc_det_pf
2334: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
2335:
2336: -- bug 2689651, start 2
2337: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)

Line 2341: FROM igc_cc_det_pf

2337: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)
2338: IS
2339: SELECT SUM(( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(cp_cc_header_id, NVL(cc_det_pf_entered_amt,0) ) -
2340: NVL(cc_det_pf_encmbrnc_amt,0) )) cc_det_pf_unencmbrd_amt
2341: FROM igc_cc_det_pf
2342: WHERE cc_acct_line_id IN (SELECT cc_acct_line_id
2343: FROM igc_cc_acct_lines
2344: WHERE cc_header_id = cp_cc_header_id);
2345: -- bug 2689651, end 2

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

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
3078: INTO l_cc_det_pf_comp_func_amt

Line 3079: FROM igc_cc_det_pf ccdpf

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
3078: INTO l_cc_det_pf_comp_func_amt
3079: FROM igc_cc_det_pf ccdpf
3080: WHERE ccdpf.cc_det_pf_line_id = l_cc_det_pf_line_id;
3081:
3082: -- ----------------------------------------------------------------------------------
3083: -- Obtain the actual Det PF line record based upon the data that was just retrieved

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

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,
3149: 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 3151: FROM igc_cc_det_pf ccdpf

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,
3149: 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
3150: INTO l_billed_amt, l_func_billed_amt
3151: FROM igc_cc_det_pf ccdpf
3152: WHERE ccdpf.cc_det_pf_line_id = l_cc_det_pf_line_id;
3153:
3154: IF (l_currency_code <> l_cc_headers_rec.currency_code) THEN
3155:

Line 3213: FROM igc_cc_det_pf

3209: END IF;
3210:
3211: SELECT rowid
3212: INTO l_row_id
3213: FROM igc_cc_det_pf
3214: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
3215:
3216: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3217: IF (g_debug_mode = 'Y') THEN

Line 3547: FROM igc_cc_det_pf

3543: l_det_pf_rec.last_updated_by := l_update_by;
3544:
3545: SELECT rowid
3546: INTO l_row_id
3547: FROM igc_cc_det_pf
3548: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
3549:
3550: Det_Pf_Wrapper (p_api_version => l_api_version,
3551: p_init_msg_list => FND_API.G_FALSE,

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

4266: -- Record definitions to be used for CURSORS getting single record for
4267: -- the table wrappers. These record definitions are NOT the same as the
4268: -- ones above when getting data from the views.
4269: -- -------------------------------------------------------------------------
4270: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
4271: l_header_rec igc_cc_headers%ROWTYPE;
4272: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
4273:
4274: e_cc_not_found EXCEPTION;

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 4281: -- igc_cc_det_pf and replaced the line below.

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;
4285:

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

4323: ccdpf.last_updated_by,
4324: ccdpf.last_update_login,
4325: ccdpf.creation_date,
4326: ccdpf.created_by
4327: FROM igc_cc_det_pf ccdpf
4328: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4329:
4330: /* Contract Commitment account lines */
4331:

Line 4415: FROM igc_cc_det_pf

4411: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
4412:
4413: CURSOR c_det_pf_line IS
4414: SELECT *
4415: FROM igc_cc_det_pf
4416: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
4417:
4418: l_full_path VARCHAR2(255);
4419:

Line 4556: FROM igc_cc_det_pf

4552: l_det_pf_rec.last_updated_by := l_update_by;
4553:
4554: SELECT rowid
4555: INTO l_row_id
4556: FROM igc_cc_det_pf
4557: WHERE cc_det_pf_line_id = l_det_pf_rec.cc_det_pf_line_id;
4558:
4559: Det_Pf_Wrapper (p_api_version => l_api_version,
4560: p_init_msg_list => FND_API.G_FALSE,

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

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
4852: -- WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;

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

4891: ccdpf.last_updated_by,
4892: ccdpf.last_update_login,
4893: ccdpf.creation_date,
4894: ccdpf.created_by
4895: FROM igc_cc_det_pf ccdpf
4896: WHERE ccdpf.cc_acct_line_id = t_cc_acct_line_id;
4897:
4898: -- Bug 1830385, Bidisha S, 2 Jul 2001
4899: CURSOR c_gl_app_id IS

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

5249:
5250: IF (p_cc_det_pf_date < p_start_date) THEN
5251: x_valid_cc := FND_API.G_FALSE;
5252: x_return_status := FND_API.G_RET_STS_ERROR;
5253: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5254: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5255: IF(g_error_level >= g_debug_level) THEN
5256: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5257: END IF;

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

5261: (p_end_date IS NOT NULL)
5262: ) THEN
5263: x_valid_cc := FND_API.G_FALSE;
5264: x_return_status := FND_API.G_RET_STS_ERROR;
5265: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5266: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5267: IF(g_error_level >= g_debug_level) THEN
5268: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5269: END IF;

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

5303: END;
5304: IF NVL(l_COUNT,0) = 0 THEN
5305: x_valid_cc := FND_API.G_FALSE;
5306: x_return_status := FND_API.G_RET_STS_ERROR;
5307: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5308: IF(g_error_level >= g_debug_level) THEN
5309: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5310: END IF;
5311: fnd_msg_pub.add;

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

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
5814: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;

Line 5813: FROM igc_cc_det_pf

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
5814: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
5815: EXCEPTION
5816: WHEN NO_DATA_FOUND THEN
5817: l_cc_det_pf_cnt := 0;

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

5844:
5845: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5846: x_valid_cc := FND_API.G_FALSE;
5847: x_return_status := FND_API.G_RET_STS_ERROR;
5848: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5849: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5850: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5851: IF(g_error_level >= g_debug_level) THEN
5852: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

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
5930: FROM igc_cc_det_pf

Line 5930: FROM igc_cc_det_pf

5926: -- igc_cc_det_pf and replaced the line
5927: -- below.
5928: SELECT count(*)
5929: INTO l_cc_det_pf_cnt
5930: FROM igc_cc_det_pf
5931: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
5932: EXCEPTION
5933: WHEN NO_DATA_FOUND THEN
5934: l_cc_det_pf_cnt := 0;

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

5961:
5962: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5963: x_valid_cc := FND_API.G_FALSE;
5964: x_return_status := FND_API.G_RET_STS_ERROR;
5965: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5966: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5967: IF (g_error_level >= g_debug_level) THEN
5968: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5969: END IF;

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

5976: (p_end_date IS NOT NULL)
5977: ) THEN
5978: x_valid_cc := FND_API.G_FALSE;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5981: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5982: IF(g_error_level >= g_debug_level) THEN
5983: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5984: END IF;

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

6028: END;
6029: IF NVL(l_COUNT,0) = 0 THEN
6030: x_valid_cc := FND_API.G_FALSE;
6031: x_return_status := FND_API.G_RET_STS_ERROR;
6032: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6033: IF(g_error_level >= g_debug_level) THEN
6034: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6035: END IF;
6036: fnd_msg_pub.add;

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

6090: TRUNC(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6091: THEN
6092: x_valid_cc := FND_API.G_FALSE;
6093: x_return_status := FND_API.G_RET_STS_ERROR;
6094: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6095: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6096: IF(g_error_level >= g_debug_level) THEN
6097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6098: END IF;

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

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
6190: FROM igc_cc_det_pf

Line 6190: FROM igc_cc_det_pf

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
6190: FROM igc_cc_det_pf
6191: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
6192:
6193: IF ( l_total_pf_entered_amt +
6194: NVL(l_cc_acct_lines_rec.cc_ent_withheld_amt,0)) <> NVL(l_cc_acct_lines_rec.cc_acct_entered_amt,0)

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

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
6276: FROM igc_cc_det_pf

Line 6276: FROM igc_cc_det_pf

6272: -- igc_cc_det_pf and replaced the line
6273: -- below.
6274: SELECT count(*)
6275: INTO l_cc_det_pf_cnt
6276: FROM igc_cc_det_pf
6277: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
6278: EXCEPTION
6279: WHEN NO_DATA_FOUND THEN
6280: l_cc_det_pf_cnt := 0;

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

6313:
6314: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6315: x_valid_cc := FND_API.G_FALSE;
6316: x_return_status := FND_API.G_RET_STS_ERROR;
6317: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6318: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6319: IF(g_error_level >= g_debug_level) THEN
6320: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6321: END IF;

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

6328: (p_end_date IS NOT NULL)
6329: ) THEN
6330: x_valid_cc := FND_API.G_FALSE;
6331: x_return_status := FND_API.G_RET_STS_ERROR;
6332: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6333: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6334: IF(g_error_level >= g_debug_level) THEN
6335: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6336: END IF;

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

6380: END;
6381: IF NVL(l_COUNT,0) = 0 THEN
6382: x_valid_cc := FND_API.G_FALSE;
6383: x_return_status := FND_API.G_RET_STS_ERROR;
6384: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6385: IF(g_error_level >= g_debug_level) THEN
6386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6387: END IF;
6388: fnd_msg_pub.add;

Line 6446: 'IGC_CC_DET_PF_DATE_NO_UPDATE');

6442: THEN
6443: x_valid_cc := FND_API.G_FALSE;
6444: x_return_status := FND_API.G_RET_STS_ERROR;
6445: fnd_message.set_name('IGC',
6446: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6447: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6448: IF(g_error_level >= g_debug_level) THEN
6449: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6450: END IF;

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;

Line 6540: FROM igc_cc_det_pf

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;
6542:
6543: IF ( l_total_pf_entered_amt
6544: + NVL(l_cc_acct_lines_rec.cc_ent_withheld_amt,0) )