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_DESCRIPTIONS_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 579: FROM xla_prod_acct_headers

575: CURSOR c_header_assign_exist
576: IS
577: SELECT application_id, amb_context_code, product_rule_type_code, product_rule_code,
578: entity_code, event_class_code
579: FROM xla_prod_acct_headers
580: WHERE application_id = p_application_id
581: AND amb_context_code = p_amb_context_code
582: AND description_type_code = p_description_type_code
583: AND description_code = p_description_code;

Line 905: FROM xla_prod_acct_headers h

901:
902: CURSOR c_frozen_header_assign_exist
903: IS
904: SELECT 'x'
905: FROM xla_prod_acct_headers h
906: WHERE application_id = p_application_id
907: AND amb_context_code = p_amb_context_code
908: AND description_type_code = p_description_type_code
909: AND description_code = p_description_code

Line 917: ,xla_prod_acct_headers xpa

913: IS
914: SELECT 'x'
915: FROM xla_line_defn_jlt_assgns xjl
916: ,xla_aad_line_defn_assgns xal
917: ,xla_prod_acct_headers xpa
918: WHERE xpa.application_id = xal.application_id
919: AND xpa.amb_context_code = xal.amb_context_code
920: AND xpa.product_rule_type_code = xal.product_rule_type_code
921: AND xpa.product_rule_code = xal.product_rule_code

Line 1060: ,xla_prod_acct_headers xpa

1056: , xpa.locking_status_flag
1057: , xpa.validation_status_code
1058: FROM xla_line_defn_jlt_assgns xjl
1059: ,xla_aad_line_defn_assgns xal
1060: ,xla_prod_acct_headers xpa
1061: WHERE xpa.application_id = xal.application_id
1062: AND xpa.amb_context_code = xal.amb_context_code
1063: AND xpa.product_rule_type_code = xal.product_rule_type_code
1064: AND xpa.product_rule_code = xal.product_rule_code

Line 1087: FROM xla_prod_acct_headers xpa

1083: , xpa.product_rule_type_code
1084: , xpa.product_rule_code
1085: , xpa.locking_status_flag
1086: , xpa.validation_status_code
1087: FROM xla_prod_acct_headers xpa
1088: WHERE xpa.application_id = p_application_id
1089: AND xpa.amb_context_code = p_amb_context_code
1090: AND xpa.description_type_code = p_description_type_code
1091: AND xpa.description_code = p_description_code

Line 1098: FROM xla_prod_acct_headers xpa

1094: CURSOR c_update_aads IS
1095: SELECT xpa.event_class_code
1096: , xpa.product_rule_type_code
1097: , xpa.product_rule_code
1098: FROM xla_prod_acct_headers xpa
1099: WHERE xpa.application_id = p_application_id
1100: AND xpa.amb_context_code = p_amb_context_code
1101: AND xpa.description_type_code = p_description_type_code
1102: AND xpa.description_code = p_description_code

Line 1107: FROM xla_prod_acct_headers xpa

1103: UNION
1104: SELECT xpa.event_class_code
1105: , xpa.product_rule_type_code
1106: , xpa.product_rule_code
1107: FROM xla_prod_acct_headers xpa
1108: ,xla_aad_line_defn_assgns xal
1109: ,xla_line_defn_jlt_assgns xjl
1110: WHERE xpa.application_id = xal.application_id
1111: AND xpa.amb_context_code = xal.amb_context_code

Line 1269: UPDATE xla_prod_acct_headers

1265: AND (compile_status_code <> 'N' OR
1266: updated_flag <> 'Y');
1267:
1268: FORALL i IN 1..l_event_class_codes.LAST
1269: UPDATE xla_prod_acct_headers
1270: SET validation_status_code = 'N'
1271: , last_update_date = sysdate
1272: , last_updated_by = xla_environment_pkg.g_usr_id
1273: , last_update_login = xla_environment_pkg.g_login_id