APPS.AHL_VISIT_TASKS_PKG dependencies on AHL_VISIT_TASKS_B

Line 79: insert into AHL_VISIT_TASKS_B (

75:
76: -- Call insert statement in a loop, till either DUP_VAL_ON_INDEX is not thrown or l_count < L_MAX_RETRIES
77: WHILE l_count < L_MAX_RETRIES LOOP
78: begin
79: insert into AHL_VISIT_TASKS_B (
80: DEPARTMENT_ID,
81: PRICE_LIST_ID,
82: STATUS_CODE,
83: ESTIMATED_PRICE,

Line 218: select MAX(visit_task_number) + 1 INTO l_visit_task_number FROM Ahl_Visit_Tasks_B;

214: IF (l_count = L_MAX_RETRIES - 1) THEN
215: RAISE DUP_VAL_ON_INDEX;
216: END IF;
217: l_count := l_count + 1;
218: select MAX(visit_task_number) + 1 INTO l_visit_task_number FROM Ahl_Visit_Tasks_B;
219: END; -- Nested block with Exception Handler
220: END LOOP;
221:
222: END INTERNAL_INSERT_B_ROW;

Line 293: cursor C is select ROWID from AHL_VISIT_TASKS_B

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER,
291: X_REPAIR_BATCH_NAME in VARCHAR2 := NULL --PRAKKUM :: 11/06/2012 :: Bug 14068468
292: ) is
293: cursor C is select ROWID from AHL_VISIT_TASKS_B
294: where VISIT_TASK_ID = X_VISIT_TASK_ID
295: ;
296: begin
297: -- TCHIMIRA::BUG 9303368 :: 02-02-2010

Line 298: -- Call the new internal procedure INTERNAL_INSERT_B_ROW to insert into AHL_VISIT_TASKS_B

294: where VISIT_TASK_ID = X_VISIT_TASK_ID
295: ;
296: begin
297: -- TCHIMIRA::BUG 9303368 :: 02-02-2010
298: -- Call the new internal procedure INTERNAL_INSERT_B_ROW to insert into AHL_VISIT_TASKS_B
299: INTERNAL_INSERT_B_ROW (
300: X_DEPARTMENT_ID,
301: X_PRICE_LIST_ID,
302: X_STATUS_CODE,

Line 512: from AHL_VISIT_TASKS_B

508: MR_ID,
509: DURATION,
510: UNIT_EFFECTIVITY_ID,
511: START_FROM_HOUR
512: from AHL_VISIT_TASKS_B
513: where VISIT_TASK_ID = X_VISIT_TASK_ID
514: for update of VISIT_TASK_ID nowait;
515: recinfo c%rowtype;
516:

Line 709: update AHL_VISIT_TASKS_B set

705: X_LAST_UPDATED_BY in NUMBER,
706: X_LAST_UPDATE_LOGIN in NUMBER
707: ) is
708: begin
709: update AHL_VISIT_TASKS_B set
710: DEPARTMENT_ID = X_DEPARTMENT_ID,
711: PRICE_LIST_ID = X_PRICE_LIST_ID,
712: STATUS_CODE = X_STATUS_CODE,
713: ESTIMATED_PRICE = X_ESTIMATED_PRICE,

Line 796: delete from AHL_VISIT_TASKS_B

792: if (sql%notfound) then
793: raise no_data_found;
794: end if;
795:
796: delete from AHL_VISIT_TASKS_B
797: where VISIT_TASK_ID = X_VISIT_TASK_ID;
798:
799: if (sql%notfound) then
800: raise no_data_found;

Line 810: from AHL_VISIT_TASKS_B B

806: begin
807: delete from AHL_VISIT_TASKS_TL T
808: where not exists
809: (select NULL
810: from AHL_VISIT_TASKS_B B
811: where B.VISIT_TASK_ID = T.VISIT_TASK_ID
812: );
813:
814: update AHL_VISIT_TASKS_TL T set (