APPS.AHL_WF_MAPPING_PVT dependencies on JTF_PLSQL_API

Line 40: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

36:
37: -- Check_Wf_Mapping_UK_Items
38: PROCEDURE Check_Wf_Mapping_UK_Items (
39: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
40: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
41: x_return_status OUT NOCOPY VARCHAR2
42: );
43:
44: -- Check_Process_Name when the value is not selected from LOV's

Line 570: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

566:
567: -- replace g_miss_char/num/date with current column values
568: Complete_Wf_Mapping_Rec (p_Wf_Mapping_rec, l_Wf_Mapping_rec);
569:
570: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
571: Check_Wf_Mapping_Items (
572: p_Wf_Mapping_rec => p_Wf_Mapping_rec,
573: p_validation_mode => Jtf_Plsql_Api.g_update,
574: x_return_status => l_return_status

Line 573: p_validation_mode => Jtf_Plsql_Api.g_update,

569:
570: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
571: Check_Wf_Mapping_Items (
572: p_Wf_Mapping_rec => p_Wf_Mapping_rec,
573: p_validation_mode => Jtf_Plsql_Api.g_update,
574: x_return_status => l_return_status
575:
576: );
577: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 1023: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

1019: IF G_DEBUG='Y' THEN
1020: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
1021: END IF;
1022:
1023: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1024: Check_Wf_Mapping_Items (
1025: p_Wf_Mapping_rec => p_Wf_Mapping_rec,
1026: p_validation_mode => Jtf_Plsql_Api.g_create,
1027: x_return_status => l_return_status

Line 1026: p_validation_mode => Jtf_Plsql_Api.g_create,

1022:
1023: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1024: Check_Wf_Mapping_Items (
1025: p_Wf_Mapping_rec => p_Wf_Mapping_rec,
1026: p_validation_mode => Jtf_Plsql_Api.g_create,
1027: x_return_status => l_return_status
1028: );
1029: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1030: RAISE Fnd_Api.g_exc_unexpected_error;

Line 1088: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

1084: ---------------------------------------------------------------------
1085: PROCEDURE Check_Wf_Mapping_Items (
1086:
1087: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
1088: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1089: x_return_status OUT NOCOPY VARCHAR2
1090: )
1091: IS
1092: BEGIN

Line 1254: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

1250:
1251: -- Check_Wf_Mapping_UK_Items
1252: PROCEDURE Check_Wf_Mapping_UK_Items (
1253: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
1254: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1255: x_return_status OUT NOCOPY VARCHAR2
1256: )
1257: IS
1258: l_valid_flag VARCHAR2(1);

Line 1270: IF p_validation_mode = Jtf_Plsql_Api.g_create

1266: x_return_status := Fnd_Api.g_ret_sts_success;
1267: -- MEDIA_ID
1268: -- For Create_Wf_Mapping, when ID is passed in, we need to
1269: -- check if this ID is unique.
1270: IF p_validation_mode = Jtf_Plsql_Api.g_create
1271: AND p_Wf_Mapping_rec.WF_Mapping_ID IS NOT NULL
1272: THEN
1273: IF Ahl_Utility_Pvt.check_uniqueness(
1274: 'AHL_Wf_Mapping',

Line 1298: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

1294: END IF;
1295: CLOSE c_appl_usg;*/
1296:
1297: -- check if APPROVAL OBJECT is UNIQUE
1298: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1299: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
1300: 'AHL_Wf_Mapping',
1301: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1302: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code || '''');