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.XLA_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 118: FROM xla_prod_acct_headers xpa

114: ,xpa.product_rule_type_code
115: ,xpa.product_rule_code
116: , xpa.validation_status_code
117: , xpa.locking_status_flag
118: FROM xla_prod_acct_headers xpa
119: WHERE xpa.application_id = p_application_id
120: AND xpa.event_class_code = p_event_class_code
121: AND EXISTS (SELECT 'x'
122: FROM xla_aad_line_defn_assgns xal

Line 197: UPDATE xla_prod_acct_headers xpa

193: AND xld.event_type_code = xja.event_type_code
194: AND xld.line_definition_owner_code = xja.line_definition_owner_code
195: AND xld.line_definition_code = xja.line_definition_code);
196:
197: UPDATE xla_prod_acct_headers xpa
198: SET validation_status_code = 'N'
199: WHERE xpa.application_id = p_application_id
200: AND xpa.event_class_code = p_event_class_code
201: AND xpa.validation_status_code <> 'N'

Line 306: FROM xla_prod_acct_headers xpa

302: ,xpa.product_rule_type_code
303: ,xpa.product_rule_code
304: , xpa.validation_status_code
305: , xpa.locking_status_flag
306: FROM xla_prod_acct_headers xpa
307: WHERE xpa.application_id = p_application_id
308: AND xpa.event_class_code = p_event_class_code
309: AND xpa.accounting_required_flag = 'Y'
310: AND EXISTS (SELECT 'x'

Line 378: FROM xla_prod_acct_headers xpa

374: WHERE xld.application_id = p_application_id
375: AND xld.event_class_code = p_event_class_code
376: AND xld.validation_status_code <> 'N'
377: AND EXISTS (SELECT 'x'
378: FROM xla_prod_acct_headers xpa
379: , xla_aad_line_defn_assgns xal
380: , xla_line_defn_jlt_assgns xja
381: WHERE xld.application_id = xja.application_id
382: AND xld.amb_context_code = xja.amb_context_code

Line 401: UPDATE xla_prod_acct_headers xpa

397: AND xal.product_rule_type_code = xpa.product_rule_type_code
398: AND xal.product_rule_code = xpa.product_rule_code
399: AND xpa.accounting_required_flag = 'Y');
400:
401: UPDATE xla_prod_acct_headers xpa
402: SET validation_status_code = 'N'
403: WHERE xpa.application_id = p_application_id
404: AND xpa.event_class_code = p_event_class_code
405: AND xpa.accounting_required_flag = 'Y'

Line 428: FROM xla_prod_acct_headers xpa

424: SET compile_status_code = 'N'
425: WHERE xpr.application_id = p_application_id
426: AND xpr.compile_status_code <> 'N'
427: AND EXISTS (SELECT 'x'
428: FROM xla_prod_acct_headers xpa
429: , xla_aad_line_defn_assgns xal
430: , xla_line_defn_jlt_assgns xja
431: WHERE xja.application_id = xal.application_id
432: AND xja.amb_context_code = xal.amb_context_code

Line 520: FROM xla_prod_acct_headers xpa

516: ,xpa.product_rule_type_code
517: ,xpa.product_rule_code
518: , xpa.validation_status_code
519: , xpa.locking_status_flag
520: FROM xla_prod_acct_headers xpa
521: WHERE xpa.application_id = p_application_id
522: AND xpa.event_class_code = p_event_class_code
523: AND EXISTS (SELECT 'x'
524: FROM xla_aad_line_defn_assgns xal

Line 620: UPDATE xla_prod_acct_headers xpa

616: AND xld.event_type_code = xpa.event_type_code
617: AND xld.line_definition_owner_code = xpa.line_definition_owner_code
618: AND xld.line_definition_code = xpa.line_definition_code);
619:
620: UPDATE xla_prod_acct_headers xpa
621: SET validation_status_code = 'N'
622: WHERE xpa.application_id = p_application_id
623: AND xpa.event_class_code = p_event_class_code
624: AND xpa.validation_status_code <> 'N'

Line 746: FROM xla_prod_acct_headers xpa

742: ,xpa.product_rule_type_code
743: ,xpa.product_rule_code
744: , xpa.validation_status_code
745: , xpa.locking_status_flag
746: FROM xla_prod_acct_headers xpa
747: , xla_aad_hdr_acct_attrs xah
748: WHERE xpa.application_id = xah.application_id
749: AND xpa.amb_context_code = xah.amb_context_code
750: AND xpa.event_class_code = xah.event_class_code

Line 800: UPDATE xla_prod_acct_headers xpa

796: END LOOP;
797:
798: IF (l_return) THEN
799:
800: UPDATE xla_prod_acct_headers xpa
801: SET validation_status_code = 'N'
802: WHERE xpa.accounting_required_flag = 'Y'
803: AND EXISTS (SELECT 'x'
804: FROM xla_aad_hdr_acct_attrs xah

Line 817: FROM xla_prod_acct_headers xpa

813: UPDATE xla_product_rules_b xpr
814: SET compile_status_code = 'N'
815: WHERE xpr.compile_status_code <> 'N'
816: AND EXISTS (SELECT 'x'
817: FROM xla_prod_acct_headers xpa
818: , xla_aad_hdr_acct_attrs xah
819: WHERE xpa.application_id = xah.application_id
820: AND xpa.amb_context_code = xah.amb_context_code
821: AND xpa.event_class_code = xah.event_class_code

Line 907: FROM xla_prod_acct_headers xpa

903: ,xpa.product_rule_type_code
904: ,xpa.product_rule_code
905: , xpa.validation_status_code
906: , xpa.locking_status_flag
907: FROM xla_prod_acct_headers xpa
908: WHERE xpa.application_id = p_application_id
909: AND xpa.event_class_code = p_event_class_code
910: AND EXISTS (SELECT 'x'
911: FROM xla_aad_line_defn_assgns xal

Line 1014: UPDATE xla_prod_acct_headers xpa

1010: AND xld.event_type_code = xja.event_type_code
1011: AND xld.line_definition_owner_code = xja.line_definition_owner_code
1012: AND xld.line_definition_code = xja.line_definition_code);
1013:
1014: UPDATE xla_prod_acct_headers xpa
1015: SET validation_status_code = 'N'
1016: WHERE xpa.application_id = p_application_id
1017: AND xpa.event_class_code = p_event_class_code
1018: AND xpa.validation_status_code <> 'N'

Line 1150: FROM xla_prod_acct_headers xpa

1146: ,xpa.product_rule_type_code
1147: ,xpa.product_rule_code
1148: , xpa.validation_status_code
1149: , xpa.locking_status_flag
1150: FROM xla_prod_acct_headers xpa
1151: WHERE xpa.application_id = p_application_id
1152: AND xpa.event_class_code = p_event_class_code
1153: AND (xpa.locking_status_flag = 'Y'
1154: OR xpa.validation_status_code NOT IN ('E', 'Y', 'N'))

Line 1216: UPDATE xla_prod_acct_headers pah

1212: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1213: trace('Updating AAD status.',C_LEVEL_STATEMENT,l_log_module);
1214: END IF;
1215:
1216: UPDATE xla_prod_acct_headers pah
1217: SET validation_status_code = 'N'
1218: WHERE pah.application_id = p_application_id
1219: AND pah.event_class_code = p_event_class_code
1220: AND pah.validation_status_code <> 'N';

Line 1281: FROM xla_prod_acct_headers xpa

1277: ,xpa.product_rule_type_code
1278: ,xpa.product_rule_code
1279: , xpa.validation_status_code
1280: , xpa.locking_status_flag
1281: FROM xla_prod_acct_headers xpa
1282: WHERE xpa.accounting_required_flag = 'Y'
1283: FOR UPDATE NOWAIT;
1284:
1285: BEGIN

Line 1327: UPDATE xla_prod_acct_headers xpa

1323: END LOOP;
1324:
1325: IF (l_return) THEN
1326:
1327: UPDATE xla_prod_acct_headers xpa
1328: SET validation_status_code = 'N'
1329: WHERE xpa.accounting_required_flag = 'Y';
1330:
1331: UPDATE xla_product_rules_b xpr

Line 1335: FROM xla_prod_acct_headers xal

1331: UPDATE xla_product_rules_b xpr
1332: SET compile_status_code = 'N'
1333: WHERE xpr.compile_status_code <> 'N'
1334: AND EXISTS (SELECT 'x'
1335: FROM xla_prod_acct_headers xal
1336: WHERE xal.application_id = xpr.application_id
1337: AND xal.amb_context_code = xpr.amb_context_code
1338: AND xal.product_rule_type_code = xpr.product_rule_type_code
1339: AND xal.product_rule_code = xpr.product_rule_code

Line 1417: FROM xla_prod_acct_headers xpa

1413: ,xpa.product_rule_type_code
1414: ,xpa.product_rule_code
1415: , xpa.validation_status_code
1416: , xpa.locking_status_flag
1417: FROM xla_prod_acct_headers xpa
1418: , xla_aad_hdr_acct_attrs xah
1419: WHERE xpa.application_id = xah.application_id
1420: AND xpa.amb_context_code = xah.amb_context_code
1421: AND xpa.product_rule_type_code = xah.product_rule_type_code

Line 1475: UPDATE xla_prod_acct_headers xpa

1471: END LOOP;
1472:
1473: IF (l_return) THEN
1474:
1475: UPDATE xla_prod_acct_headers xpa
1476: SET validation_status_code = 'N'
1477: WHERE xpa.accounting_required_flag = 'Y'
1478: AND EXISTS (SELECT 'X'
1479: FROM xla_aad_hdr_acct_attrs xah

Line 1496: FROM xla_prod_acct_headers xpa

1492: UPDATE xla_product_rules_b xpr
1493: SET compile_status_code = 'N'
1494: WHERE xpr.compile_status_code <> 'N'
1495: AND EXISTS (SELECT 'x'
1496: FROM xla_prod_acct_headers xpa
1497: , xla_aad_hdr_acct_attrs xah
1498: WHERE xpa.application_id = xpr.application_id
1499: AND xpa.amb_context_code = xpr.amb_context_code
1500: AND xpa.product_rule_type_code = xpr.product_rule_type_code

Line 2275: FROM xla_prod_acct_headers

2271: CURSOR c_class_aad
2272: IS
2273: SELECT amb_context_code, product_rule_type_code, product_rule_code,
2274: event_type_code
2275: FROM xla_prod_acct_headers
2276: WHERE application_id = p_application_id
2277: AND event_class_code = p_event_class_code;
2278:
2279: BEGIN