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_INTERFACE

Line 1292: p_cc_interface_rec IN igc_cc_interface%ROWTYPE,

1288:
1289: END Execute_Rel_Budgetary_Ctrl;
1290:
1291: PROCEDURE Insert_Interface_Row(
1292: p_cc_interface_rec IN igc_cc_interface%ROWTYPE,
1293: x_msg_count OUT NOCOPY NUMBER,
1294: x_msg_data OUT NOCOPY VARCHAR2,
1295: x_return_status OUT NOCOPY VARCHAR2
1296: ) IS

Line 1308: INTO igc_cc_interface (

1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306:
1307: INSERT
1308: INTO igc_cc_interface (
1309: batch_line_num,
1310: cc_header_id,
1311: cc_version_num,
1312: cc_acct_line_id,

Line 1440: l_cc_interface_rec igc_cc_interface%ROWTYPE;

1436: x_msg_data OUT NOCOPY VARCHAR2,
1437: x_return_status OUT NOCOPY VARCHAR2
1438: ) IS
1439:
1440: l_cc_interface_rec igc_cc_interface%ROWTYPE;
1441: l_enc_amt NUMBER;
1442: l_func_amt NUMBER;
1443: l_billed_amt NUMBER;
1444: l_func_billed_amt NUMBER;

Line 1468: -- DELETE FROM igc_cc_interface

1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465:
1466: -- Bug 1914745, clean up any old records before, more than 2 days old
1467: -- processing new ones.
1468: -- DELETE FROM igc_cc_interface
1469: --WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1470:
1471: -- Bug 2872060 delete statement above causing compilation probs in oracle8i
1472: DELETE FROM igc_cc_interface

Line 1472: DELETE FROM igc_cc_interface

1468: -- DELETE FROM igc_cc_interface
1469: --WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1470:
1471: -- Bug 2872060 delete statement above causing compilation probs in oracle8i
1472: DELETE FROM igc_cc_interface
1473: WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date(sysdate ,'DD/MM/YYYY') - 2;
1474:
1475: l_cc_interface_rec.cbc_result_code := NULL;
1476: l_cc_interface_rec.status_code := NULL;

Line 2036: l_budget_dest_flag igc_cc_interface.budget_dest_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;
2040: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

Line 2037: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;

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;
2040: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2041:

Line 2066: l_cc_interface_rec igc_cc_interface%ROWTYPE;

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:
2070: l_currency_code gl_sets_of_books.currency_code%TYPE;

Line 2120: FROM igc_cc_interface

2116:
2117: /*Budgetary Control Interface */
2118: CURSOR c_cc_interface(t_cc_header_id NUMBER) IS
2119: SELECT distinct cc_header_id, cc_acct_line_id, cc_det_pf_line_id, budget_dest_flag, cc_transaction_date
2120: FROM igc_cc_interface
2121: WHERE cc_header_id = t_cc_header_id AND
2122: actual_flag = 'E';
2123:
2124: /* Current year payment forecast lines only */

Line 2396: DELETE igc_cc_interface

2392:
2393: IF (l_cc_headers_rec.cc_type <> 'R')
2394: THEN
2395: BEGIN
2396: DELETE igc_cc_interface
2397: WHERE cc_header_id = p_cc_header_id AND
2398: actual_flag = 'E';
2399: EXCEPTION
2400: WHEN OTHERS THEN

Line 2710: FROM igc_cc_interface

2706: l_interface_row_count := 0;
2707:
2708: select count(*)
2709: INTO l_interface_row_count
2710: FROM igc_cc_interface
2711: WHERE cc_header_id = p_cc_header_id;
2712:
2713: SAVEPOINT Execute_Budgetary_Ctrl4;
2714: /* Execute budgetary control */

Line 2780: /* Update CC Tables with feedback from igc_cc_interface */

2776: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2777: END IF;
2778:
2779: /* Budgetary Control Successfully executed */
2780: /* Update CC Tables with feedback from igc_cc_interface */
2781:
2782: /* If mode = Reservation then update CC Tables encumbrance status, encumbered_amount */
2783:
2784: BEGIN

Line 3833: FROM igc_cc_interface

3829: THEN
3830: --ROLLBACK TO Execute_Budgetary_Ctrl4;
3831: select count(*)
3832: INTO x_msg_count
3833: FROM igc_cc_interface
3834: WHERE cc_header_id = p_cc_header_id;
3835:
3836: IF (l_cc_apprvl_status_old <> 'IP')
3837: THEN