APPS.OZF_THRESHOLD_RULE_PVT dependencies on OZF_THRESHOLD_RULES_ALL

Line 154: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLD_RULES_ALL

150: FROM dual;
151:
152: CURSOR c_id_exists (l_id IN NUMBER) IS
153: SELECT 1 FROM dual
154: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLD_RULES_ALL
155: WHERE THRESHOLD_RULE_ID = l_id);
156:
157: BEGIN
158: -- Standard Start of API savepoint

Line 420: FROM OZF_THRESHOLD_RULES_ALL

416: IS
417:
418: CURSOR c_get_threshold_rule(threshold_rule_id NUMBER) IS
419: SELECT *
420: FROM OZF_THRESHOLD_RULES_ALL
421: WHERE THRESHOLD_RULE_ID = threshold_rule_id
422: AND OBJECT_VERSION_NUMBER =p_threshold_rule_rec.object_version_number ;
423: -- Hint: Developer need to provide Where clause
424:

Line 817: FROM OZF_THRESHOLD_RULES_ALL

813: l_THRESHOLD_RULE_ID NUMBER;
814:
815: CURSOR c_Threshold_Rule IS
816: SELECT THRESHOLD_RULE_ID
817: FROM OZF_THRESHOLD_RULES_ALL
818: WHERE THRESHOLD_RULE_ID = p_THRESHOLD_RULE_ID
819: AND object_version_number = p_object_version
820: FOR UPDATE NOWAIT;
821:

Line 930: 'OZF_THRESHOLD_RULES_ALL',

926: BEGIN
927: x_return_status := FND_API.g_ret_sts_success;
928: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
929: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
930: 'OZF_THRESHOLD_RULES_ALL',
931: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||''''
932: );
933: ELSE
934: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 935: 'OZF_THRESHOLD_RULES_ALL',

931: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||''''
932: );
933: ELSE
934: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
935: 'OZF_THRESHOLD_RULES_ALL',
936: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||
937: ''' AND THRESHOLD_RULE_ID <> ' || p_threshold_rule_rec.THRESHOLD_RULE_ID
938: );
939: END IF;

Line 1278: FROM ozf_threshold_rules_all

1274: l_return_status VARCHAR2(1);
1275:
1276: CURSOR c_complete IS
1277: SELECT *
1278: FROM ozf_threshold_rules_all
1279: WHERE threshold_rule_id = p_threshold_rule_rec.threshold_rule_id;
1280: l_threshold_rule_rec c_complete%ROWTYPE;
1281: BEGIN
1282: x_complete_rec := p_threshold_rule_rec;