eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_OBJECTS_B

Line 147: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;

143:
144: l_rowid rowid:= NULL;
145: l_orig_rule_object_rec RULE_OBJECTS_REC_TYPE;
146: l_rule_object_instance_rec RULE_OBJECTS_REC_TYPE;
147: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
148:
149: x_msg_count number;
150: x_msg_data varchar2(2000);
151:

Line 244: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_NAME = p_rule_object_name

240: --of the new Rule Object Instance.
241:
242: BEGIN
243: SELECT RULE_OBJECT_ID INTO X_RULE_OBJECT_ID
244: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_NAME = p_rule_object_name
245: AND APPLICATION_ID = p_application_id
246: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
247: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))
248: AND ( (ORG_ID IS NULL AND p_org_id IS NULL) OR

Line 326: FROM FUN_RULE_OBJECTS_B

322: SELECT OBJECT_VERSION_NUMBER,
323: ROWID
324: INTO l_object_version_number,
325: l_rowid
326: FROM FUN_RULE_OBJECTS_B
327: WHERE RULE_OBJECT_ID = p_rule_object_rec.rule_object_id
328: FOR UPDATE OF rule_object_id NOWAIT;
329:
330:

Line 500: * With this API you can create a record in the FUN_RULE_OBJECTS_B ,

496: END create_rule_object;
497:
498: /**
499: * Use this routine to create a rule object instance to be used for rule partitioning.
500: * With this API you can create a record in the FUN_RULE_OBJECTS_B ,
501: * table provided the flag USE_INSTANCE_FLAG is set to 'Y'. This API will return
502: * the rule_object_id of the newly created rule object instance record.
503: *
504: * p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.

Line 549: FROM FUN_RULE_OBJECTS_B

545: BEGIN
546: --This should infact never raise exception if the code flow has reached here.
547:
548: SELECT RULE_OBJECT_ID INTO X_RULE_OBJECT_ID
549: FROM FUN_RULE_OBJECTS_B
550: WHERE RULE_OBJECT_NAME = p_rule_object_name
551: AND APPLICATION_ID = p_application_id
552: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
553: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

Line 678: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJECTS_TL TL, FUN_RULE_OBJ_ATTRIBUTES ATTR

674: B.USE_INSTANCE_FLAG,
675: B.INSTANCE_LABEL,
676: B.PARENT_RULE_OBJECT_ID,
677: B.ORG_ID
678: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJECTS_TL TL, FUN_RULE_OBJ_ATTRIBUTES ATTR
679: WHERE B.PARENT_RULE_OBJECT_ID = p_rule_object_id
680: AND B.RULE_OBJECT_ID = ATTR.RULE_OBJECT_ID
681: AND B.RULE_OBJECT_ID = TL.RULE_OBJECT_ID
682: AND TL.LANGUAGE = 'US';

Line 1123: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJECTS_TL TL, FUN_RULE_OBJ_ATTRIBUTES ATTR

1119: B.APPLICATION_ID,
1120: B.RULE_OBJECT_NAME,
1121: B.INSTANCE_LABEL,
1122: B.ORG_ID
1123: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJECTS_TL TL, FUN_RULE_OBJ_ATTRIBUTES ATTR
1124: WHERE B.PARENT_RULE_OBJECT_ID = p_rule_object_id
1125: AND B.RULE_OBJECT_ID = ATTR.RULE_OBJECT_ID
1126: AND B.RULE_OBJECT_ID = TL.RULE_OBJECT_ID
1127: AND TL.LANGUAGE = 'US';

Line 1138: SELECT RULE_OBJECT_ID INTO l_rule_object_id FROM FUN_RULE_OBJECTS_B

1134: --Store the rule_object_id first so that it will be used
1135: --to delete the instances later.
1136:
1137: BEGIN
1138: SELECT RULE_OBJECT_ID INTO l_rule_object_id FROM FUN_RULE_OBJECTS_B
1139: WHERE RULE_OBJECT_NAME = p_rule_object_name
1140: AND APPLICATION_ID = p_application_id
1141: AND INSTANCE_LABEL IS NULL
1142: AND ORG_ID IS NULL

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 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 1170: FROM FUN_RULE_OBJECTS_B WHERE

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:
1173: DELETE FROM FUN_RULE_DETAILS FRD
1174: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID

Line 1175: 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
1178: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1179: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB

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 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 1211: FROM FUN_RULE_OBJECTS_B WHERE

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:
1214: -- initialize message list if p_init_msg_list is set to TRUE.
1215: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1298: * FUN_RULE_OBJECTS_B table after checking if the USE_INSTANCE_FLAG is Y or not.

1294:
1295:
1296: /**
1297: * Use this routine to delete a rule object instance. The API deletes a record in the
1298: * FUN_RULE_OBJECTS_B table after checking if the USE_INSTANCE_FLAG is Y or not.
1299: *
1300: *
1301: * p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
1302: * p_application_id Application identifier

Line 1330: --Get the RULE_OBJECT_ID from FUN_RULE_OBJECTS_B for the Rule Instance.

1326:
1327: -- standard start of API savepoint
1328: SAVEPOINT delete_rule_object_instance;
1329:
1330: --Get the RULE_OBJECT_ID from FUN_RULE_OBJECTS_B for the Rule Instance.
1331: --Use the RULE_OBJECT_ID to delete the records.
1332:
1333: BEGIN
1334: SELECT RULE_OBJECT_ID INTO l_rule_object_id FROM FUN_RULE_OBJECTS_B

Line 1334: SELECT RULE_OBJECT_ID INTO l_rule_object_id FROM FUN_RULE_OBJECTS_B

1330: --Get the RULE_OBJECT_ID from FUN_RULE_OBJECTS_B for the Rule Instance.
1331: --Use the RULE_OBJECT_ID to delete the records.
1332:
1333: BEGIN
1334: SELECT RULE_OBJECT_ID INTO l_rule_object_id FROM FUN_RULE_OBJECTS_B
1335: WHERE RULE_OBJECT_NAME = p_rule_object_name
1336: AND APPLICATION_ID = p_application_id
1337: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
1338: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

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 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 1383: FROM FUN_RULE_OBJECTS_B WHERE

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
1386: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
1387: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

Line 1394: FROM FUN_RULE_OBJECTS_B WHERE

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
1397: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
1398: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

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 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 1472: FROM FUN_RULE_OBJECTS_B WHERE

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
1475: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
1476: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

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:

Line 1557: * FUN_RULE_OBJECTS_B table or not.

1553: * PROCEDURE rule_object_instance_exists
1554: *
1555: * DESCRIPTION
1556: * Returns Boolean value based on a Rule Object Instance exists in the
1557: * FUN_RULE_OBJECTS_B table or not.
1558: *
1559: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1560: *
1561: *

Line 1602: FROM FUN_RULE_OBJECTS_B

1598: */
1599:
1600:
1601: SELECT 'Y' INTO l_param_value
1602: FROM FUN_RULE_OBJECTS_B
1603: WHERE RULE_OBJECT_NAME = p_rule_object_name
1604: AND APPLICATION_ID = p_application_id
1605: AND ( (INSTANCE_LABEL IS NULL AND p_instance_label IS NULL) OR
1606: (INSTANCE_LABEL IS NOT NULL AND p_instance_label IS NOT NULL AND INSTANCE_LABEL = p_instance_label))

Line 1644: * FUN_RULE_OBJECTS_B table or not.

1640: * FUNCTION rule_object_instance_exists
1641: *
1642: * DESCRIPTION
1643: * Returns ('Y'/'N') value based on a Rule Object Instance exists in the
1644: * FUN_RULE_OBJECTS_B table or not.
1645: *
1646: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1647: *
1648: *

Line 1771: FROM FUN_RULE_OBJECTS_B

1767: IS
1768: CURSOR C_RULE_OBJECT_INSTANCES(p_rule_object_id NUMBER) IS
1769: SELECT APPLICATION_ID,RULE_OBJECT_NAME,
1770: RULE_OBJECT_ID, INSTANCE_LABEL, ORG_ID
1771: FROM FUN_RULE_OBJECTS_B
1772: WHERE PARENT_RULE_OBJECT_ID = p_rule_object_id;
1773:
1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;

Line 1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;

1770: RULE_OBJECT_ID, INSTANCE_LABEL, ORG_ID
1771: FROM FUN_RULE_OBJECTS_B
1772: WHERE PARENT_RULE_OBJECT_ID = p_rule_object_id;
1773:
1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;
1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;

Line 1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;

1771: FROM FUN_RULE_OBJECTS_B
1772: WHERE PARENT_RULE_OBJECT_ID = p_rule_object_id;
1773:
1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;
1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
1779:

Line 1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;

1772: WHERE PARENT_RULE_OBJECT_ID = p_rule_object_id;
1773:
1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;
1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
1779:
1780: BEGIN

Line 1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;

1773:
1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;
1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
1779:
1780: BEGIN
1781: -- standard start of API savepoint

Line 1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;

1774: x_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1775: l_application_id FUN_RULE_OBJECTS_B.APPLICATION_ID%TYPE;
1776: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
1777: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1778: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
1779:
1780: BEGIN
1781: -- standard start of API savepoint
1782: SAVEPOINT convert_use_instance;

Line 1812: FROM FUN_RULE_OBJECTS_B

1808:
1809: BEGIN
1810: SELECT USE_INSTANCE_FLAG , APPLICATION_ID, RULE_OBJECT_NAME
1811: INTO l_use_instance_flag, l_application_id, l_rule_object_name
1812: FROM FUN_RULE_OBJECTS_B
1813: WHERE RULE_OBJECT_ID = p_rule_object_id;
1814: END;
1815:
1816: IF (NVL(l_use_instance_flag,'N') = NVL(p_use_instance_flag,'N')) THEN

Line 1825: UPDATE FUN_RULE_OBJECTS_B

1821: IF (UPPER(p_use_instance_flag) = 'Y') THEN
1822:
1823: --Set USE_INSTANCE_FLAG to 'Y' for the rule object.
1824: BEGIN
1825: UPDATE FUN_RULE_OBJECTS_B
1826: SET USE_INSTANCE_FLAG ='Y'
1827: WHERE RULE_OBJECT_ID = p_rule_object_id;
1828: END;
1829:

Line 1877: FROM FUN_RULE_OBJECTS_B

1873: --Select the parent rule object id for this instance.
1874: BEGIN
1875: SELECT PARENT_RULE_OBJECT_ID
1876: INTO l_parent_rule_object_id
1877: FROM FUN_RULE_OBJECTS_B
1878: WHERE RULE_OBJECT_ID = p_rule_object_id;
1879: END;
1880:
1881: --Set USE_INSTANCE_FLAG to 'N' for the rule object

Line 1883: UPDATE FUN_RULE_OBJECTS_B

1879: END;
1880:
1881: --Set USE_INSTANCE_FLAG to 'N' for the rule object
1882: BEGIN
1883: UPDATE FUN_RULE_OBJECTS_B
1884: SET USE_INSTANCE_FLAG ='N',
1885: INSTANCE_LABEL = null,
1886: ORG_ID = null,
1887: PARENT_RULE_OBJECT_ID = null