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_BC_XLA_PVT dependencies on XLA_TRANSACTION_ENTITIES

Line 64: p_xla_transaction_entities IN xla_transaction_entities%ROWTYPE

60: END;
61:
62: PROCEDURE psa_xla_error_cleanup
63: (
64: p_xla_transaction_entities IN xla_transaction_entities%ROWTYPE
65: )
66: IS
67: PRAGMA AUTONOMOUS_TRANSACTION;
68: l_path_name VARCHAR2(500);

Line 71: WHERE p.entity_code = p_xla_transaction_entities.entity_code

67: PRAGMA AUTONOMOUS_TRANSACTION;
68: l_path_name VARCHAR2(500);
69: BEGIN
70: DELETE psa_xla_accounting_errors p
71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)

Line 72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)

68: l_path_name VARCHAR2(500);
69: BEGIN
70: DELETE psa_xla_accounting_errors p
71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')

Line 73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)

69: BEGIN
70: DELETE psa_xla_accounting_errors p
71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')

Line 74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)

70: DELETE psa_xla_accounting_errors p
71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')

Line 75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)

71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')
79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');

Line 76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')

72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')
79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');
80: COMMIT;

Line 77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')

73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')
79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');
80: COMMIT;
81: END;

Line 78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')

74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)
75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')
79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');
80: COMMIT;
81: END;
82:

Line 79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');

75: AND NVL(p.source_id_int_4, -1) = NVL(p_xla_transaction_entities.source_id_int_4, -1)
76: AND NVL(p.source_id_char_1, ' ') = NVL(p_xla_transaction_entities.source_id_char_1, ' ')
77: AND NVL(p.source_id_char_2, ' ') = NVL(p_xla_transaction_entities.source_id_char_2, ' ')
78: AND NVL(p.source_id_char_3, ' ') = NVL(p_xla_transaction_entities.source_id_char_3, ' ')
79: AND NVL(p.source_id_char_4, ' ') = NVL(p_xla_transaction_entities.source_id_char_4, ' ');
80: COMMIT;
81: END;
82:
83: PROCEDURE psa_xla_error_cleanup

Line 90: xla_transaction_entities t,

86: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
87: BEGIN
88: FOR entity_rec IN (SELECT t.*
89: FROM xla_events e,
90: xla_transaction_entities t,
91: psa_bc_xla_events_gt p
92: WHERE p.event_id = e.event_id
93: AND e.entity_id = t.entity_id) LOOP
94: psa_xla_error_cleanup (entity_rec);

Line 203: xla_transaction_entities t,

199: t.transaction_number,
200: e.event_date,
201: t.ledger_id
202: FROM xla_events e,
203: xla_transaction_entities t,
204: psa_bc_xla_events_gt p
205: WHERE p.event_id = e.event_id
206: AND e.entity_id = t.entity_id
207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP

Line 268: xla_transaction_entities t

264: er.ae_line_num
265: FROM xla_accounting_errors er,
266: psa_bc_xla_events_gt p,
267: xla_events e,
268: xla_transaction_entities t
269: WHERE er.event_id = p.event_id
270: AND e.event_id = p.event_id
271: AND t.entity_id = e.entity_id) LOOP
272: p_error_found := 'Y';

Line 318: xla_transaction_entities t,

314: ru.name product_rule_name,
315: ru.product_rule_type_code product_rule_owner,
316: t.ledger_id
317: FROM xla_events e,
318: xla_transaction_entities t,
319: psa_bc_xla_events_gt p,
320: gl_ledgers g,
321: xla_acctg_methods_fvl m,
322: xla_acctg_method_rules_fvl r,

Line 1098: FROM xla_transaction_entities xte,

1094: cp_source_id_int_1 NUMBER,
1095: cp_source_dist_type VARCHAR2,
1096: cp_source_dist_id_num_1 NUMBER) IS
1097: SELECT '1'
1098: FROM xla_transaction_entities xte,
1099: xla_ae_headers xah,
1100: xla_distribution_links xdl,
1101: xla_events xe
1102: WHERE xte.application_id = cp_appl_id

Line 1120: FROM xla_transaction_entities xte,

1116: cp_source_dist_type VARCHAR2,
1117: cp_source_dist_id_num_1 NUMBER) IS
1118: SELECT NVL(xdl.unrounded_accounted_dr, 0), NVL(xdl.unrounded_accounted_cr, 0),
1119: xe.event_type_code
1120: FROM xla_transaction_entities xte,
1121: xla_ae_headers xah,
1122: xla_events xe,
1123: xla_distribution_links xdl
1124: WHERE xte.application_id = cp_appl_id