APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_TESTS

Line 1187: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1183: --TEST Related tables deletion starts from here
1184:
1185: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP
1186: WHERE TEST_ID IN (SELECT TEST_ID
1187: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1188: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1189: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1190:
1191: DELETE FROM FUN_RULE_TEST_RESULTS FRTR

Line 1193: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1189: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1190:
1191: DELETE FROM FUN_RULE_TEST_RESULTS FRTR
1192: WHERE TEST_ID IN (SELECT TEST_ID
1193: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1194: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1195: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1196:
1197: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR

Line 1199: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1195: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1196:
1197: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR
1198: WHERE TEST_ID IN (SELECT TEST_ID
1199: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1200: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1201: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1202:
1203: DELETE FROM FUN_RULE_TEST_PARAMS FRTP

Line 1205: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1201: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1202:
1203: DELETE FROM FUN_RULE_TEST_PARAMS FRTP
1204: WHERE TEST_ID IN (SELECT TEST_ID
1205: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1206: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1207: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1208:
1209: DELETE FROM FUN_RULE_TESTS FRT

Line 1209: DELETE FROM FUN_RULE_TESTS FRT

1205: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1206: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1207: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1208:
1209: DELETE FROM FUN_RULE_TESTS FRT
1210: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1211: FROM FUN_RULE_OBJECTS_B WHERE
1212: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1213:

Line 1420: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1416: --TEST Related tables deletion starts from here
1417:
1418: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP
1419: WHERE TEST_ID IN (SELECT TEST_ID
1420: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1421: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1422: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1423: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1424: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1433: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1429:
1430:
1431: DELETE FROM FUN_RULE_TEST_RESULTS FRTR
1432: WHERE TEST_ID IN (SELECT TEST_ID
1433: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1434: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1435: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1436: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1437: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1446: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1442:
1443:
1444: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR
1445: WHERE TEST_ID IN (SELECT TEST_ID
1446: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1447: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1448: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1449: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1450: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1459: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB

1455:
1456:
1457: DELETE FROM FUN_RULE_TEST_PARAMS FRTP
1458: WHERE TEST_ID IN (SELECT TEST_ID
1459: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1460: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1461: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1462: AND FROB.APPLICATION_ID = P_APPLICATION_ID
1463: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR

Line 1470: DELETE FROM FUN_RULE_TESTS FRT

1466: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1467: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1468:
1469:
1470: DELETE FROM FUN_RULE_TESTS FRT
1471: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1472: FROM FUN_RULE_OBJECTS_B WHERE
1473: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME
1474: AND APPLICATION_ID = P_APPLICATION_ID

Line 1854: UPDATE FUN_RULE_TESTS

1850: WHERE RULE_OBJECT_ID = p_rule_object_id;
1851: END;
1852:
1853: BEGIN
1854: UPDATE FUN_RULE_TESTS
1855: SET RULE_OBJECT_ID = x_rule_object_id
1856: WHERE RULE_OBJECT_ID = p_rule_object_id;
1857: END;
1858: else