APPS.OZF_FUNDTHRESHOLD_PVT dependencies on OZF_THRESHOLDS_ALL_B

Line 199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B

195: FROM dual;
196:
197: CURSOR c_id_exists (l_id IN NUMBER) IS
198: SELECT 1 FROM dual
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B
200: WHERE THRESHOLD_ID = l_id);
201:
202: BEGIN
203: -- Standard Start of API savepoint

Line 443: FROM OZF_THRESHOLDS_ALL_B

439: IS
440:
441: CURSOR c_get_threshold(threshold_id NUMBER) IS
442: SELECT *
443: FROM OZF_THRESHOLDS_ALL_B
444: WHERE THRESHOLD_ID = threshold_id
445: AND object_version_number = p_threshold_rec.object_version_number;
446: -- Hint: Developer need to provide Where clause
447:

Line 581: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Update_Row)

577: IF G_DEBUG THEN
578: OZF_UTILITY_PVT.debug_message('Private API: Calling update table handler');
579: END IF;
580:
581: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Update_Row)
582: OZF_FUNDTHRESHOLDS_ALL_B_PKG.Update_Row(
583: p_threshold_id => l_threshold_rec.threshold_id,
584: p_last_update_date => SYSDATE,
585: p_last_updated_by => NVL(fnd_global.user_id, -1),

Line 741: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Delete_Row)

737: IF G_DEBUG THEN
738: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
739: END IF;
740:
741: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Delete_Row)
742: OZF_FUNDTHRESHOLDS_ALL_B_PKG.Delete_Row(
743: p_THRESHOLD_ID => p_THRESHOLD_ID);
744: --
745: -- End of API body

Line 829: FROM OZF_THRESHOLDS_ALL_B

825: l_THRESHOLD_ID NUMBER;
826:
827: CURSOR c_Threshold IS
828: SELECT THRESHOLD_ID
829: FROM OZF_THRESHOLDS_ALL_B
830: WHERE THRESHOLD_ID = p_THRESHOLD_ID
831: AND object_version_number = p_object_version
832: FOR UPDATE NOWAIT;
833:

Line 942: 'OZF_THRESHOLDS_ALL_B',

938: BEGIN
939: x_return_status := FND_API.g_ret_sts_success;
940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
941: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
942: 'OZF_THRESHOLDS_ALL_B',
943: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||''''
944: );
945: ELSE
946: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 947: 'OZF_THRESHOLDS_ALL_B',

943: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||''''
944: );
945: ELSE
946: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
947: 'OZF_THRESHOLDS_ALL_B',
948: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||
949: ''' AND THRESHOLD_ID <> ' || p_threshold_rec.THRESHOLD_ID
950: );
951: END IF;

Line 1146: FROM ozf_thresholds_all_b

1142: l_return_status VARCHAR2(1);
1143:
1144: CURSOR c_complete IS
1145: SELECT *
1146: FROM ozf_thresholds_all_b
1147: WHERE threshold_id = p_threshold_rec.threshold_id;
1148: l_threshold_rec c_complete%ROWTYPE;
1149: BEGIN
1150: x_complete_rec := p_threshold_rec;