APPS.AMS_ACCESS_PVT dependencies on JTF_PLSQL_API

Line 1277: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1273: END IF;
1274:
1275:
1276:
1277: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1278: check_access_items(
1279: p_access_rec => p_access_rec,
1280: p_validation_mode => JTF_PLSQL_API.g_update,
1281: x_return_status => l_return_status

Line 1280: p_validation_mode => JTF_PLSQL_API.g_update,

1276:
1277: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1278: check_access_items(
1279: p_access_rec => p_access_rec,
1280: p_validation_mode => JTF_PLSQL_API.g_update,
1281: x_return_status => l_return_status
1282: );
1283:
1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1871: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1867:
1868: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1869: END IF;
1870:
1871: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1872: check_access_items(
1873: p_access_rec => p_access_rec,
1874: p_validation_mode => JTF_PLSQL_API.g_create,
1875: x_return_status => l_return_status

Line 1874: p_validation_mode => JTF_PLSQL_API.g_create,

1870:
1871: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1872: check_access_items(
1873: p_access_rec => p_access_rec,
1874: p_validation_mode => JTF_PLSQL_API.g_create,
1875: x_return_status => l_return_status
1876: );
1877:
1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

2500: -- 10/12/99 abhola Create.
2501: ---------------------------------------------------------------------
2502: PROCEDURE check_Access_uk_items(
2503: p_Access_rec IN Access_rec_type,
2504: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2505: x_return_status OUT NOCOPY VARCHAR2
2506: )
2507: IS
2508: l_valid_flag VARCHAR2(1);

Line 2516: IF p_validation_mode = JTF_PLSQL_API.g_create

2512:
2513: -- For create_Access, when Access_id is passed in, we need to
2514: -- check if this Access_id is unique.
2515: --
2516: IF p_validation_mode = JTF_PLSQL_API.g_create
2517: AND p_Access_rec.activity_access_id IS NOT NULL
2518: THEN
2519: IF AMS_Utility_PVT.check_uniqueness(
2520: 'ams_act_access',

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

2741: -- 10/12/99 abhola Create.
2742: ---------------------------------------------------------------------
2743: PROCEDURE check_Access_items(
2744: p_access_rec IN Access_rec_type,
2745: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2746: x_return_status OUT NOCOPY VARCHAR2
2747: )
2748: IS
2749: -- cursor added by julou 29-nov-2001 ref. bug 2117645

Line 2864: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN

2860: RETURN;
2861: END IF;
2862: -- addee by julou 29-nov-2001 ref. bug 2117645
2863: /*
2864: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
2865: OPEN c_user_exist;
2866: FETCH c_user_exist INTO l_user_exist;
2867: CLOSE c_user_exist;
2868: