[Home] [Help]
1390: -- After fetching the UE id, we need to lock the row to prevent any other process(BUE) from deleting the row corresponding to that UE id
1391: OPEN c_row_lock(p_unit_id);
1392: FETCH c_row_lock INTO l_lock_var;
1393:
1394: -- Insert a record in AHL_VISIT_TASKS base and translational tables
1395: Ahl_Visit_Tasks_Pkg.Insert_Row (
1396: X_ROWID => l_rowid,
1397: X_VISIT_TASK_ID => l_task_ID ,
1398: X_VISIT_TASK_NUMBER => l_task_number,
1718: RETURN NUMBER
1719: IS
1720: -- Define local cursors
1721: CURSOR c_seq_t IS
1722: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL
1723: FROM dual;
1724:
1725: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1726: SELECT 1
3064: fnd_log.string(l_log_statement,
3065: L_DEBUG_KEY,
3066: 'update origin');
3067: END IF;
3068: UPDATE AHL_VISIT_TASKS_B SET ORIGINATING_TASK_ID = NULL,
3069: OBJECT_VERSION_NUMBER = c_origin_rec.object_version_number + 1
3070: WHERE VISIT_TASK_ID = c_origin_rec.visit_task_id;
3071: END IF;
3072: END LOOP;
3085: fnd_log.string(l_log_statement,
3086: L_DEBUG_KEY,
3087: 'update parent');
3088: END IF;
3089: UPDATE AHL_VISIT_TASKS_B SET COST_PARENT_ID = l_parent_id,
3090: OBJECT_VERSION_NUMBER = c_parent_rec.object_version_number + 1
3091: WHERE VISIT_TASK_ID = c_parent_rec.visit_task_id;
3092: END IF;
3093: END LOOP;
4821:
4822: -- Define local variables
4823: l_visit_id NUMBER;
4824: l_visit_task_number NUMBER;
4825: l_status_code AHL_VISIT_TASKS_B.STATUS_CODE%TYPE;
4826: l_task_type_code AHL_VISIT_TASKS_B.TASK_TYPE_CODE%TYPE;
4827: l_instance_id NUMBER;
4828: l_current_rts AHL_VISIT_TASKS_B.RETURN_TO_SUPPLY_FLAG%TYPE;
4829: l_rts_count NUMBER;
5098: WHERE visit_task_id = c_visit_task_id;
5099:
5100: -- Define local variables
5101: l_visit_task_number NUMBER;
5102: l_status_code AHL_VISIT_TASKS_B.STATUS_CODE%TYPE;
5103: l_task_type_code AHL_VISIT_TASKS_B.TASK_TYPE_CODE%TYPE;
5104: l_current_rts AHL_VISIT_TASKS_B.RETURN_TO_SUPPLY_FLAG%TYPE;
5105: l_task_rec get_task_prelim_details%ROWTYPE;
5106: