APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISITS_PKG

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

2427: --VWPE ER-12424063 :: tchimira :: 15-FEB -2011 :: end
2428:
2429: -------------------------- Insert --------------------------
2430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2431: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.Insert_Row');
2432: END IF;
2433: -- Invoke the table handler to create a record
2434: -- Post 11.5.10 Enhancements
2435: -- Added Priority and Project Template Id

Line 2443: Ahl_Visits_Pkg.Insert_Row (

2439: IF (l_Visit_rec.VISIT_NAME = 'Auto-Visit') THEN
2440: l_Visit_rec.VISIT_NAME := l_Visit_rec.VISIT_NAME || '-' || to_char(l_visit_number);
2441: END IF;
2442:
2443: Ahl_Visits_Pkg.Insert_Row (
2444: X_ROWID => l_rowid,
2445: X_VISIT_ID => l_Visit_rec.VISIT_ID,
2446: X_VISIT_NUMBER => l_visit_number,
2447: X_VISIT_TYPE_CODE => l_Visit_rec.VISIT_TYPE_CODE,

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

2511: X_AUTO_VISIT_TYPE_FLAG =>l_Visit_rec.AUTO_VISIT_TYPE_FLAG
2512: );
2513:
2514: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2515: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.Insert_Row');
2516: END IF;
2517:
2518: -- set OUT value
2519: p_x_visit_rec.VISIT_ID := l_Visit_rec.VISIT_ID;

Line 2986: Ahl_Visits_Pkg.Insert_Row (

2982: l_visit_id := Get_Visit_Id();
2983: l_visit_number := Get_Visit_Number();
2984:
2985: -- Create New Visit
2986: Ahl_Visits_Pkg.Insert_Row (
2987: X_ROWID => l_rowid,
2988: X_VISIT_ID => l_Visit_ID,
2989: X_VISIT_NUMBER => l_visit_number,
2990: X_VISIT_TYPE_CODE => c_Visit_rec.VISIT_TYPE_CODE,

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

4481: END IF;
4482:
4483: -------------------------- Update --------------------
4484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4485: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.UPDATE_ROW');
4486: END IF;
4487:
4488: Ahl_Visits_Pkg.UPDATE_ROW (
4489: X_VISIT_ID => l_Visit_rec.VISIT_ID,

Line 4488: Ahl_Visits_Pkg.UPDATE_ROW (

4484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4485: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Ahl_Visits_Pkg.UPDATE_ROW');
4486: END IF;
4487:
4488: Ahl_Visits_Pkg.UPDATE_ROW (
4489: X_VISIT_ID => l_Visit_rec.VISIT_ID,
4490: X_VISIT_NUMBER => c_visit_rec.VISIT_NUMBER,
4491: X_VISIT_TYPE_CODE => l_Visit_rec.VISIT_TYPE_CODE,
4492: X_SIMULATION_PLAN_ID => c_Visit_rec.SIMULATION_PLAN_ID,

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

4558: );
4559:
4560:
4561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4562: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.UPDATE_ROW');
4563: END IF;
4564:
4565: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: START :: START
4566: IF c_visit_rec.status_code <> 'DRAFT' THEN

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

5603: DELETE FROM ahl_visit_tasks_b
5604: WHERE visit_id = p_visit_id;
5605:
5606: --Delete the visit
5607: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);
5608: ELSE
5609: -- Soft Delete
5610: UPDATE AHL_VISITS_B
5611: SET STATUS_CODE = 'DELETED',