APPS.XLA_PRODUCT_RULES_PKG dependencies on XLA_PRODUCT_RULES_B

Line 1059: FROM xla_product_rules_b

1055:
1056: CURSOR c_prod_rules
1057: IS
1058: SELECT 'x'
1059: FROM xla_product_rules_b
1060: WHERE application_id = p_application_id
1061: AND amb_context_code = p_amb_context_code
1062: AND product_rule_type_code = p_product_rule_type_code
1063: AND product_rule_code = p_product_rule_code

Line 1080: UPDATE xla_product_rules_b

1076: OPEN c_prod_rules;
1077: FETCH c_prod_rules INTO l_exist;
1078: IF c_prod_rules%found then
1079:
1080: UPDATE xla_product_rules_b
1081: SET compile_status_code = 'N'
1082: WHERE current of c_prod_rules;
1083:
1084: l_return := TRUE;

Line 1128: FROM xla_product_rules_b

1124:
1125: CURSOR c_prod_rules
1126: IS
1127: SELECT 'x'
1128: FROM xla_product_rules_b
1129: WHERE application_id = p_application_id
1130: AND amb_context_code = p_amb_context_code
1131: AND product_rule_type_code = p_product_rule_type_code
1132: AND product_rule_code = p_product_rule_code

Line 1148: UPDATE xla_product_rules_b

1144: FETCH c_prod_rules
1145: INTO l_exist;
1146: IF c_prod_rules%found then
1147:
1148: UPDATE xla_product_rules_b
1149: SET compile_status_code = p_status
1150: WHERE current of c_prod_rules;
1151:
1152: l_return := TRUE;

Line 1559: UPDATE xla_product_rules_b xpr

1555: SET validation_status_code = 'N'
1556: WHERE xpa.application_id = p_application_id
1557: AND xpa.validation_status_code <> 'N';
1558:
1559: UPDATE xla_product_rules_b xpr
1560: SET compile_status_code = 'N'
1561: WHERE xpr.application_id = p_application_id
1562: AND xpr.compile_status_code <> 'N';
1563: