DBA Data[Home] [Help]

APPS.FUN_RULE_CRIT_PARAMS_PUB dependencies on FUN_RULE_OBJECTS_B

Line 160: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_to_rule_object_id;

156: -- Validate if p_to_rule_object_id exists or not
157:
158: BEGIN
159: SELECT RULE_OBJECT_ID INTO l_rule_object_id
160: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_to_rule_object_id;
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');
164: fnd_msg_pub.add;

Line 301: FROM FUN_RULE_OBJECTS_B

297: -- Validate for Rule Object Instance, never ever update the criteria parameters for a rule object instance.
298:
299: BEGIN
300: SELECT 'Y' INTO l_dummy
301: FROM FUN_RULE_OBJECTS_B
302: WHERE RULE_OBJECT_ID = p_rule_crit_param_rec.rule_object_id
303: AND INSTANCE_LABEL IS NULL AND ORG_ID IS NULL;
304:
305: EXCEPTION WHEN NO_DATA_FOUND THEN