DBA Data[Home] [Help]

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on JTF_PLSQL_API

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

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

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

46:
47: -- To Check_Task_Items
48: PROCEDURE Check_Task_Items (
49: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
50: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
51: x_return_status OUT NOCOPY VARCHAR2
52: );
53:
54: PROCEDURE create_mr_tasks(

Line 1453: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

1449: (
1450: p_x_task_rec => l_Task_rec
1451: );
1452:
1453: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1454: Check_Task_Items (
1455: p_task_rec => p_x_task_rec,
1456: p_validation_mode => Jtf_Plsql_Api.g_update,
1457: x_return_status => l_return_status

Line 1456: p_validation_mode => Jtf_Plsql_Api.g_update,

1452:
1453: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1454: Check_Task_Items (
1455: p_task_rec => p_x_task_rec,
1456: p_validation_mode => Jtf_Plsql_Api.g_update,
1457: x_return_status => l_return_status
1458: );
1459:
1460: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

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

1854: --
1855: ---------------------------------------------------------------------
1856: PROCEDURE Check_Task_Items (
1857: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1858: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1859:
1860: x_return_status OUT NOCOPY VARCHAR2
1861: )
1862: IS

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

1999: --
2000: ---------------------------------------------------------------------
2001: PROCEDURE Check_Visit_Task_UK_Items (
2002: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2003: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2004: x_return_status OUT NOCOPY VARCHAR2
2005: )
2006: IS
2007: l_valid_flag VARCHAR2(1);

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

2016: END IF;
2017: --
2018: -- For Task, when ID is passed in, we need to
2019: -- check if this ID is unique.
2020: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
2021: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2022: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');
2023: END IF;
2024: -- FOR CREATION