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_TRANSACTION_ENTITIES

Line 23: entity_id xla_transaction_entities.entity_id%TYPE,

19: g_audsid NUMBER;
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,

Line 25: application_id xla_transaction_entities.application_id%TYPE,

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,
29: event_status_code xla_events.event_status_code%TYPE,

Line 27: entity_code xla_transaction_entities.entity_code%TYPE,

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,
31: gl_date DATE,

Line 33: ledger_id xla_transaction_entities.ledger_id%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,

Line 34: transaction_number xla_transaction_entities.transaction_number%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,

Line 35: source_id_int_1 xla_transaction_entities.source_id_int_1%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,

Line 36: source_id_int_2 xla_transaction_entities.source_id_int_2%TYPE,

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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,

Line 37: source_id_int_3 xla_transaction_entities.source_id_int_3%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,

Line 38: source_id_int_4 xla_transaction_entities.source_id_int_4%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,

Line 39: source_id_char_1 xla_transaction_entities.source_id_char_1%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,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,
43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE

Line 40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,

36: source_id_int_2 xla_transaction_entities.source_id_int_2%TYPE,
37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,
43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE
44: );

Line 41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,

37: source_id_int_3 xla_transaction_entities.source_id_int_3%TYPE,
38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,
43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE
44: );
45:

Line 42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,

38: source_id_int_4 xla_transaction_entities.source_id_int_4%TYPE,
39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,
43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE
44: );
45:
46: TYPE events_tab IS TABLE OF events_rec INDEX BY BINARY_INTEGER;

Line 43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE

39: source_id_char_1 xla_transaction_entities.source_id_char_1%TYPE,
40: source_id_char_2 xla_transaction_entities.source_id_char_2%TYPE,
41: source_id_char_3 xla_transaction_entities.source_id_char_3%TYPE,
42: source_id_char_4 xla_transaction_entities.source_id_char_4%TYPE,
43: legal_entity_id xla_transaction_entities.legal_entity_id%TYPE
44: );
45:
46: TYPE events_tab IS TABLE OF events_rec INDEX BY BINARY_INTEGER;
47:

Line 261: p_entity_rec IN xla_transaction_entities%ROWTYPE

257: (
258: p_errbuf OUT NOCOPY VARCHAR2,
259: p_retcode OUT NOCOPY VARCHAR2,
260: p_audit_id IN NUMBER,
261: p_entity_rec IN xla_transaction_entities%ROWTYPE
262: )
263: IS
264: l_path_name VARCHAR2(500);
265: l_string VARCHAR2(2000);

Line 399: p_entity_rec IN xla_transaction_entities%ROWTYPE,

395: p_errbuf OUT NOCOPY VARCHAR2,
396: p_retcode OUT NOCOPY VARCHAR2,
397: p_audit_id OUT NOCOPY NUMBER,
398: p_mode IN VARCHAR2,
399: p_entity_rec IN xla_transaction_entities%ROWTYPE,
400: p_gl_date IN VARCHAR2,
401: p_tar_number IN VARCHAR2,
402: p_bug_number IN VARCHAR2
403: )

Line 517: p_application_id IN xla_transaction_entities.application_id%TYPE,

513: PROCEDURE redo_xla_accounting
514: (
515: p_errbuf OUT NOCOPY VARCHAR2,
516: p_retcode OUT NOCOPY VARCHAR2,
517: p_application_id IN xla_transaction_entities.application_id%TYPE,
518: p_events_tab IN OUT NOCOPY events_tab,
519: p_tar_number IN VARCHAR2,
520: p_bug_number IN VARCHAR2,
521: p_org_id IN NUMBER,

Line 532: l_entity_rec xla_transaction_entities%ROWTYPE;

528: l_msg_data VARCHAR2(2000) ;
529: l_bc_status VARCHAR2(2000);
530: l_packet_id NUMBER;
531: l_audit_id NUMBER;
532: l_entity_rec xla_transaction_entities%ROWTYPE;
533: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
534: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;
535: l_tmp_errbuf VARCHAR2(4000);
536: l_tmp_retcode NUMBER;

Line 550: FROM xla_transaction_entities

546: IF (p_retcode = g_SUCCESS) THEN
547: BEGIN
548: SELECT *
549: INTO l_entity_rec
550: FROM xla_transaction_entities
551: WHERE entity_id = p_events_tab(1).entity_id;
552: EXCEPTION
553: WHEN NO_DATA_FOUND THEN
554: error('No Entity Found for entity id='||p_events_tab(1).entity_id);

Line 696: p_application_id IN xla_transaction_entities.application_id%TYPE,

692: p_errbuf OUT NOCOPY VARCHAR2,
693: p_retcode OUT NOCOPY VARCHAR2,
694: p_events_tab IN OUT NOCOPY events_tab,
695: p_gl_date IN VARCHAR2,
696: p_application_id IN xla_transaction_entities.application_id%TYPE,
697: p_entity_code IN xla_transaction_entities.entity_code%TYPE,
698: p_source_id_int_1 IN NUMBER DEFAULT NULL,
699: p_source_id_int_2 IN NUMBER DEFAULT NULL,
700: p_source_id_int_3 IN NUMBER DEFAULT NULL,

Line 697: p_entity_code IN xla_transaction_entities.entity_code%TYPE,

693: p_retcode OUT NOCOPY VARCHAR2,
694: p_events_tab IN OUT NOCOPY events_tab,
695: p_gl_date IN VARCHAR2,
696: p_application_id IN xla_transaction_entities.application_id%TYPE,
697: p_entity_code IN xla_transaction_entities.entity_code%TYPE,
698: p_source_id_int_1 IN NUMBER DEFAULT NULL,
699: p_source_id_int_2 IN NUMBER DEFAULT NULL,
700: p_source_id_int_3 IN NUMBER DEFAULT NULL,
701: p_source_id_int_4 IN NUMBER DEFAULT NULL,

Line 734: l_entity_rec xla_transaction_entities%ROWTYPE;

730: l_new_event_id INTEGER;
731: l_new_entity_id INTEGER;
732: l_valuation_method VARCHAR2(30);
733: l_audit_id NUMBER;
734: l_entity_rec xla_transaction_entities%ROWTYPE;
735: l_tmp_errbuf VARCHAR2(4000);
736: l_tmp_retcode NUMBER;
737: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
738: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;

Line 766: FROM xla_transaction_entities t

762: IF (p_retcode = g_SUCCESS) THEN
763: BEGIN
764: SELECT *
765: INTO l_entity_rec
766: FROM xla_transaction_entities t
767: WHERE application_id = p_application_id
768: AND entity_code = p_entity_code
769: AND NVL(source_id_int_1, -1) = NVL(p_source_id_int_1, -1)
770: AND NVL(source_id_int_2, -1) = NVL(p_source_id_int_2, -1)

Line 843: xla_transaction_entities ent

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
847: and e.entity_id = ent.entity_id

Line 1092: l_application_id xla_transaction_entities.application_id%TYPE;

1088: p_mode in varchar2 default 'B'
1089: )
1090: IS
1091: l_path_name VARCHAR2(500);
1092: l_application_id xla_transaction_entities.application_id%TYPE;
1093: l_entity_code xla_transaction_entities.entity_code%TYPE;
1094: l_events_tab events_tab;
1095: l_event_check number(15);
1096: BEGIN

Line 1093: l_entity_code xla_transaction_entities.entity_code%TYPE;

1089: )
1090: IS
1091: l_path_name VARCHAR2(500);
1092: l_application_id xla_transaction_entities.application_id%TYPE;
1093: l_entity_code xla_transaction_entities.entity_code%TYPE;
1094: l_events_tab events_tab;
1095: l_event_check number(15);
1096: BEGIN
1097: p_retcode := g_SUCCESS;

Line 1140: xla_transaction_entities ent

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
1144: and e.entity_id = ent.entity_id

Line 1157: xla_transaction_entities ent,

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

Line 1407: l_application_id xla_transaction_entities.application_id%TYPE;

1403: p_bug_number IN VARCHAR2
1404: )
1405: IS
1406: l_path_name VARCHAR2(500);
1407: l_application_id xla_transaction_entities.application_id%TYPE;
1408: l_entity_code xla_transaction_entities.entity_code%TYPE;
1409: l_events_tab events_tab;
1410: BEGIN
1411: p_retcode := g_SUCCESS;

Line 1408: l_entity_code xla_transaction_entities.entity_code%TYPE;

1404: )
1405: IS
1406: l_path_name VARCHAR2(500);
1407: l_application_id xla_transaction_entities.application_id%TYPE;
1408: l_entity_code xla_transaction_entities.entity_code%TYPE;
1409: l_events_tab events_tab;
1410: BEGIN
1411: p_retcode := g_SUCCESS;
1412: p_errbuf := NULL;

Line 1624: FROM xla_transaction_entities t,

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