DBA Data[Home] [Help]

APPS.OZF_OFFER_PERFORMANCE_PVT dependencies on JTF_PLSQL_API

Line 120: p_validation_mode => JTF_PLSQL_API.g_create,

116: Validate_offer_performance(
117: p_api_version_number => 1.0,
118: p_init_msg_list => FND_API.G_FALSE,
119: p_validation_level => p_validation_level,
120: p_validation_mode => JTF_PLSQL_API.g_create,
121: p_offer_perf_rec => p_offer_perf_rec,
122: x_return_status => x_return_status,
123: x_msg_count => x_msg_count,
124: x_msg_data => x_msg_data);

Line 343: p_validation_mode => JTF_PLSQL_API.g_update,

339: Validate_offer_performance(
340: p_api_version_number => 1.0,
341: p_init_msg_list => FND_API.G_FALSE,
342: p_validation_level => p_validation_level,
343: p_validation_mode => JTF_PLSQL_API.g_update,
344: p_offer_perf_rec => p_offer_perf_rec,
345: x_return_status => x_return_status,
346: x_msg_count => x_msg_count,
347: x_msg_data => x_msg_data);

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

691:
692:
693: PROCEDURE check_offer_perf_uk_items(
694: p_offer_perf_rec IN offer_perf_rec_type,
695: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
696: x_return_status OUT NOCOPY VARCHAR2)
697: IS
698: l_valid_flag VARCHAR2(1);
699:

Line 711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);
708:
709:
710:
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
712: l_valid_flag := ozf_utility_pvt.check_uniqueness(
713: 'OZF_OFFER_PERFORMANCES',
714: ' PRODUCT_ATTRIBUTE ='||' '||p_offer_perf_rec.PRODUCT_ATTRIBUTE ||''||
715: ' AND PRODUCT_ATTR_VALUE ='||' '|| p_offer_perf_rec.PRODUCT_ATTR_VALUE||''||

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

736: END check_offer_perf_uk_items;
737:
738: PROCEDURE check_offer_perf_req_items(
739: p_offer_perf_rec IN offer_perf_rec_type,
740: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
741: x_return_status OUT NOCOPY VARCHAR2
742: )
743: IS
744: BEGIN

Line 747: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN

743: IS
744: BEGIN
745: x_return_status := FND_API.g_ret_sts_success;
746:
747: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
748: -- ELSE
749: --END IF;
750: IF p_offer_perf_rec.channel_id = -1 THEN
751: IF p_offer_perf_rec.requirement_type IS NULL OR p_offer_perf_rec.requirement_type = fnd_api.g_miss_char THEN

Line 1066: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1062: IF FND_API.to_Boolean( p_init_msg_list )
1063: THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1067: Check_offer_perf_Items(
1068: p_offer_perf_rec => p_offer_perf_rec,
1069: p_validation_mode => p_validation_mode,
1070: x_return_status => x_return_status

Line 1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1081: p_offer_perf_rec => p_offer_perf_rec,
1082: x_complete_rec => l_offer_perf_rec
1083: );
1084:
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Validate_offer_perf_Rec(
1087: p_api_version_number => 1.0,
1088: p_init_msg_list => FND_API.G_FALSE,
1089: x_return_status => x_return_status,