APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on JTF_PLSQL_API

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

37:
38: -- To Check_Visit_Task_UK_Items
39: PROCEDURE Check_Visit_Task_UK_Items (
40: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
41: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
42: x_return_status OUT NOCOPY VARCHAR2
43: );
44:
45: -- To Check_Task_Items

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

44:
45: -- To Check_Task_Items
46: PROCEDURE Check_Task_Items (
47: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
48: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:
52: -- To assign Null to missing attributes of visit while creation/updation.

Line 992: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

988: (
989: p_x_task_rec => l_Task_rec
990: );
991:
992: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
993: Check_Task_Items (
994: p_task_rec => p_x_task_rec,
995: p_validation_mode => Jtf_Plsql_Api.g_update,
996: x_return_status => l_return_status

Line 995: p_validation_mode => Jtf_Plsql_Api.g_update,

991:
992: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
993: Check_Task_Items (
994: p_task_rec => p_x_task_rec,
995: p_validation_mode => Jtf_Plsql_Api.g_update,
996: x_return_status => l_return_status
997: );
998: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
999: RAISE Fnd_Api.g_exc_unexpected_error;

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

1479: --
1480: ---------------------------------------------------------------------
1481: PROCEDURE Check_Task_Items (
1482: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1483: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1484:
1485: x_return_status OUT NOCOPY VARCHAR2
1486: )
1487: IS

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

1609: --
1610: ---------------------------------------------------------------------
1611: PROCEDURE Check_Visit_Task_UK_Items (
1612: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1613: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1614: x_return_status OUT NOCOPY VARCHAR2
1615: )
1616: IS
1617: l_valid_flag VARCHAR2(1);

Line 1627: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN

1623: END IF;
1624: --
1625: -- For Task, when ID is passed in, we need to
1626: -- check if this ID is unique.
1627: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
1628: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items : = Check_Visit_Task_UK_Items Uniqueness Of ID');
1630: END IF;
1631: -- FOR CREATION