APPS.AHL_VWP_VISITS_PVT dependencies on JTF_PLSQL_API

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

64:
65: -- To Check all Visit's Items
66: PROCEDURE Check_Visit_Items (
67: p_Visit_rec IN visit_rec_type,
68: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
69: x_return_status OUT NOCOPY VARCHAR2
70: );
71:
72: -- To Check all Visit's Required Items

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

77:
78: -- To Check all Visit's Unique items
79: PROCEDURE Check_Visit_UK_Items (
80: p_Visit_rec IN Visit_Rec_Type,
81: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
82: x_return_status OUT NOCOPY VARCHAR2
83: );
84:
85: -- To Create a Maintenance Visit

Line 3311: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

3307: (
3308: p_x_visit_rec => l_Visit_rec
3309: );
3310: ----------------------- Validate ----------------------
3311: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3313: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Check_Visit_Items');
3314: END IF;
3315:

Line 3318: p_validation_mode => Jtf_Plsql_Api.g_update,

3314: END IF;
3315:
3316: Check_Visit_Items (
3317: p_Visit_rec => l_visit_rec,
3318: p_validation_mode => Jtf_Plsql_Api.g_update,
3319: x_return_status => l_return_status
3320: );
3321:
3322: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 4458: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

4454: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4455: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Calling Check_Visit_Items');
4456: END IF;
4457:
4458: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
4459: Check_Visit_Items (
4460: p_Visit_rec => p_Visit_rec,
4461: p_validation_mode => Jtf_Plsql_Api.g_create,
4462: x_return_status => l_return_status

Line 4461: p_validation_mode => Jtf_Plsql_Api.g_create,

4457:
4458: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
4459: Check_Visit_Items (
4460: p_Visit_rec => p_Visit_rec,
4461: p_validation_mode => Jtf_Plsql_Api.g_create,
4462: x_return_status => l_return_status
4463: );
4464:
4465: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

4516: --
4517: ---------------------------------------------------------------------
4518: PROCEDURE Check_Visit_Items (
4519: p_Visit_rec IN Visit_Rec_Type,
4520: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
4521: x_return_status OUT NOCOPY VARCHAR2
4522: )
4523: IS
4524: BEGIN

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

4609: -- Check_Visit_UK_Items
4610: ---------------------------------------------------------------------
4611: PROCEDURE Check_Visit_UK_Items (
4612: p_Visit_rec IN Visit_Rec_Type,
4613: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
4614: x_return_status OUT NOCOPY VARCHAR2
4615: )
4616: IS
4617: l_valid_flag VARCHAR2(1);

Line 4625: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL

4621: -- For Create_Visit, when ID is passed in, we need to
4622: -- check if this ID is unique.
4623: IF UPPER(p_Visit_rec.operation_flag) <> 'C' THEN
4624:
4625: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL
4626: THEN
4627:
4628: IF Ahl_Utility_Pvt.check_uniqueness(
4629: 'Ahl_Visits_VL',

Line 4645: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

4641: END IF;
4642: END IF;
4643:
4644: -- check if VISIT NUMBER is UNIQUE
4645: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
4646: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
4647: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
4648: 'Ahl_Visits_VL',
4649: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER || ''''