APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISITS_PKG

Line 2025: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.Insert_Row');

2021: END IF;
2022:
2023: -------------------------- Insert --------------------------
2024: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2025: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.Insert_Row');
2026: END IF;
2027: -- Invoke the table handler to create a record
2028: -- Post 11.5.10 Enhancements
2029: -- Added Priority and Project Template Id

Line 2032: Ahl_Visits_Pkg.Insert_Row (

2028: -- Post 11.5.10 Enhancements
2029: -- Added Priority and Project Template Id
2030: -- Added Unit Schedule Id.
2031:
2032: Ahl_Visits_Pkg.Insert_Row (
2033: X_ROWID => l_rowid,
2034: X_VISIT_ID => l_Visit_rec.VISIT_ID,
2035: X_VISIT_NUMBER => l_visit_number,
2036: X_VISIT_TYPE_CODE => l_Visit_rec.VISIT_TYPE_CODE,

Line 2091: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.Insert_Row');

2087: X_INV_LOCATOR_ID => l_Visit_rec.inv_locator_id /*Added by sowsubra*/
2088: );
2089:
2090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2091: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.Insert_Row');
2092: END IF;
2093:
2094: -- set OUT value
2095: p_x_visit_rec.VISIT_ID := l_Visit_rec.VISIT_ID;

Line 2441: Ahl_Visits_Pkg.Insert_Row (

2437: l_visit_id := Get_Visit_Id();
2438: l_visit_number := Get_Visit_Number();
2439:
2440: -- Create New Visit
2441: Ahl_Visits_Pkg.Insert_Row (
2442: X_ROWID => l_rowid,
2443: X_VISIT_ID => l_Visit_ID,
2444: X_VISIT_NUMBER => l_visit_number,
2445: X_VISIT_TYPE_CODE => c_Visit_rec.VISIT_TYPE_CODE,

Line 3550: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.UPDATE_ROW');

3546: END IF;
3547: END IF;
3548: -------------------------- Update --------------------
3549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3550: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.UPDATE_ROW');
3551: END IF;
3552:
3553: Ahl_Visits_Pkg.UPDATE_ROW (
3554: X_VISIT_ID => l_Visit_rec.VISIT_ID,

Line 3553: Ahl_Visits_Pkg.UPDATE_ROW (

3549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3550: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.UPDATE_ROW');
3551: END IF;
3552:
3553: Ahl_Visits_Pkg.UPDATE_ROW (
3554: X_VISIT_ID => l_Visit_rec.VISIT_ID,
3555: X_VISIT_NUMBER => c_visit_rec.VISIT_NUMBER,
3556: X_VISIT_TYPE_CODE => l_Visit_rec.VISIT_TYPE_CODE,
3557: X_SIMULATION_PLAN_ID => c_Visit_rec.SIMULATION_PLAN_ID,

Line 3609: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.UPDATE_ROW');

3605: X_INV_LOCATOR_ID => l_visit_rec.INV_LOCATOR_ID --Added by sowsubra
3606: );
3607:
3608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3609: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.UPDATE_ROW');
3610: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
3611: END IF;
3612:
3613: -- Added cxcheng POST11510--------------

Line 4353: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);

4349: DELETE FROM ahl_visit_tasks_b
4350: WHERE visit_id = p_visit_id;
4351:
4352: --Delete the visit
4353: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);
4354: ELSE
4355: -- Soft Delete
4356: UPDATE AHL_VISITS_B
4357: SET STATUS_CODE = 'DELETED',