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_AE_HEADERS

Line 30: gl_transfer_flag xla_ae_headers.gl_transfer_status_code%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,
34: transaction_number xla_transaction_entities.transaction_number%TYPE,

Line 32: ae_header_id xla_ae_headers.ae_header_id%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,
34: transaction_number xla_transaction_entities.transaction_number%TYPE,
35: source_id_int_1 xla_transaction_entities.source_id_int_1%TYPE,
36: source_id_int_2 xla_transaction_entities.source_id_int_2%TYPE,

Line 330: SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID IN (

326:
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

Line 345: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (

341: IF (p_retcode = g_SUCCESS) THEN
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

Line 360: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (

356: IF (p_retcode = g_SUCCESS) THEN
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

Line 375: SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE EVENT_ID IN (

371: IF (p_retcode = g_SUCCESS) THEN
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

Line 582: DELETE from xla_ae_headers_gt;

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);
584: DELETE from xla_ae_lines_gt;
585: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_ae_lines_gt: ' || SQL%ROWCOUNT);
586: DELETE from xla_validation_lines_gt;

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

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);
584: DELETE from xla_ae_lines_gt;
585: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_ae_lines_gt: ' || SQL%ROWCOUNT);
586: DELETE from xla_validation_lines_gt;
587: debug_other_string(g_state_level,l_path_name,'Number of rows deleted of xla_validation_lines_gt: ' || SQL%ROWCOUNT);

Line 842: xla_ae_headers h,

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
846: AND ent.entity_code = p_entity_code

Line 1158: xla_ae_headers h

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
1161: AND ent.entity_code = l_entity_code
1162: and e.entity_id = ent.entity_id