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: --
127: ,p_level => C_LEVEL_STATEMENT
128: ,p_module => l_log_module);
129:
130: trace
131: (p_msg => 'SQL - select from xla_product_rules_b'
132: ,p_level => C_LEVEL_STATEMENT
133: ,p_module => l_log_module);
134:
135: END IF;
137: BEGIN
138:
139: SELECT DISTINCT product_rule_hash_id
140: INTO l_HashID
141: FROM xla_product_rules_b
142: WHERE product_rule_code = p_product_rule_code
143: AND amb_context_code = p_amb_context_code
144: AND application_id = p_application_id
145: AND product_rule_type_code = p_product_rule_type_code
151: WHEN NO_DATA_FOUND THEN
152:
153: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
154: trace
155: (p_msg => 'SQL - update xla_product_rules_b'
156: ,p_level => C_LEVEL_STATEMENT
157: ,p_module => l_log_module);
158:
159: END IF;
161: -- Fix bug 4585458
162: -- When this is called by xla_cmp_hash_pkg.BuildPADName in the
163: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
164: /*
165: UPDATE xla_product_rules_b xprb
166: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
167: FROM xla_product_rules_b xpr)
168: WHERE xprb.amb_context_code = p_amb_context_code
169: AND xprb.product_rule_code = p_product_rule_code
163: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
164: /*
165: UPDATE xla_product_rules_b xprb
166: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
167: FROM xla_product_rules_b xpr)
168: WHERE xprb.amb_context_code = p_amb_context_code
169: AND xprb.product_rule_code = p_product_rule_code
170: AND xprb.application_id = p_application_id
171: AND xprb.product_rule_type_code = p_product_rule_type_code
173: ;
174: */
175: SELECT NVL(MAX(product_rule_hash_id),0) + 1
176: INTO l_HashID
177: FROM xla_product_rules_b;
178:
179: WHEN TOO_MANY_ROWS THEN
180:
181: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
327: END IF;
328:
329: SELECT product_rule_hash_id
330: INTO p_product_rule_hash_id
331: FROM xla_product_rules_b
332: WHERE product_rule_code = p_product_rule_code
333: AND product_rule_type_code = p_product_rule_type_code
334: AND application_id = p_application_id
335: AND amb_context_code = p_amb_context_code