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 240: FROM igc_cc_interface_v a

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

Line 268: l_cc_header_rec IGC_CC_INTERFACE%ROWTYPE ;

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

Line 352: FROM igc_cc_interface_v a

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

Line 742: FROM IGC_CC_INTERFACE

738: REFERENCE_4,
739: CC_TRANSACTION_DATE,
740: EVENT_ID,
741: CC_DET_PF_LINE_ID
742: FROM IGC_CC_INTERFACE
743: WHERE event_id IS NULL
744: AND cc_header_id = g_cc_header_id;
745:
746: l_full_path VARCHAR2(255);

Line 952: UPDATE igc_cc_interface

948: Put_Debug_Msg (l_full_path, 'Inserted Event ID :' || l_event_id || ' into psa_bc_xla_events_gt' );
949: END IF;
950:
951:
952: UPDATE igc_cc_interface
953: SET event_id = l_event_id
954: WHERE cc_header_id = g_cc_interface_head_tbl(i).cc_header_id
955: AND document_type = g_cc_interface_head_tbl(i).document_type
956: AND budget_dest_flag = g_cc_interface_head_tbl(i).budget_dest_flag

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

959: AND cc_transaction_date = g_cc_interface_head_tbl(i).cc_transaction_date;
960:
961: IF (g_debug_mode = 'Y') THEN
962: Put_Debug_Msg (l_full_path, 'Inserted Event ID: ' || l_event_id || ' into psa_bc_xla_events_gt' );
963: Put_Debug_Msg (l_full_path, 'Update Event ID: ' || l_event_id || ' in IGC_CC_INTERFACE' );
964: END IF;
965:
966: END IF;
967:

Line 1150: UPDATE igc_cc_interface int

1146: IF (g_debug_mode = 'Y') THEN
1147: Put_Debug_Msg (l_full_path, 'Updating Batch Result Code for CC Header ID: '|| g_cc_header_id);
1148: END IF;
1149:
1150: UPDATE igc_cc_interface int
1151: SET (batch_id,
1152: cbc_result_code,
1153: status_code,
1154: budget_version_id,

Line 1245: FROM igc_cc_interface

1241: IF l_doc_type = 'CC' THEN
1242: /*Added for CBC Upgrade - Start*/
1243: SELECT distinct reference_8
1244: INTO l_reference_8
1245: FROM igc_cc_interface
1246: WHERE cc_header_id = g_cc_header_id;
1247: IF (l_reference_8 IS NULL) THEN
1248: /*Added for CBC Upgrade - End*/
1249: IF (p_org_id IS NULL) THEN

Line 1270: FROM igc_cc_interface

1266: END IF;
1267: /*Added for CBC Upgrade - Start*/
1268: ELSIF (l_reference_8 = 'MIG') THEN
1269: SELECT distinct je_category_name INTO l_je_category_name
1270: FROM igc_cc_interface
1271: WHERE cc_header_id = g_cc_header_id;
1272: IF (l_je_category_name = 'Provisional') THEN
1273: x_entity_type := 'CC_CONTRACTS';
1274: x_event_type_code := 'CC_CONTRACT_PRO_RESERVE';

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

1335:
1336: FOR i IN 1..g_cc_interface_head_tbl.COUNT
1337: LOOP
1338:
1339: UPDATE igc_cc_interface SET event_id = g_cc_interface_head_tbl(i).event_id
1340: WHERE
1341: cc_header_id = g_cc_interface_head_tbl(i).cc_header_id AND
1342: document_type = g_cc_interface_head_tbl(i).document_type AND
1343: budget_dest_flag = g_cc_interface_head_tbl(i).budget_dest_flag AND

Line 1378: FROM igc_cc_interface

1374: FROM igc_cc_result_code_ranks
1375: WHERE funds_checker_code IN
1376: (
1377: SELECT TRIM(cbc_result_code)
1378: FROM igc_cc_interface
1379: WHERE cc_header_id = g_cc_header_id
1380: )
1381: );
1382: