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

Line 108: ,xla_prod_acct_headers xpa

104: , xpa.locking_status_flag
105: , xpa.validation_status_code
106: FROM xla_line_defn_ac_assgns xld
107: ,xla_aad_line_defn_assgns xal
108: ,xla_prod_acct_headers xpa
109: WHERE xpa.application_id = xal.application_id
110: AND xpa.amb_context_code = xal.amb_context_code
111: AND xpa.product_rule_type_code = xal.product_rule_type_code
112: AND xpa.product_rule_code = xal.product_rule_code

Line 136: ,xla_prod_acct_headers xpa

132: , xpa.product_rule_code
133: , xpa.locking_status_flag
134: , xpa.validation_status_code
135: FROM xla_aad_header_ac_assgns xah
136: ,xla_prod_acct_headers xpa
137: WHERE xpa.application_id = xah.application_id
138: AND xpa.amb_context_code = xah.amb_context_code
139: AND xpa.product_rule_type_code = xah.product_rule_type_code
140: AND xpa.product_rule_code = xah.product_rule_code

Line 152: ,xla_prod_acct_headers xpa

148: CURSOR c_update_aads IS
149: SELECT xpa.application_id, xpa.event_class_code,
150: xpa.product_rule_type_code, xpa.product_rule_code
151: FROM xla_aad_header_ac_assgns xah
152: ,xla_prod_acct_headers xpa
153: WHERE xpa.application_id = xah.application_id
154: AND xpa.amb_context_code = xah.amb_context_code
155: AND xpa.product_rule_type_code = xah.product_rule_type_code
156: AND xpa.product_rule_code = xah.product_rule_code

Line 165: FROM xla_prod_acct_headers xpa

161: AND xah.analytical_criterion_code = p_analytical_criterion_code
162: UNION
163: SELECT xpa.application_id, xpa.event_class_code,
164: xpa.product_rule_type_code, xpa.product_rule_code
165: FROM xla_prod_acct_headers xpa
166: ,xla_aad_line_defn_assgns xal
167: ,xla_line_defn_ac_assgns xac
168: WHERE xpa.application_id = xal.application_id
169: AND xpa.amb_context_code = xal.amb_context_code

Line 329: UPDATE xla_prod_acct_headers

325: AND (compile_status_code <> 'N' OR
326: updated_flag <> 'Y');
327:
328: FORALL i IN 1..l_event_class_codes.LAST
329: UPDATE xla_prod_acct_headers
330: SET validation_status_code = 'N'
331: , last_update_date = sysdate
332: , last_updated_by = xla_environment_pkg.g_usr_id
333: , last_update_login = xla_environment_pkg.g_login_id