APPS.PV_TAP_ACCESS_TERRS_PVT dependencies on JTF_PLSQL_API

Line 139: p_validation_mode => JTF_PLSQL_API.g_create,

135: Validate_Tap_Access_Terrs(
136: p_api_version_number => 1.0,
137: p_init_msg_list => FND_API.G_FALSE,
138: p_validation_level => p_validation_level,
139: p_validation_mode => JTF_PLSQL_API.g_create,
140: p_tap_access_terrs_rec => p_tap_access_terrs_rec ,
141: x_return_status => x_return_status,
142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data);

Line 402: p_validation_mode => JTF_PLSQL_API.g_update,

398: Validate_Tap_Access_Terrs(
399: p_api_version_number => 1.0,
400: p_init_msg_list => FND_API.G_FALSE,
401: p_validation_level => p_validation_level,
402: p_validation_mode => JTF_PLSQL_API.g_update,
403: p_tap_access_terrs_rec => p_tap_access_terrs_rec,
404: x_return_status => x_return_status,
405: x_msg_count => x_msg_count,
406: x_msg_data => x_msg_data);

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

836: End Lock_Tap_Access_Terrs;
837:
838: PROCEDURE Chk_Terr_Access_Uk_Items(
839: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
840: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
841: x_return_status OUT NOCOPY VARCHAR2)
842: IS
843: l_valid_flag VARCHAR2(1):= 'N';
844: CURSOR l_Chk_Terr_Access_Uk_csr(cv_partner_access_id NUMBER,

Line 853: IF p_validation_mode = JTF_PLSQL_API.g_create AND

849: AND terr_id = cv_terr_id;
850:
851: BEGIN
852: x_return_status := FND_API.g_ret_sts_success;
853: IF p_validation_mode = JTF_PLSQL_API.g_create AND
854: p_tap_access_terrs_rec.partner_access_id IS NOT NULL AND
855: p_tap_access_terrs_rec.terr_id IS NOT NULL
856: THEN
857: OPEN l_Chk_Terr_Access_Uk_csr(p_tap_access_terrs_rec.partner_access_id,

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

869: END Chk_Terr_Access_Uk_Items;
870:
871: PROCEDURE Chk_Terr_Access_Req_Items(
872: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
873: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
874: x_return_status OUT NOCOPY VARCHAR2
875: )
876: IS
877: BEGIN

Line 880: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

876: IS
877: BEGIN
878: x_return_status := FND_API.g_ret_sts_success;
879:
880: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
881:
882: -- Check for required paramter PARTNER_ACCESS_ID.
883: IF p_tap_access_terrs_rec.partner_access_id = FND_API.G_MISS_NUM OR p_tap_access_terrs_rec.partner_access_id IS NULL THEN
884: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );

Line 1153: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1149: -- Initialize API return status to SUCCESS
1150: x_return_status := FND_API.G_RET_STS_SUCCESS;
1151:
1152:
1153: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1154: Chk_Tap_Access_Terrs_Items(
1155: p_tap_access_terrs_rec => p_tap_access_terrs_rec,
1156: p_validation_mode => p_validation_mode,
1157: x_return_status => x_return_status

Line 1167: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: END IF;
1166:
1167: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1168: Default_Territory_Access_Items(
1169: p_tap_access_terrs_rec => p_tap_access_terrs_rec ,
1170: x_tap_access_terrs_rec => l_tap_access_terrs_rec) ;
1171: END IF ;

Line 1178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1174: p_tap_access_terrs_rec => l_tap_access_terrs_rec,
1175: x_complete_rec => l_tap_access_terrs_rec
1176: );
1177:
1178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1179: Validate_Tap_Access_Terrs_Rec(
1180: p_api_version_number => 1.0,
1181: p_init_msg_list => FND_API.G_FALSE,
1182: x_return_status => x_return_status,