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 2094: l_budget_dest_flag igc_cc_interface.budget_dest_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;
2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

Line 2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;

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

Line 2124: l_cc_interface_rec igc_cc_interface%ROWTYPE;

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

Line 2178: FROM igc_cc_interface

2174:
2175: /*Budgetary Control Interface */
2176: CURSOR c_cc_interface(t_cc_header_id NUMBER) IS
2177: SELECT distinct cc_header_id, cc_acct_line_id, cc_det_pf_line_id, budget_dest_flag, cc_transaction_date
2178: FROM igc_cc_interface
2179: WHERE cc_header_id = t_cc_header_id AND
2180: actual_flag = 'E';
2181:
2182: /* Current year payment forecast lines only */

Line 2454: DELETE igc_cc_interface

2450:
2451: IF (l_cc_headers_rec.cc_type <> 'R')
2452: THEN
2453: BEGIN
2454: DELETE igc_cc_interface
2455: WHERE cc_header_id = p_cc_header_id AND
2456: actual_flag = 'E';
2457: EXCEPTION
2458: WHEN OTHERS THEN

Line 2768: FROM igc_cc_interface

2764: l_interface_row_count := 0;
2765:
2766: select count(*)
2767: INTO l_interface_row_count
2768: FROM igc_cc_interface
2769: WHERE cc_header_id = p_cc_header_id;
2770:
2771: SAVEPOINT Execute_Budgetary_Ctrl4;
2772: /* Execute budgetary control */

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

2834: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2835: END IF;
2836:
2837: /* Budgetary Control Successfully executed */
2838: /* Update CC Tables with feedback from igc_cc_interface */
2839:
2840: /* If mode = Reservation then update CC Tables encumbrance status, encumbered_amount */
2841:
2842: BEGIN

Line 3891: FROM igc_cc_interface

3887: THEN
3888: --ROLLBACK TO Execute_Budgetary_Ctrl4;
3889: select count(*)
3890: INTO x_msg_count
3891: FROM igc_cc_interface
3892: WHERE cc_header_id = p_cc_header_id;
3893:
3894: IF (l_cc_apprvl_status_old <> 'IP')
3895: THEN