APPS.AMS_ACCESS_PVT dependencies on JTF_PLSQL_API

Line 1008: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1004:
1005: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
1006: END IF;
1007:
1008: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1009: check_access_items(
1010: p_access_rec => p_access_rec,
1011: p_validation_mode => JTF_PLSQL_API.g_update,
1012: x_return_status => l_return_status

Line 1011: p_validation_mode => JTF_PLSQL_API.g_update,

1007:
1008: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1009: check_access_items(
1010: p_access_rec => p_access_rec,
1011: p_validation_mode => JTF_PLSQL_API.g_update,
1012: x_return_status => l_return_status
1013: );
1014:
1015: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1524:
1525: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1526: END IF;
1527:
1528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1529: check_access_items(
1530: p_access_rec => p_access_rec,
1531: p_validation_mode => JTF_PLSQL_API.g_create,
1532: x_return_status => l_return_status

Line 1531: p_validation_mode => JTF_PLSQL_API.g_create,

1527:
1528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1529: check_access_items(
1530: p_access_rec => p_access_rec,
1531: p_validation_mode => JTF_PLSQL_API.g_create,
1532: x_return_status => l_return_status
1533: );
1534:
1535: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

2157: -- 10/12/99 abhola Create.
2158: ---------------------------------------------------------------------
2159: PROCEDURE check_Access_uk_items(
2160: p_Access_rec IN Access_rec_type,
2161: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2162: x_return_status OUT NOCOPY VARCHAR2
2163: )
2164: IS
2165: l_valid_flag VARCHAR2(1);

Line 2173: IF p_validation_mode = JTF_PLSQL_API.g_create

2169:
2170: -- For create_Access, when Access_id is passed in, we need to
2171: -- check if this Access_id is unique.
2172: --
2173: IF p_validation_mode = JTF_PLSQL_API.g_create
2174: AND p_Access_rec.activity_access_id IS NOT NULL
2175: THEN
2176: IF AMS_Utility_PVT.check_uniqueness(
2177: 'ams_act_access',

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

2398: -- 10/12/99 abhola Create.
2399: ---------------------------------------------------------------------
2400: PROCEDURE check_Access_items(
2401: p_access_rec IN Access_rec_type,
2402: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2403: x_return_status OUT NOCOPY VARCHAR2
2404: )
2405: IS
2406: -- cursor added by julou 29-nov-2001 ref. bug 2117645

Line 2521: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN

2517: RETURN;
2518: END IF;
2519: -- addee by julou 29-nov-2001 ref. bug 2117645
2520: /*
2521: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
2522: OPEN c_user_exist;
2523: FETCH c_user_exist INTO l_user_exist;
2524: CLOSE c_user_exist;
2525: