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_CBC_FUNDS_CHECKER dependencies on IGC_CC_INTERFACE

Line 8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,

4:
5: /*R12 Uptake Refer Bug No : 6341012 - Start*/
6:
7: TYPE g_cc_interface_head_rec_type IS RECORD
8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,
9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,

Line 9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,

5: /*R12 Uptake Refer Bug No : 6341012 - Start*/
6:
7: TYPE g_cc_interface_head_rec_type IS RECORD
8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,
9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,

Line 10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,

6:
7: TYPE g_cc_interface_head_rec_type IS RECORD
8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,
9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,
14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE

Line 11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,

7: TYPE g_cc_interface_head_rec_type IS RECORD
8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,
9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,
14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE
15: );

Line 12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,

8: (CC_HEADER_ID igc_cc_interface.cc_header_id%TYPE,
9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,
14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE
15: );
16: TYPE g_cc_interface_head_tbl_type IS TABLE OF g_cc_interface_head_rec_type;

Line 13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,

9: DOCUMENT_TYPE igc_cc_interface.DOCUMENT_TYPE%TYPE,
10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,
14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE
15: );
16: TYPE g_cc_interface_head_tbl_type IS TABLE OF g_cc_interface_head_rec_type;
17: g_cc_interface_head_tbl g_cc_interface_head_tbl_type;

Line 14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE

10: BUDGET_DEST_FLAG igc_cc_interface.BUDGET_DEST_FLAG%TYPE,
11: REFERENCE_4 igc_cc_interface.REFERENCE_4%TYPE,
12: CC_TRANSACTION_DATE igc_cc_interface.CC_TRANSACTION_DATE%TYPE,
13: EVENT_ID igc_cc_interface.EVENT_ID%TYPE,
14: CC_DET_PF_LINE_ID igc_cc_interface.CC_DET_PF_LINE_ID%TYPE
15: );
16: TYPE g_cc_interface_head_tbl_type IS TABLE OF g_cc_interface_head_rec_type;
17: g_cc_interface_head_tbl g_cc_interface_head_tbl_type;
18:

Line 37: g_cc_header_id igc_cc_interface.cc_header_id%TYPE;

33: g_debug VARCHAR2(10000);
34: g_conc_proc BOOLEAN := FALSE;
35: g_mode VARCHAR2(1);
36:
37: g_cc_header_id igc_cc_interface.cc_header_id%TYPE;
38: /*
39: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
40: */
41: /*R12 Uptake Refer Bug No : 6341012 - Start*/

Line 47: g_update_login igc_cc_interface.last_update_login%TYPE;

43: g_cbc_ledger_id gl_ledgers.ledger_id%TYPE;
44: g_cbc_ledger_name VARCHAR2(50);
45: /*R12 Uptake Refer Bug No : 6341012 - End*/
46: g_actual_flag VARCHAR2(1);
47: g_update_login igc_cc_interface.last_update_login%TYPE;
48: g_update_by igc_cc_interface.last_updated_by%TYPE;
49: g_resp_id NUMBER;
50: g_maxloops NUMBER(10) := 50;
51: g_seconds NUMBER(10) := 2;

Line 48: g_update_by igc_cc_interface.last_updated_by%TYPE;

44: g_cbc_ledger_name VARCHAR2(50);
45: /*R12 Uptake Refer Bug No : 6341012 - End*/
46: g_actual_flag VARCHAR2(1);
47: g_update_login igc_cc_interface.last_update_login%TYPE;
48: g_update_by igc_cc_interface.last_updated_by%TYPE;
49: g_resp_id NUMBER;
50: g_maxloops NUMBER(10) := 50;
51: g_seconds NUMBER(10) := 2;
52: g_cbc_flag BOOLEAN :=TRUE;

Line 65: g_doc_type IGC_CC_INTERFACE.document_type%TYPE;

61: g_com_enc_id IGC_CBC_JE_LINES.encumbrance_type_id%TYPE;
62: g_obl_enc_id IGC_CBC_JE_LINES.encumbrance_type_id%TYPE;
63:
64: g_cbc_enabled VARCHAR2(1);
65: g_doc_type IGC_CC_INTERFACE.document_type%TYPE;
66: g_validation_error BOOLEAN;
67: g_batch_result_code VARCHAR2(4); --Global maximum rank
68: g_efc_enabled VARCHAR2(1);
69: g_prod VARCHAR2(3) := 'IGC';

Line 244: FROM igc_cc_interface_v a

240: reference_7 ,
241: reference_8 ,
242: reference_9 ,
243: reference_10
244: FROM igc_cc_interface_v a
245: WHERE cc_header_id = g_cc_header_id
246: -- AND budget_dest_flag = 'C' /*R12 Uptake. Need to process for both Commitment and Standard budget*/
247: AND actual_flag = g_actual_flag
248: AND document_type = g_doc_type

Line 272: l_cc_header_rec IGC_CC_INTERFACE%ROWTYPE ;

268: l_pop_ret_status VARCHAR2(4);
269: l_pro_ret_status VARCHAR2(4);
270: l_undo_ret_status VARCHAR2(4);
271: -- ssmales 28/01/02 bug 2201905 - added variables below
272: l_cc_header_rec IGC_CC_INTERFACE%ROWTYPE ;
273: l_full_path VARCHAR2(255);
274: BEGIN
275: -- Standard Start of API savepoint
276: SAVEPOINT IGCFCK;

Line 356: FROM igc_cc_interface_v a

352:
353: /*Get the Rank for entries that already have CBC_RESULT_CODE. Based on the Rank set the Batch Result Code*/
354: SELECT MIN(Get_Rank(cbc_result_code))
355: INTO l_rank
356: FROM igc_cc_interface_v a
357: WHERE cc_header_id = g_cc_header_id
358: AND budget_dest_flag = 'C'
359: AND actual_flag = g_actual_flag
360: AND document_type = g_doc_type

Line 752: FROM IGC_CC_INTERFACE

748: REFERENCE_4,
749: CC_TRANSACTION_DATE,
750: EVENT_ID,
751: CC_DET_PF_LINE_ID
752: FROM IGC_CC_INTERFACE
753: WHERE event_id IS NULL
754: AND cc_header_id = g_cc_header_id;
755:
756: l_full_path VARCHAR2(255);

Line 962: UPDATE igc_cc_interface

958: Put_Debug_Msg (l_full_path, 'Inserted Event ID :' || l_event_id || ' into psa_bc_xla_events_gt' );
959: END IF;
960:
961:
962: UPDATE igc_cc_interface
963: SET event_id = l_event_id
964: WHERE cc_header_id = g_cc_interface_head_tbl(i).cc_header_id
965: AND document_type = g_cc_interface_head_tbl(i).document_type
966: AND budget_dest_flag = g_cc_interface_head_tbl(i).budget_dest_flag

Line 973: Put_Debug_Msg (l_full_path, 'Update Event ID: ' || l_event_id || ' in IGC_CC_INTERFACE' );

969: AND cc_transaction_date = g_cc_interface_head_tbl(i).cc_transaction_date;
970:
971: IF (g_debug_mode = 'Y') THEN
972: Put_Debug_Msg (l_full_path, 'Inserted Event ID: ' || l_event_id || ' into psa_bc_xla_events_gt' );
973: Put_Debug_Msg (l_full_path, 'Update Event ID: ' || l_event_id || ' in IGC_CC_INTERFACE' );
974: END IF;
975:
976: END IF;
977:

Line 1163: UPDATE igc_cc_interface int

1159: IF (g_debug_mode = 'Y') THEN
1160: Put_Debug_Msg (l_full_path, 'Updating Batch Result Code for CC Header ID: '|| g_cc_header_id);
1161: END IF;
1162:
1163: UPDATE igc_cc_interface int
1164: SET (batch_id,
1165: cbc_result_code,
1166: status_code,
1167: budget_version_id,

Line 1262: FROM igc_cc_interface

1258: IF l_doc_type = 'CC' THEN
1259: /*Added for CBC Upgrade - Start*/
1260: SELECT distinct reference_8
1261: INTO l_reference_8
1262: FROM igc_cc_interface
1263: WHERE cc_header_id = g_cc_header_id;
1264: IF (l_reference_8 IS NULL) THEN
1265: /*Added for CBC Upgrade - End*/
1266: IF (p_org_id IS NULL) THEN

Line 1287: FROM igc_cc_interface

1283: END IF;
1284: /*Added for CBC Upgrade - Start*/
1285: ELSIF (l_reference_8 = 'MIG') THEN
1286: SELECT distinct je_category_name INTO l_je_category_name
1287: FROM igc_cc_interface
1288: WHERE cc_header_id = g_cc_header_id;
1289: IF (l_je_category_name = 'Provisional') THEN
1290: x_entity_type := 'CC_CONTRACTS';
1291: x_event_type_code := 'CC_CONTRACT_PRO_RESERVE';

Line 1356: UPDATE igc_cc_interface SET event_id = g_cc_interface_head_tbl(i).event_id

1352:
1353: FOR i IN 1..g_cc_interface_head_tbl.COUNT
1354: LOOP
1355:
1356: UPDATE igc_cc_interface SET event_id = g_cc_interface_head_tbl(i).event_id
1357: WHERE
1358: cc_header_id = g_cc_interface_head_tbl(i).cc_header_id AND
1359: document_type = g_cc_interface_head_tbl(i).document_type AND
1360: budget_dest_flag = g_cc_interface_head_tbl(i).budget_dest_flag AND

Line 1395: FROM igc_cc_interface

1391: FROM igc_cc_result_code_ranks
1392: WHERE funds_checker_code IN
1393: (
1394: SELECT TRIM(cbc_result_code)
1395: FROM igc_cc_interface
1396: WHERE cc_header_id = g_cc_header_id
1397: )
1398: );
1399: