APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 12528: ,xla_prod_acct_headers xpa

12524: IS
12525: SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
12526: ,xpa.locking_status_flag
12527: FROM xla_aad_line_defn_assgns xal
12528: ,xla_prod_acct_headers xpa
12529: WHERE xpa.application_id = xal.application_id
12530: AND xpa.amb_context_code = xal.amb_context_code
12531: AND xpa.product_rule_type_code = xal.product_rule_type_code
12532: AND xpa.product_rule_code = xal.product_rule_code

Line 12656: ,xla_prod_acct_headers xpa

12652: IS
12653: SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
12654: ,xpa.locking_status_flag
12655: FROM xla_aad_line_defn_assgns xal
12656: ,xla_prod_acct_headers xpa
12657: WHERE xpa.application_id = xal.application_id
12658: AND xpa.amb_context_code = xal.amb_context_code
12659: AND xpa.product_rule_type_code = xal.product_rule_type_code
12660: AND xpa.product_rule_code = xal.product_rule_code

Line 12956: ,xla_prod_acct_headers xpa

12952: ,xpa.product_rule_code
12953: ,xpa.locking_status_flag
12954: ,xpa.validation_status_code
12955: FROM xla_aad_line_defn_assgns xal
12956: ,xla_prod_acct_headers xpa
12957: WHERE xpa.application_id = xal.application_id
12958: AND xpa.amb_context_code = xal.amb_context_code
12959: AND xpa.product_rule_type_code = xal.product_rule_type_code
12960: AND xpa.product_rule_code = xal.product_rule_code

Line 12976: ,xla_prod_acct_headers xpa

12972: SELECT xal.event_class_code
12973: , xal.product_rule_type_code
12974: , xal.product_rule_code
12975: FROM xla_aad_line_defn_assgns xal
12976: ,xla_prod_acct_headers xpa
12977: WHERE xpa.application_id = xal.application_id
12978: AND xpa.amb_context_code = xal.amb_context_code
12979: AND xpa.product_rule_type_code = xal.product_rule_type_code
12980: AND xpa.product_rule_code = xal.product_rule_code

Line 13098: UPDATE xla_prod_acct_headers xpa

13094: p_level => C_LEVEL_EVENT);
13095: END IF;
13096:
13097: FORALL i IN 1..l_event_class_codes.LAST
13098: UPDATE xla_prod_acct_headers xpa
13099: SET validation_status_code = 'N'
13100: , last_update_date = sysdate
13101: , last_updated_by = xla_environment_pkg.g_usr_id
13102: , last_update_login = xla_environment_pkg.g_login_id

Line 13111: trace(p_msg => '# row updated in xla_prod_acct_headers = '||SQL%ROWCOUNT,

13107: AND xpa.product_rule_code = l_product_rule_codes(i)
13108: AND xpa.validation_status_code <> 'N';
13109:
13110: IF (C_LEVEL_EVENT >= g_log_level) THEN
13111: trace(p_msg => '# row updated in xla_prod_acct_headers = '||SQL%ROWCOUNT,
13112: p_module => l_log_module,
13113: p_level => C_LEVEL_EVENT);
13114: END IF;
13115: