DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VISIT_TASKS_PKG

Line 1887: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row');

1883: -------------------------- Insert --------------------------
1884: IF (l_log_statement >= l_log_current_level) THEN
1885: fnd_log.string(l_log_statement,
1886: L_DEBUG_KEY,
1887: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row');
1888: END IF;
1889:
1890: -- Invoke the table handler to create a record
1891: Ahl_Visit_Tasks_Pkg.Insert_Row (

Line 1891: Ahl_Visit_Tasks_Pkg.Insert_Row (

1887: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row');
1888: END IF;
1889:
1890: -- Invoke the table handler to create a record
1891: Ahl_Visit_Tasks_Pkg.Insert_Row (
1892: X_ROWID => l_rowid,
1893: X_VISIT_TASK_ID => l_task_rec.visit_task_id,
1894: X_VISIT_TASK_NUMBER => l_task_rec.visit_task_number,
1895: X_OBJECT_VERSION_NUMBER => 1,

Line 2530: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row' );

2526:
2527: IF (l_log_statement >= l_log_current_level) THEN
2528: fnd_log.string(l_log_statement,
2529: L_DEBUG_KEY,
2530: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row' );
2531: END IF;
2532:
2533: -- Invoke the table handler to create a record
2534: Ahl_Visit_Tasks_Pkg.Insert_Row (

Line 2534: Ahl_Visit_Tasks_Pkg.Insert_Row (

2530: 'Before Calling Ahl_Visit_Tasks_Pkg.Insert_Row' );
2531: END IF;
2532:
2533: -- Invoke the table handler to create a record
2534: Ahl_Visit_Tasks_Pkg.Insert_Row (
2535: X_ROWID => l_rowid,
2536: X_VISIT_TASK_ID => l_task_rec.visit_task_id,
2537: X_VISIT_TASK_NUMBER => l_task_rec.visit_task_number,
2538: X_OBJECT_VERSION_NUMBER => 1,

Line 2595: 'After Calling Ahl_Visit_Tasks_Pkg.Insert_Row' );

2591:
2592: IF (l_log_statement >= l_log_current_level) THEN
2593: fnd_log.string(l_log_statement,
2594: L_DEBUG_KEY,
2595: 'After Calling Ahl_Visit_Tasks_Pkg.Insert_Row' );
2596: END IF;
2597:
2598: ------------------------- finish -------------------------------
2599: -- Added cxcheng POST11510--------------

Line 3644: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

3640:
3641: IF (l_log_statement >= l_log_current_level) THEN
3642: fnd_log.string(l_log_statement,
3643: L_DEBUG_KEY,
3644: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
3645: END IF;
3646:
3647: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
3648: X_VISIT_TASK_ID => l_task_rec.visit_task_id,

Line 3647: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (

3643: L_DEBUG_KEY,
3644: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
3645: END IF;
3646:
3647: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
3648: X_VISIT_TASK_ID => l_task_rec.visit_task_id,
3649: X_VISIT_TASK_NUMBER => l_old_Task_rec.visit_task_number,
3650: X_OBJECT_VERSION_NUMBER => l_task_rec.OBJECT_VERSION_NUMBER + 1,
3651: X_VISIT_ID => l_old_Task_rec.visit_id,

Line 3704: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

3700:
3701: IF (l_log_statement >= l_log_current_level) THEN
3702: fnd_log.string(l_log_statement,
3703: L_DEBUG_KEY,
3704: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
3705: END IF;
3706:
3707: -- Added cxcheng POST11510--------------
3708: --Now adjust the times derivation for task

Line 4177: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

4173: -------------------------- update --------------------
4174: IF (l_log_statement >= l_log_current_level) THEN
4175: fnd_log.string(l_log_statement,
4176: L_DEBUG_KEY,
4177: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4178: END IF;
4179:
4180: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
4181: X_VISIT_TASK_ID => l_task_rec.visit_task_id,

Line 4180: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (

4176: L_DEBUG_KEY,
4177: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4178: END IF;
4179:
4180: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
4181: X_VISIT_TASK_ID => l_task_rec.visit_task_id,
4182: X_VISIT_TASK_NUMBER => c_task_rec.visit_task_number,
4183: X_OBJECT_VERSION_NUMBER => l_task_rec.OBJECT_VERSION_NUMBER + 1,
4184: X_VISIT_ID => l_task_rec.visit_id,

Line 4237: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

4233:
4234: IF (l_log_statement >= l_log_current_level) THEN
4235: fnd_log.string(l_log_statement,
4236: L_DEBUG_KEY,
4237: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4238: END IF;
4239:
4240: -- Added cxcheng POST11510--------------
4241: --Now adjust the times derivation for task

Line 4741: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

4737: -------------------------- update --------------------
4738: IF (l_log_statement >= l_log_current_level) THEN
4739: fnd_log.string(l_log_statement,
4740: L_DEBUG_KEY,
4741: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4742: END IF;
4743:
4744: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
4745: X_VISIT_TASK_ID => l_task_rec.visit_task_id,

Line 4744: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (

4740: L_DEBUG_KEY,
4741: 'Before Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4742: END IF;
4743:
4744: Ahl_Visit_Tasks_Pkg.UPDATE_ROW (
4745: X_VISIT_TASK_ID => l_task_rec.visit_task_id,
4746: X_VISIT_TASK_NUMBER => c_task_rec.visit_task_number,
4747: X_OBJECT_VERSION_NUMBER => l_task_rec.OBJECT_VERSION_NUMBER + 1,
4748: X_VISIT_ID => l_task_rec.visit_id,

Line 4802: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');

4798:
4799: IF (l_log_statement >= l_log_current_level) THEN
4800: fnd_log.string(l_log_statement,
4801: L_DEBUG_KEY,
4802: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
4803: END IF;
4804:
4805: ------------------------End of API Body------------------------------------
4806: -- Added cxcheng POST11510--------------