APPS.AHL_VWP_RULES_PVT dependencies on AHL_VISIT_TASKS_B_S

Line 1283: -- Insert a record in AHL_VISIT_TASKS base and translational tables

1279: L_DEBUG_KEY,
1280: 'Before calling AHL_VISIT_TASKS_PKG.Insert_Row.');
1281: END IF;
1282:
1283: -- Insert a record in AHL_VISIT_TASKS base and translational tables
1284: Ahl_Visit_Tasks_Pkg.Insert_Row (
1285: X_ROWID => l_rowid,
1286: X_VISIT_TASK_ID => l_task_ID ,
1287: X_VISIT_TASK_NUMBER => l_task_number,

Line 1502: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL

1498: RETURN NUMBER
1499: IS
1500: -- Define local cursors
1501: CURSOR c_seq_t IS
1502: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL
1503: FROM dual;
1504:
1505: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1506: SELECT 1

Line 2749: UPDATE AHL_VISIT_TASKS_B SET ORIGINATING_TASK_ID = NULL,

2745: fnd_log.string(l_log_statement,
2746: L_DEBUG_KEY,
2747: 'update origin');
2748: END IF;
2749: UPDATE AHL_VISIT_TASKS_B SET ORIGINATING_TASK_ID = NULL,
2750: OBJECT_VERSION_NUMBER = c_origin_rec.object_version_number + 1
2751: WHERE VISIT_TASK_ID = c_origin_rec.visit_task_id;
2752: END IF;
2753: END LOOP;

Line 2770: UPDATE AHL_VISIT_TASKS_B SET COST_PARENT_ID = l_parent_id,

2766: fnd_log.string(l_log_statement,
2767: L_DEBUG_KEY,
2768: 'update parent');
2769: END IF;
2770: UPDATE AHL_VISIT_TASKS_B SET COST_PARENT_ID = l_parent_id,
2771: OBJECT_VERSION_NUMBER = c_parent_rec.object_version_number + 1
2772: WHERE VISIT_TASK_ID = c_parent_rec.visit_task_id;
2773: END IF;
2774: END LOOP;