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 XLA_EVENTS_GT

Line 19: TYPE g_xla_events_gt_rec_type IS RECORD

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:
19: TYPE g_xla_events_gt_rec_type IS RECORD
20: (
21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,
22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE
23: );

Line 21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,

17: g_cc_interface_head_tbl g_cc_interface_head_tbl_type;
18:
19: TYPE g_xla_events_gt_rec_type IS RECORD
20: (
21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,
22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE
23: );
24: TYPE g_xla_events_gt_tbl_type IS TABLE OF g_xla_events_gt_rec_type;
25: g_xla_events_gt_tbl g_xla_events_gt_tbl_type;

Line 22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE

18:
19: TYPE g_xla_events_gt_rec_type IS RECORD
20: (
21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,
22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE
23: );
24: TYPE g_xla_events_gt_tbl_type IS TABLE OF g_xla_events_gt_rec_type;
25: g_xla_events_gt_tbl g_xla_events_gt_tbl_type;
26:

Line 24: TYPE g_xla_events_gt_tbl_type IS TABLE OF g_xla_events_gt_rec_type;

20: (
21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,
22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE
23: );
24: TYPE g_xla_events_gt_tbl_type IS TABLE OF g_xla_events_gt_rec_type;
25: g_xla_events_gt_tbl g_xla_events_gt_tbl_type;
26:
27: TYPE g_num_rec IS TABLE OF NUMBER;
28:

Line 25: g_xla_events_gt_tbl g_xla_events_gt_tbl_type;

21: EVENT_ID psa_bc_xla_events_gt.event_id%TYPE,
22: RESULT_CODE psa_bc_xla_events_gt.result_code%TYPE
23: );
24: TYPE g_xla_events_gt_tbl_type IS TABLE OF g_xla_events_gt_rec_type;
25: g_xla_events_gt_tbl g_xla_events_gt_tbl_type;
26:
27: TYPE g_num_rec IS TABLE OF NUMBER;
28:
29: /*R12 Uptake Refer Bug No : 6341012 - End*/

Line 799: l_event_id XLA_EVENTS_GT.EVENT_ID%TYPE;

795: l_event_number NUMBER;
796: l_reference_info XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO;
797: l_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
798: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
799: l_event_id XLA_EVENTS_GT.EVENT_ID%TYPE;
800: l_budget_dest_flag VARCHAR2(1);
801: l_valuation_method VARCHAR2(3);
802:
803: l_err_code NUMBER;

Line 826: CURSOR c_xla_events_gt IS

822: l_bud_cntrl VARCHAR2(1);
823: l_bc_mode VARCHAR2(2);
824: l_org_id NUMBER;
825:
826: CURSOR c_xla_events_gt IS
827: SELECT * FROM psa_bc_xla_events_gt;
828:
829: BEGIN
830:

Line 827: SELECT * FROM psa_bc_xla_events_gt;

823: l_bc_mode VARCHAR2(2);
824: l_org_id NUMBER;
825:
826: CURSOR c_xla_events_gt IS
827: SELECT * FROM psa_bc_xla_events_gt;
828:
829: BEGIN
830:
831: l_full_path := g_path || 'PROCESS_CC_INT_LINES';

Line 885: /Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call/

881: Put_Debug_Msg (l_full_path, 'Obtained Event Type Code and Entity Type' );
882: Put_Debug_Msg (l_full_path, 'Entity Type Code: ' || l_entity_type || ' Event Type Code: ' || l_event_type_code);
883: END IF;
884:
885: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
886:
887: OPEN c_xla_events_gt;
888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
889: CLOSE c_xla_events_gt;

Line 887: OPEN c_xla_events_gt;

883: END IF;
884:
885: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
886:
887: OPEN c_xla_events_gt;
888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
889: CLOSE c_xla_events_gt;
890:
891: DELETE FROM psa_bc_xla_events_gt pgt ;

Line 888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;

884:
885: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
886:
887: OPEN c_xla_events_gt;
888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
889: CLOSE c_xla_events_gt;
890:
891: DELETE FROM psa_bc_xla_events_gt pgt ;
892:

Line 889: CLOSE c_xla_events_gt;

885: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
886:
887: OPEN c_xla_events_gt;
888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
889: CLOSE c_xla_events_gt;
890:
891: DELETE FROM psa_bc_xla_events_gt pgt ;
892:
893: /*

Line 891: DELETE FROM psa_bc_xla_events_gt pgt ;

887: OPEN c_xla_events_gt;
888: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
889: CLOSE c_xla_events_gt;
890:
891: DELETE FROM psa_bc_xla_events_gt pgt ;
892:
893: /*
894: Commented due to issues during baselining - GT table has PA Events and IGC Events. This will cause PSA Funds Checker to fail with XLA-ERROR
895: PSA fails to fetch the correct Ledger due to Events from 2 different Applications i.e PA and IGC

Line 903: Put_Debug_Msg (l_full_path, 'Deleted all Event entries from psa_bc_xla_events_gt' );

899: (SELECT event_id FROM xla_events xe WHERE application_id = 8407 AND pgt.event_id = xe.event_id);
900: */
901:
902: IF (g_debug_mode = 'Y') THEN
903: Put_Debug_Msg (l_full_path, 'Deleted all Event entries from psa_bc_xla_events_gt' );
904: END IF;
905:
906: FOR i IN 1..g_cc_interface_head_tbl.COUNT
907: LOOP

Line 954: INTO psa_bc_xla_events_gt(event_id, result_code)

950:
951: g_cc_interface_head_tbl(i).event_id := l_event_id;
952:
953: INSERT
954: INTO psa_bc_xla_events_gt(event_id, result_code)
955: VALUES(l_event_id, 'XLA_ERROR');
956:
957: IF (g_debug_mode = 'Y') THEN
958: Put_Debug_Msg (l_full_path, 'Inserted Event ID :' || l_event_id || ' into psa_bc_xla_events_gt' );

Line 958: Put_Debug_Msg (l_full_path, 'Inserted Event ID :' || l_event_id || ' into psa_bc_xla_events_gt' );

954: INTO psa_bc_xla_events_gt(event_id, result_code)
955: VALUES(l_event_id, 'XLA_ERROR');
956:
957: IF (g_debug_mode = 'Y') THEN
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

Line 972: Put_Debug_Msg (l_full_path, 'Inserted Event ID: ' || l_event_id || ' into psa_bc_xla_events_gt' );

968: AND nvl(cc_det_pf_line_id, 1) = nvl(g_cc_interface_head_tbl(i).cc_det_pf_line_id, 1)
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;

Line 1087: psa_bc_xla_events_gt));

1083: WHERE funds_checker_code IN(SELECT distinct(result_code)
1084: FROM GL_BC_PACKETS
1085: WHERE event_id IN (SELECT event_id
1086: FROM
1087: psa_bc_xla_events_gt));
1088: x_sev_rank := l_max_sev_rank;
1089: END Get_Status;
1090:
1091: PROCEDURE UNDO_GL_BC_PACKETS(

Line 1341: FOR i IN 1..g_xla_events_gt_tbl.COUNT

1337: PROCEDURE Restore_events_gt IS
1338:
1339: BEGIN
1340:
1341: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1342: LOOP
1343: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1344: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1345: END LOOP;

Line 1343: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)

1339: BEGIN
1340:
1341: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1342: LOOP
1343: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1344: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1345: END LOOP;
1346:
1347: END Restore_events_gt;

Line 1344: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);

1340:
1341: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1342: LOOP
1343: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1344: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1345: END LOOP;
1346:
1347: END Restore_events_gt;
1348: