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.PSA_UTILS dependencies on XLA_EVENTS

Line 24: event_id xla_events.event_id%TYPE,

20:
21: TYPE events_rec IS RECORD
22: (
23: entity_id xla_transaction_entities.entity_id%TYPE,
24: event_id xla_events.event_id%TYPE,
25: application_id xla_transaction_entities.application_id%TYPE,
26: event_type_code xla_events.event_type_code%TYPE,
27: entity_code xla_transaction_entities.entity_code%TYPE,
28: budgetary_flag xla_events.budgetary_control_flag%TYPE,

Line 26: event_type_code xla_events.event_type_code%TYPE,

22: (
23: entity_id xla_transaction_entities.entity_id%TYPE,
24: event_id xla_events.event_id%TYPE,
25: application_id xla_transaction_entities.application_id%TYPE,
26: event_type_code xla_events.event_type_code%TYPE,
27: entity_code xla_transaction_entities.entity_code%TYPE,
28: budgetary_flag xla_events.budgetary_control_flag%TYPE,
29: event_status_code xla_events.event_status_code%TYPE,
30: gl_transfer_flag xla_ae_headers.gl_transfer_status_code%TYPE,

Line 28: budgetary_flag xla_events.budgetary_control_flag%TYPE,

24: event_id xla_events.event_id%TYPE,
25: application_id xla_transaction_entities.application_id%TYPE,
26: event_type_code xla_events.event_type_code%TYPE,
27: entity_code xla_transaction_entities.entity_code%TYPE,
28: budgetary_flag xla_events.budgetary_control_flag%TYPE,
29: event_status_code xla_events.event_status_code%TYPE,
30: gl_transfer_flag xla_ae_headers.gl_transfer_status_code%TYPE,
31: gl_date DATE,
32: ae_header_id xla_ae_headers.ae_header_id%TYPE,

Line 29: event_status_code xla_events.event_status_code%TYPE,

25: application_id xla_transaction_entities.application_id%TYPE,
26: event_type_code xla_events.event_type_code%TYPE,
27: entity_code xla_transaction_entities.entity_code%TYPE,
28: budgetary_flag xla_events.budgetary_control_flag%TYPE,
29: event_status_code xla_events.event_status_code%TYPE,
30: gl_transfer_flag xla_ae_headers.gl_transfer_status_code%TYPE,
31: gl_date DATE,
32: ae_header_id xla_ae_headers.ae_header_id%TYPE,
33: ledger_id xla_transaction_entities.ledger_id%TYPE,

Line 317: l_string := 'CREATE TABLE PSA_BKP_XLA_EVENTS_'||l_backup_string||' AS

313: END IF;
314:
315: IF (p_retcode = g_SUCCESS) THEN
316: BEGIN
317: l_string := 'CREATE TABLE PSA_BKP_XLA_EVENTS_'||l_backup_string||' AS
318: SELECT * FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id;
319: EXECUTE IMMEDIATE l_string;
320: EXCEPTION
321: WHEN OTHERS THEN

Line 318: SELECT * FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id;

314:
315: IF (p_retcode = g_SUCCESS) THEN
316: BEGIN
317: l_string := 'CREATE TABLE PSA_BKP_XLA_EVENTS_'||l_backup_string||' AS
318: SELECT * FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id;
319: EXECUTE IMMEDIATE l_string;
320: EXCEPTION
321: WHEN OTHERS THEN
322: log(l_path_name, 'EXCEPTION: '|| SQLERRM(sqlcode));

Line 331: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||

327: IF (p_retcode = g_SUCCESS) THEN
328: BEGIN
329: l_string := 'CREATE TABLE PSA_BKP_XLA_HDRS_'||l_backup_string||' AS
330: SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID IN (
331: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||
332: ')';
333: EXECUTE IMMEDIATE l_string;
334: EXCEPTION
335: WHEN OTHERS THEN

Line 346: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||

342: BEGIN
343: l_string := 'CREATE TABLE PSA_BKP_XLA_LINES_'||l_backup_string||' AS
344: SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID IN (
345: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (
346: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||
347: '))';
348: EXECUTE IMMEDIATE l_string;
349: EXCEPTION
350: WHEN OTHERS THEN

Line 361: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||

357: BEGIN
358: l_string := 'CREATE TABLE PSA_BKP_XLA_DIST_'||l_backup_string||' AS
359: SELECT * FROM XLA_DISTRIBUTION_LINKS WHERE AE_HEADER_ID IN (
360: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (
361: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||
362: '))';
363: EXECUTE IMMEDIATE l_string;
364: EXCEPTION
365: WHEN OTHERS THEN

Line 376: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||

372: BEGIN
373: l_string := 'CREATE TABLE PSA_BKP_XLA_TR_BAL_'||l_backup_string||' AS
374: SELECT * FROM XLA_TRIAL_BALANCES WHERE AE_HEADER_ID IN (
375: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (
376: SELECT EVENT_ID FROM XLA_EVENTS WHERE ENTITY_ID = '||p_entity_rec.entity_id||
377: '))';
378: EXECUTE IMMEDIATE l_string;
379: EXCEPTION
380: WHEN OTHERS THEN

Line 578: DELETE from psa_bc_xla_events_gt;

574: );
575: END IF;
576:
577: IF (p_retcode = g_SUCCESS) THEN
578: DELETE from psa_bc_xla_events_gt;
579: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
580: DELETE from xla_acct_prog_events_gt;
581: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
582: DELETE from xla_ae_headers_gt;

Line 579: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

575: END IF;
576:
577: IF (p_retcode = g_SUCCESS) THEN
578: DELETE from psa_bc_xla_events_gt;
579: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
580: DELETE from xla_acct_prog_events_gt;
581: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
582: DELETE from xla_ae_headers_gt;
583: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

Line 592: INSERT INTO psa_bc_xla_events_gt

588: END IF;
589:
590: IF (p_retcode = g_SUCCESS) THEN
591: FOR i IN 1..p_events_tab.COUNT LOOP
592: INSERT INTO psa_bc_xla_events_gt
593: (
594: event_id,
595: result_code
596: )

Line 716: l_event_source_info xla_events_pub_pkg.t_event_source_info;

712: IS
713: l_path_name VARCHAR2(500);
714: l_gl_period_status gl_period_statuses.closing_status%TYPE;
715: l_gl_period_name gl_period_statuses.period_name%TYPE;
716: l_event_source_info xla_events_pub_pkg.t_event_source_info;
717: l_security_context xla_events_pub_pkg.t_security;
718: l_counter NUMBER;
719: l_old_event_id NUMBER;
720: l_api_version NUMBER := 1.0;

Line 717: l_security_context xla_events_pub_pkg.t_security;

713: l_path_name VARCHAR2(500);
714: l_gl_period_status gl_period_statuses.closing_status%TYPE;
715: l_gl_period_name gl_period_statuses.period_name%TYPE;
716: l_event_source_info xla_events_pub_pkg.t_event_source_info;
717: l_security_context xla_events_pub_pkg.t_security;
718: l_counter NUMBER;
719: l_old_event_id NUMBER;
720: l_api_version NUMBER := 1.0;
721: l_init_msg_list VARCHAR2(300) := fnd_api.g_true;

Line 778: FROM xla_events e

774: AND NVL(source_id_char_2, ' ') = NVL(p_source_id_char_2, ' ')
775: AND NVL(source_id_char_3, ' ') = NVL(p_source_id_char_3, ' ')
776: AND NVL(source_id_char_4, ' ') = NVL(p_source_id_char_4, ' ')
777: AND EXISTS (SELECT 1
778: FROM xla_events e
779: WHERE t.entity_id = e.entity_id);
780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN
782: error('No Entity Found for application id='||p_application_id ||

Line 841: FROM xla_events e,

837: e.event_type_code,
838: ent.legal_entity_id,
839: ent.ledger_id,
840: ent.transaction_number
841: FROM xla_events e,
842: xla_ae_headers h,
843: xla_transaction_entities ent
844: WHERE ent.source_id_int_1 = p_source_id_int_1
845: and ent.application_id = p_application_id

Line 923: log(l_path_name, 'Calling xla_events_pub_pkg.delete_event ');

919: l_event_source_info.legal_entity_id := p_events_tab(l_counter).legal_entity_id;
920: l_event_source_info.transaction_number := p_events_tab(l_counter).transaction_number;
921: l_event_source_info.source_id_int_1 := p_events_tab(l_counter).source_id_int_1;
922: l_security_context.security_id_int_1 := p_org_id;
923: log(l_path_name, 'Calling xla_events_pub_pkg.delete_event ');
924:
925: xla_events_pub_pkg.delete_event
926: (
927: p_event_source_info => l_event_source_info,

Line 925: xla_events_pub_pkg.delete_event

921: l_event_source_info.source_id_int_1 := p_events_tab(l_counter).source_id_int_1;
922: l_security_context.security_id_int_1 := p_org_id;
923: log(l_path_name, 'Calling xla_events_pub_pkg.delete_event ');
924:
925: xla_events_pub_pkg.delete_event
926: (
927: p_event_source_info => l_event_source_info,
928: p_event_id => p_events_tab(l_counter).event_id,
929: p_valuation_method => l_valuation_method,

Line 934: log(l_path_name, 'Deleting BC XLA Events');

930: p_security_context => l_security_context
931: );
932: IF (p_application_id IN (200)) THEN
933: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
934: log(l_path_name, 'Deleting BC XLA Events');
935: DELETE xla_events
936: WHERE event_id = p_events_tab(l_counter).event_id;
937: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
938: END IF;

Line 935: DELETE xla_events

931: );
932: IF (p_application_id IN (200)) THEN
933: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
934: log(l_path_name, 'Deleting BC XLA Events');
935: DELETE xla_events
936: WHERE event_id = p_events_tab(l_counter).event_id;
937: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
938: END IF;
939: END IF;

Line 937: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');

933: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
934: log(l_path_name, 'Deleting BC XLA Events');
935: DELETE xla_events
936: WHERE event_id = p_events_tab(l_counter).event_id;
937: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
938: END IF;
939: END IF;
940: ELSE
941: IF (NVL(p_events_tab(l_counter).gl_transfer_flag, 'N') <> 'Y') THEN

Line 996: log(l_path_name, 'Deleting BC XLA Events');

992: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from GL BC Packets');
993: End if;
994: IF (p_application_id IN (200)) THEN
995: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
996: log(l_path_name, 'Deleting BC XLA Events');
997: DELETE xla_events
998: WHERE event_id = p_events_tab(l_counter).event_id;
999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
1000: ELSE

Line 997: DELETE xla_events

993: End if;
994: IF (p_application_id IN (200)) THEN
995: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
996: log(l_path_name, 'Deleting BC XLA Events');
997: DELETE xla_events
998: WHERE event_id = p_events_tab(l_counter).event_id;
999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
1000: ELSE
1001: log(l_path_name, 'Updating AP XLA Events');

Line 999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');

995: IF (p_events_tab(l_counter).budgetary_flag = 'Y') THEN
996: log(l_path_name, 'Deleting BC XLA Events');
997: DELETE xla_events
998: WHERE event_id = p_events_tab(l_counter).event_id;
999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
1000: ELSE
1001: log(l_path_name, 'Updating AP XLA Events');
1002: UPDATE xla_events
1003: SET event_date = p_events_tab(l_counter).gl_date

Line 1001: log(l_path_name, 'Updating AP XLA Events');

997: DELETE xla_events
998: WHERE event_id = p_events_tab(l_counter).event_id;
999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
1000: ELSE
1001: log(l_path_name, 'Updating AP XLA Events');
1002: UPDATE xla_events
1003: SET event_date = p_events_tab(l_counter).gl_date
1004: WHERE event_id = p_events_tab(l_counter).event_id;
1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');

Line 1002: UPDATE xla_events

998: WHERE event_id = p_events_tab(l_counter).event_id;
999: log(l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows from xla_events');
1000: ELSE
1001: log(l_path_name, 'Updating AP XLA Events');
1002: UPDATE xla_events
1003: SET event_date = p_events_tab(l_counter).gl_date
1004: WHERE event_id = p_events_tab(l_counter).event_id;
1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1006: END IF;

Line 1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');

1001: log(l_path_name, 'Updating AP XLA Events');
1002: UPDATE xla_events
1003: SET event_date = p_events_tab(l_counter).gl_date
1004: WHERE event_id = p_events_tab(l_counter).event_id;
1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1006: END IF;
1007: ELSE
1008: log(l_path_name, 'Updating AP XLA Events');
1009: UPDATE xla_events

Line 1008: log(l_path_name, 'Updating AP XLA Events');

1004: WHERE event_id = p_events_tab(l_counter).event_id;
1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1006: END IF;
1007: ELSE
1008: log(l_path_name, 'Updating AP XLA Events');
1009: UPDATE xla_events
1010: SET event_date = p_events_tab(l_counter).gl_date
1011: WHERE event_id = p_events_tab(l_counter).event_id;
1012: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');

Line 1009: UPDATE xla_events

1005: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1006: END IF;
1007: ELSE
1008: log(l_path_name, 'Updating AP XLA Events');
1009: UPDATE xla_events
1010: SET event_date = p_events_tab(l_counter).gl_date
1011: WHERE event_id = p_events_tab(l_counter).event_id;
1012: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1013: END IF;

Line 1012: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');

1008: log(l_path_name, 'Updating AP XLA Events');
1009: UPDATE xla_events
1010: SET event_date = p_events_tab(l_counter).gl_date
1011: WHERE event_id = p_events_tab(l_counter).event_id;
1012: log(l_path_name, 'Updated '||SQL%ROWCOUNT||' rows in xla_events');
1013: END IF;
1014: END IF;
1015: END IF; -- status
1016:

Line 1139: from xla_events e,

1135: --COMMIT;
1136: /*
1137: debug_other_string(g_state_level,l_path_name, 'Checking if all events cleaned up' );
1138: select count(*) into l_event_check
1139: from xla_events e,
1140: xla_transaction_entities ent
1141: WHERE ent.source_id_int_1 = p_invoice_id
1142: and ent.application_id = l_application_id
1143: AND ent.entity_code = l_entity_code

Line 1156: from xla_events e,

1152: End if;
1153: */
1154: debug_other_string(g_state_level,l_path_name, 'Checking if all Header/links cleaned up' );
1155: select count(*) into l_event_check
1156: from xla_events e,
1157: xla_transaction_entities ent,
1158: xla_ae_headers h
1159: WHERE ent.source_id_int_1 = p_invoice_id
1160: and ent.application_id = l_application_id

Line 1625: xla_events e

1621: l_count := 0;
1622: FOR xla_rec IN (SELECT e.event_id,
1623: e.entity_id
1624: FROM xla_transaction_entities t,
1625: xla_events e
1626: WHERE t.application_id = l_application_id
1627: AND t.entity_code = 'PURCHASE_ORDER'
1628: AND t.source_id_int_1 = p_po_header_id
1629: AND t.entity_id = e.entity_id