APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_CRIT_PARAMS_B

Line 261: in FUN_RULE_CRIT_PARAMS_B/_TL table, we need to

257: END;
258:
259: /**************************************************************************************
260: Since the newly created Rule Object Instance will have the same criteria parameters
261: in FUN_RULE_CRIT_PARAMS_B/_TL table, we need to
262: Create the Criteria Parameters for the Rule Object Instance with Rule_Object_id
263: as X_RULE_OBJECT_ID.
264: **************************************************************************************/
265: FUN_RULE_CRIT_PARAMS_PUB.CREATE_DUP_RULE_CRIT_PARAMS(

Line 1164: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB

1160:
1161:
1162: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP
1163: WHERE CRITERIA_PARAM_ID IN (SELECT CRITERIA_PARAM_ID
1164: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB
1165: WHERE FROB.RULE_OBJECT_ID = FRCPB.RULE_OBJECT_ID
1166: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1167:
1168: DELETE FROM FUN_RULE_CRIT_PARAMS_B FRCP

Line 1168: DELETE FROM FUN_RULE_CRIT_PARAMS_B FRCP

1164: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB
1165: WHERE FROB.RULE_OBJECT_ID = FRCPB.RULE_OBJECT_ID
1166: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1167:
1168: DELETE FROM FUN_RULE_CRIT_PARAMS_B FRCP
1169: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1170: FROM FUN_RULE_OBJECTS_B WHERE
1171: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1172:

Line 1369: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB

1365:
1366:
1367: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP
1368: WHERE CRITERIA_PARAM_ID IN (SELECT CRITERIA_PARAM_ID
1369: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB
1370: WHERE FROB.RULE_OBJECT_ID = FRCPB.RULE_OBJECT_ID
1371: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1372: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1373: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1381: DELETE FROM FUN_RULE_CRIT_PARAMS_B FRCP

1377: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1378:
1379:
1380:
1381: DELETE FROM FUN_RULE_CRIT_PARAMS_B FRCP
1382: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1383: FROM FUN_RULE_OBJECTS_B WHERE
1384: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1385: AND APPLICATION_ID = P_APPLICATION_ID

Line 1539: FROM FUN_RULE_CRIT_PARAMS_B FRCP, FUN_RULE_OBJECTS_B FROB

1535: l_dummy VARCHAR2(1);
1536: BEGIN
1537:
1538: SELECT 'Y' INTO l_dummy
1539: FROM FUN_RULE_CRIT_PARAMS_B FRCP, FUN_RULE_OBJECTS_B FROB
1540: WHERE FROB.RULE_OBJECT_ID = FRCP.RULE_OBJECT_ID
1541: AND FROB.RULE_OBJECT_NAME = p_rule_object_name
1542: AND FRCP.PARAM_NAME = p_parameter_name;
1543: