DBA Data[Home] [Help]

APPS.AMS_ADV_FILTER_PVT dependencies on JTF_PLSQL_API

Line 137: p_validation_mode => JTF_PLSQL_API.g_create,

133: Validate_Filter_Row(
134: p_api_version_number => 1.0,
135: p_init_msg_list => FND_API.G_FALSE,
136: p_validation_level => p_validation_level,
137: p_validation_mode => JTF_PLSQL_API.g_create,
138: p_filter_rec => l_filter_rec,
139: x_return_status => x_return_status,
140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data);

Line 339: p_validation_mode => JTF_PLSQL_API.g_update,

335: -- Invoke validation procedures
336: Validate_Filter_Row( p_api_version_number => 1.0,
337: p_init_msg_list => FND_API.G_FALSE,
338: p_validation_level => p_validation_level,
339: p_validation_mode => JTF_PLSQL_API.g_update,
340: p_filter_rec => l_filter_rec,
341: x_return_status => x_return_status,
342: x_msg_count => x_msg_count,
343: x_msg_data => x_msg_data);

Line 613: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

609:
610: PROCEDURE check_filter_row_uk_items
611: (
612: p_filter_rec IN filter_rec_type,
613: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
614: x_return_status OUT NOCOPY VARCHAR2
615: )
616:
617: IS

Line 624: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

620:
621:
622: BEGIN
623: x_return_status := FND_API.g_ret_sts_success;
624: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
625: l_valid_flag := 'T';
626: -- AMS_Utility_PVT.check_uniqueness(
627: -- 'JTF_PERZ_QUERY_PARAM',
628: -- 'query_param_id = 0'

Line 650: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

646:
647: PROCEDURE check_filter_row_req_items
648: (
649: p_filter_rec IN filter_rec_type,
650: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
651: x_return_status OUT NOCOPY VARCHAR2
652: )
653:
654: IS

Line 659: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

655:
656: BEGIN
657: x_return_status := FND_API.g_ret_sts_success;
658:
659: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
660:
661: AMS_UTILITY_PVT.debug_message('Private API: Inside check_filter_row_req_items');
662:
663: IF p_filter_rec.query_id = FND_API.g_miss_num OR p_filter_rec.query_id IS NULL THEN

Line 908: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

904: THEN
905: FND_MSG_PUB.initialize;
906: END IF;
907:
908: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
909: Check_Filter_Items(
910: p_filter_rec => p_filter_rec,
911: p_validation_mode => p_validation_mode,
912: x_return_status => x_return_status

Line 927: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

923: p_filter_rec => p_filter_rec,
924: x_complete_rec => l_filter_rec
925: );
926:
927: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
928: Validate_Filter_Row_Rec
929: (
930: p_api_version_number => 1.0,
931: p_init_msg_list => FND_API.G_FALSE,