APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_DETAILS

Line 1157: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB

1153: --its better to issue direct delete statement.
1154:
1155: DELETE FROM FUN_RULE_PARAM_VALUES FRPV
1156: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1157: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1158: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1159: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1160:
1161:

Line 1173: DELETE FROM FUN_RULE_DETAILS FRD

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:
1173: DELETE FROM FUN_RULE_DETAILS FRD
1174: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1175: FROM FUN_RULE_OBJECTS_B WHERE
1176: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1177: DELETE FROM FUN_RULE_CRITERIA FRC

Line 1179: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB

1175: FROM FUN_RULE_OBJECTS_B WHERE
1176: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1177: DELETE FROM FUN_RULE_CRITERIA FRC
1178: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1179: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1180: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1181: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1182:
1183: --TEST Related tables deletion starts from here

Line 1356: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB

1352: --its better to issue direct delete statement.
1353:
1354: DELETE FROM FUN_RULE_PARAM_VALUES FRPV
1355: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1356: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1357: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1358: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1359: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1360: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1392: DELETE FROM FUN_RULE_DETAILS FRD

1388: AND ( (ORG_ID IS NULL AND p_org_id IS NULL) OR
1389: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1390: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1391:
1392: DELETE FROM FUN_RULE_DETAILS FRD
1393: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1394: FROM FUN_RULE_OBJECTS_B WHERE
1395: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1396: AND APPLICATION_ID = P_APPLICATION_ID

Line 1405: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB

1401: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1402:
1403: DELETE FROM FUN_RULE_CRITERIA FRC
1404: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1405: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1406: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1407: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1408: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1409: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1848: UPDATE FUN_RULE_DETAILS

1844: );
1845:
1846: -- Move all of the original rules and test cases to this new instance.
1847: BEGIN
1848: UPDATE FUN_RULE_DETAILS
1849: SET RULE_OBJECT_ID = x_rule_object_id
1850: WHERE RULE_OBJECT_ID = p_rule_object_id;
1851: END;
1852: