DBA Data[Home] [Help]

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 789: l_event_id XLA_EVENTS_GT.EVENT_ID%TYPE;

785: l_event_number NUMBER;
786: l_reference_info XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO;
787: l_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
788: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
789: l_event_id XLA_EVENTS_GT.EVENT_ID%TYPE;
790: l_budget_dest_flag VARCHAR2(1);
791: l_valuation_method VARCHAR2(3);
792:
793: l_err_code NUMBER;

Line 816: CURSOR c_xla_events_gt IS

812: l_bud_cntrl VARCHAR2(1);
813: l_bc_mode VARCHAR2(2);
814: l_org_id NUMBER;
815:
816: CURSOR c_xla_events_gt IS
817: SELECT * FROM psa_bc_xla_events_gt;
818:
819: BEGIN
820:

Line 817: SELECT * FROM psa_bc_xla_events_gt;

813: l_bc_mode VARCHAR2(2);
814: l_org_id NUMBER;
815:
816: CURSOR c_xla_events_gt IS
817: SELECT * FROM psa_bc_xla_events_gt;
818:
819: BEGIN
820:
821: l_full_path := g_path || 'PROCESS_CC_INT_LINES';

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

871: Put_Debug_Msg (l_full_path, 'Obtained Event Type Code and Entity Type' );
872: Put_Debug_Msg (l_full_path, 'Entity Type Code: ' || l_entity_type || ' Event Type Code: ' || l_event_type_code);
873: END IF;
874:
875: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
876:
877: OPEN c_xla_events_gt;
878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
879: CLOSE c_xla_events_gt;

Line 877: OPEN c_xla_events_gt;

873: END IF;
874:
875: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
876:
877: OPEN c_xla_events_gt;
878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
879: CLOSE c_xla_events_gt;
880:
881: DELETE FROM psa_bc_xla_events_gt pgt ;

Line 878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;

874:
875: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
876:
877: OPEN c_xla_events_gt;
878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
879: CLOSE c_xla_events_gt;
880:
881: DELETE FROM psa_bc_xla_events_gt pgt ;
882:

Line 879: CLOSE c_xla_events_gt;

875: /*Backup records in psa_bc_xla_events_gt before deletion - May be required by calling module after FC call*/
876:
877: OPEN c_xla_events_gt;
878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
879: CLOSE c_xla_events_gt;
880:
881: DELETE FROM psa_bc_xla_events_gt pgt ;
882:
883: /*

Line 881: DELETE FROM psa_bc_xla_events_gt pgt ;

877: OPEN c_xla_events_gt;
878: FETCH c_xla_events_gt BULK COLLECT INTO g_xla_events_gt_tbl;
879: CLOSE c_xla_events_gt;
880:
881: DELETE FROM psa_bc_xla_events_gt pgt ;
882:
883: /*
884: 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
885: PSA fails to fetch the correct Ledger due to Events from 2 different Applications i.e PA and IGC

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

889: (SELECT event_id FROM xla_events xe WHERE application_id = 8407 AND pgt.event_id = xe.event_id);
890: */
891:
892: IF (g_debug_mode = 'Y') THEN
893: Put_Debug_Msg (l_full_path, 'Deleted all Event entries from psa_bc_xla_events_gt' );
894: END IF;
895:
896: FOR i IN 1..g_cc_interface_head_tbl.COUNT
897: LOOP

Line 944: INTO psa_bc_xla_events_gt(event_id, result_code)

940:
941: g_cc_interface_head_tbl(i).event_id := l_event_id;
942:
943: INSERT
944: INTO psa_bc_xla_events_gt(event_id, result_code)
945: VALUES(l_event_id, 'XLA_ERROR');
946:
947: IF (g_debug_mode = 'Y') THEN
948: Put_Debug_Msg (l_full_path, 'Inserted Event ID :' || l_event_id || ' into psa_bc_xla_events_gt' );

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

944: INTO psa_bc_xla_events_gt(event_id, result_code)
945: VALUES(l_event_id, 'XLA_ERROR');
946:
947: IF (g_debug_mode = 'Y') THEN
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

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

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

Line 1077: psa_bc_xla_events_gt));

1073: WHERE funds_checker_code IN(SELECT distinct(result_code)
1074: FROM GL_BC_PACKETS
1075: WHERE event_id IN (SELECT event_id
1076: FROM
1077: psa_bc_xla_events_gt));
1078: x_sev_rank := l_max_sev_rank;
1079: END Get_Status;
1080:
1081: PROCEDURE UNDO_GL_BC_PACKETS(

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

1320: PROCEDURE Restore_events_gt IS
1321:
1322: BEGIN
1323:
1324: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1325: LOOP
1326: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1327: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1328: END LOOP;

Line 1326: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)

1322: BEGIN
1323:
1324: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1325: LOOP
1326: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1327: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1328: END LOOP;
1329:
1330: END Restore_events_gt;

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

1323:
1324: FOR i IN 1..g_xla_events_gt_tbl.COUNT
1325: LOOP
1326: INSERT INTO psa_bc_xla_events_gt (event_id, result_code)
1327: VALUES (g_xla_events_gt_tbl(i).event_id, g_xla_events_gt_tbl(i).result_code);
1328: END LOOP;
1329:
1330: END Restore_events_gt;
1331: