APPS.XLA_CMP_HASH_PKG dependencies on XLA_PRODUCT_RULES_B

Line 36: | update the xla_product_rules_b with |

32: | when looking up the hash id for the aad. |
33: | 12-AUG-2005 W.Chan bug 4549711 - Redefined the GetPADHashId |
34: | function as an non-autonomous transaction |
35: | 31-AUG-2005 W.Chan bug 4585458 - Fix GetPADHashId to not to |
36: | update the xla_product_rules_b with |
37: | product_rule_hash_id if one is not found |
38: +===========================================================================*/
39: --
40: --

Line 136: (p_msg => 'SQL - select from xla_product_rules_b'

132: ,p_level => C_LEVEL_STATEMENT
133: ,p_module => l_log_module);
134:
135: trace
136: (p_msg => 'SQL - select from xla_product_rules_b'
137: ,p_level => C_LEVEL_STATEMENT
138: ,p_module => l_log_module);
139:
140: END IF;

Line 146: FROM xla_product_rules_b

142: BEGIN
143:
144: SELECT DISTINCT product_rule_hash_id
145: INTO l_HashID
146: FROM xla_product_rules_b
147: WHERE product_rule_code = p_product_rule_code
148: AND amb_context_code = p_amb_context_code
149: AND application_id = p_application_id
150: AND product_rule_type_code = p_product_rule_type_code

Line 160: (p_msg => 'SQL - update xla_product_rules_b'

156: WHEN NO_DATA_FOUND THEN
157:
158: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
159: trace
160: (p_msg => 'SQL - update xla_product_rules_b'
161: ,p_level => C_LEVEL_STATEMENT
162: ,p_module => l_log_module);
163:
164: END IF;

Line 170: UPDATE xla_product_rules_b xprb

166: -- Fix bug 4585458
167: -- When this is called by xla_cmp_hash_pkg.BuildPADName in the
168: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
169: /*
170: UPDATE xla_product_rules_b xprb
171: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
172: FROM xla_product_rules_b xpr)
173: WHERE xprb.amb_context_code = p_amb_context_code
174: AND xprb.product_rule_code = p_product_rule_code

Line 172: FROM xla_product_rules_b xpr)

168: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
169: /*
170: UPDATE xla_product_rules_b xprb
171: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
172: FROM xla_product_rules_b xpr)
173: WHERE xprb.amb_context_code = p_amb_context_code
174: AND xprb.product_rule_code = p_product_rule_code
175: AND xprb.application_id = p_application_id
176: AND xprb.product_rule_type_code = p_product_rule_type_code

Line 184: FROM xla_product_rules_b;

180:
181: /*
182: SELECT NVL(MAX(product_rule_hash_id),0) + 1
183: INTO l_HashID
184: FROM xla_product_rules_b;
185: */
186:
187: -- Fix bug 9325005
188: -- When 2 AADs are being Validated from 2 different machines at same time, the NVL((MAX)+1)

Line 365: FROM xla_product_rules_b

361: END IF;
362:
363: SELECT product_rule_hash_id
364: INTO p_product_rule_hash_id
365: FROM xla_product_rules_b
366: WHERE product_rule_code = p_product_rule_code
367: AND product_rule_type_code = p_product_rule_type_code
368: AND application_id = p_application_id
369: AND amb_context_code = p_amb_context_code