DBA Data[Home] [Help]

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 1032: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

1028: (
1029: p_x_task_rec => l_Task_rec
1030: );
1031:
1032: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1033: Check_Task_Items (
1034: p_task_rec => p_x_task_rec,
1035: p_validation_mode => Jtf_Plsql_Api.g_update,
1036: x_return_status => l_return_status

Line 1035: p_validation_mode => Jtf_Plsql_Api.g_update,

1031:
1032: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1033: Check_Task_Items (
1034: p_task_rec => p_x_task_rec,
1035: p_validation_mode => Jtf_Plsql_Api.g_update,
1036: x_return_status => l_return_status
1037: );
1038: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1039: RAISE Fnd_Api.g_exc_unexpected_error;

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

1449: --
1450: ---------------------------------------------------------------------
1451: PROCEDURE Check_Task_Items (
1452: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1453: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2
1456: )
1457: IS

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

1579: --
1580: ---------------------------------------------------------------------
1581: PROCEDURE Check_Visit_Task_UK_Items (
1582: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1583: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1584: x_return_status OUT NOCOPY VARCHAR2
1585: )
1586: IS
1587: l_valid_flag VARCHAR2(1);

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

1593: END IF;
1594: --
1595: -- For Task, when ID is passed in, we need to
1596: -- check if this ID is unique.
1597: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
1598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1599: 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');
1600: END IF;
1601: -- FOR CREATION