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_VALIDATE_PKG dependencies on FUN_RULE_OBJECTS_B

Line 523: FROM FUN_RULE_OBJECTS_B

519: IS
520: CURSOR c_exist_rules_object(p_rule_object_name IN VARCHAR2,p_application_id IN NUMBER )
521: IS
522: SELECT 'Y'
523: FROM FUN_RULE_OBJECTS_B
524: WHERE RULE_OBJECT_NAME = p_rule_object_name
525: AND APPLICATION_ID = p_application_id
526: AND ROWNUM = 1;
527: l_exist VARCHAR2(1);

Line 593: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;

589: x_return_status IN OUT NOCOPY VARCHAR2
590: ) IS
591:
592: l_dummy VARCHAR2(1);
593: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
594: l_user_rule_object_name FUN_RULE_OBJECTS_TL.USER_RULE_OBJECT_NAME%TYPE;
595: l_description FUN_RULE_OBJECTS_TL.DESCRIPTION%TYPE;
596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;

Line 596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;

592: l_dummy VARCHAR2(1);
593: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
594: l_user_rule_object_name FUN_RULE_OBJECTS_TL.USER_RULE_OBJECT_NAME%TYPE;
595: l_description FUN_RULE_OBJECTS_TL.DESCRIPTION%TYPE;
596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;
598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
599: l_default_value FUN_RULE_OBJ_ATTRIBUTES.DEFAULT_VALUE%TYPE;
600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;

Line 597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;

593: l_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
594: l_user_rule_object_name FUN_RULE_OBJECTS_TL.USER_RULE_OBJECT_NAME%TYPE;
595: l_description FUN_RULE_OBJECTS_TL.DESCRIPTION%TYPE;
596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;
598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
599: l_default_value FUN_RULE_OBJ_ATTRIBUTES.DEFAULT_VALUE%TYPE;
600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;
601: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;

Line 598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;

594: l_user_rule_object_name FUN_RULE_OBJECTS_TL.USER_RULE_OBJECT_NAME%TYPE;
595: l_description FUN_RULE_OBJECTS_TL.DESCRIPTION%TYPE;
596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;
598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
599: l_default_value FUN_RULE_OBJ_ATTRIBUTES.DEFAULT_VALUE%TYPE;
600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;
601: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
602: l_present NUMBER := 0;

Line 600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;

596: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;
598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
599: l_default_value FUN_RULE_OBJ_ATTRIBUTES.DEFAULT_VALUE%TYPE;
600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;
601: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
602: l_present NUMBER := 0;
603: l_dataType VARCHAR2(10);
604:

Line 601: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;

597: l_required_flag FUN_RULE_OBJECTS_B.REQUIRED_FLAG%TYPE;
598: l_multi_rule_result_flag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
599: l_default_value FUN_RULE_OBJ_ATTRIBUTES.DEFAULT_VALUE%TYPE;
600: l_created_by_module FUN_RULE_OBJECTS_B.CREATED_BY_MODULE%TYPE;
601: l_use_instance_flag FUN_RULE_OBJECTS_B.USE_INSTANCE_FLAG%TYPE;
602: l_present NUMBER := 0;
603: l_dataType VARCHAR2(10);
604:
605: l_return_status VARCHAR2(1);

Line 626: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJ_ATTRIBUTES A

622: l_required_flag,
623: l_default_value,
624: l_created_by_module,
625: l_use_instance_flag
626: FROM FUN_RULE_OBJECTS_B B, FUN_RULE_OBJ_ATTRIBUTES A
627: WHERE B.ROWID = p_rowid
628: AND B.RULE_OBJECT_ID = A.RULE_OBJECT_ID;
629: END IF;
630:

Line 643: FROM FUN_RULE_OBJECTS_B

639: p_rule_objects_rec.org_id IS NULL AND
640: p_rule_objects_rec.parent_rule_object_id IS NULL) THEN
641: SELECT COUNT(1)
642: INTO l_present
643: FROM FUN_RULE_OBJECTS_B
644: WHERE RULE_OBJECT_NAME = p_rule_objects_rec.rule_object_name
645: AND APPLICATION_ID = p_rule_objects_rec.application_id;
646: ELSE
647: SELECT COUNT(1)

Line 649: FROM FUN_RULE_OBJECTS_B

645: AND APPLICATION_ID = p_rule_objects_rec.application_id;
646: ELSE
647: SELECT COUNT(1)
648: INTO l_present
649: FROM FUN_RULE_OBJECTS_B
650: WHERE RULE_OBJECT_NAME = p_rule_objects_rec.rule_object_name
651: AND APPLICATION_ID = p_rule_objects_rec.application_id
652: AND
653: ( (INSTANCE_LABEL IS NULL AND p_rule_objects_rec.instance_label IS NULL) OR

Line 929: FROM FUN_RULE_OBJECTS_B

925: IF (p_create_update_flag = 'C') THEN
926: IF (p_rule_object_instance_rec.instance_label IS NOT NULL) THEN
927: SELECT COUNT(1)
928: INTO l_present
929: FROM FUN_RULE_OBJECTS_B
930: WHERE RULE_OBJECT_NAME = p_rule_object_instance_rec.rule_object_name
931: AND APPLICATION_ID = p_rule_object_instance_rec.application_id
932: AND
933: ( (INSTANCE_LABEL IS NULL AND p_rule_object_instance_rec.instance_label IS NULL) OR

Line 1052: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;

1048: l_description FUN_RULE_CRIT_PARAMS_TL.DESCRIPTION%TYPE;
1049: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
1050: l_created_by_module FUN_RULE_CRIT_PARAMS_B.CREATED_BY_MODULE%TYPE;
1051: l_return_status VARCHAR2(1);
1052: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1053:
1054: BEGIN
1055:
1056: -- select columns needed to be checked from table during update

Line 1073: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_rule_crit_params_rec.rule_object_id;

1069: -- Validate if a valid rule object id is passed or not
1070:
1071: BEGIN
1072: SELECT RULE_OBJECT_ID INTO l_rule_object_id
1073: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_rule_crit_params_rec.rule_object_id;
1074: EXCEPTION
1075: WHEN NO_DATA_FOUND THEN
1076: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');
1077: fnd_msg_pub.add;

Line 1296: FROM FUN_RULE_OBJECTS_B

1292: THEN
1293: BEGIN
1294: SELECT 'Y'
1295: INTO l_dummy
1296: FROM FUN_RULE_OBJECTS_B
1297: WHERE RULE_OBJECT_ID = p_rule_details_rec.rule_object_id;
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_RULE');