APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VISITS_B

Line 263: AHL_VISITS_B VST,

259: VST.PROJECT_ID PROJECT_ID,
260: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,
261: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
262: FROM AHL_WORKORDERS WO,
263: AHL_VISITS_B VST,
264: AHL_VISIT_TASKS_B VTS,
265: WIP_DISCRETE_JOBS WIP
266: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
267: AND WO.VISIT_ID = VST.VISIT_ID

Line 515: FROM AHL_VISITS_B AVTS,

511: ORIGTSK.VISIT_TASK_NAME ORIGINATING_TASK_NAME,
512: ATSK.MR_ID MR_ID,
513: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
514: AMRH.DESCRIPTION MR_DESCRIPTION
515: FROM AHL_VISITS_B AVTS,
516: AHL_VISIT_TASKS_B ATSK,
517: AHL_VISIT_TASKS_TL ATSKL,
518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,

Line 614: FROM AHL_VISITS_B AVTS,

610: ORIGTSK.VISIT_TASK_NAME ORIGINATING_TASK_NAME,
611: ATSK.MR_ID MR_ID,
612: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
613: AMRH.DESCRIPTION MR_DESCRIPTION
614: FROM AHL_VISITS_B AVTS,
615: AHL_VISIT_TASKS_B ATSK,
616: AHL_VISIT_TASKS_TL ATSKL,
617: AHL_VISIT_TASKS_VL ORIGTSK,
618: AHL_MR_HEADERS_VL AMRH,

Line 1306: UPDATE AHL_VISITS_B

1302:
1303: -- post 115.10 changes start
1304:
1305: IF c_visit_rec.STATUS_CODE = 'RELEASED' THEN
1306: UPDATE AHL_VISITS_B
1307: SET STATUS_CODE = 'PARTIALLY RELEASED',
1308: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
1309: WHERE VISIT_ID =c_visit_rec.VISIT_ID ;
1310: END IF;

Line 3177: UPDATE AHL_VISITS_B

3173: CLOSE c_job;
3174:
3175: IF l_count > 0 THEN
3176: -- To update visit's prices
3177: UPDATE AHL_VISITS_B
3178: SET ACTUAL_PRICE = NULL, ESTIMATED_PRICE = NULL,
3179: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3180: WHERE VISIT_ID = l_visit_rec.visit_id;
3181:

Line 3564: from ahl_visits_b

3560:
3561: Cursor c_any_task_flg(p_visit_id in number)
3562: is
3563: Select any_task_chg_flag
3564: from ahl_visits_b
3565: where visit_id = p_visit_id;
3566:
3567: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;
3568:

Line 3567: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;

3563: Select any_task_chg_flag
3564: from ahl_visits_b
3565: where visit_id = p_visit_id;
3566:
3567: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;
3568:
3569: l_return_status VARCHAR2(1);
3570: l_cost_parent_id NUMBER;
3571: l_msg_data VARCHAR2(2000);

Line 5199: UPDATE ahl_visits_b

5195: IF (c_visit_task_exists%NOTFOUND and
5196: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
5197: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date)
5198: THEN
5199: UPDATE ahl_visits_b
5200: SET status_code = 'RELEASED',
5201: object_version_number = object_version_number + 1
5202: WHERE visit_id = c_visit_rec.visit_id;
5203: END IF;

Line 6127: UPDATE ahl_visits_b

6123:
6124: l_act_price:= NVL(c_visit_rec.actual_price,0) - NVL(l_act_price,0);
6125: l_est_price:= NVL(c_visit_rec.estimated_price,0) - NVL(l_est_price,0);
6126:
6127: UPDATE ahl_visits_b
6128: SET actual_price=l_act_price,
6129: estimated_price=l_est_price,
6130: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6131: WHERE visit_id=l_visit_id;

Line 6650: UPDATE ahl_visits_b

6646:
6647: l_act_price:= NVL(c_visit_rec.actual_price,0) - NVL(l_act_price,0);
6648: l_est_price:= NVL(c_visit_rec.estimated_price,0) - NVL(l_est_price,0);
6649:
6650: UPDATE ahl_visits_b
6651: SET actual_price=l_act_price,
6652: estimated_price=l_est_price,
6653: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6654: WHERE visit_id=l_visit_id;

Line 7722: UPDATE AHL_VISITS_B

7718: RAISE Fnd_Api.G_EXC_ERROR;
7719: END IF;
7720:
7721: IF c_visit_rec.STATUS_CODE = 'RELEASED' THEN
7722: UPDATE AHL_VISITS_B
7723: SET STATUS_CODE = 'PARTIALLY RELEASED',
7724: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
7725: WHERE VISIT_ID =c_visit_rec.VISIT_ID ;
7726: END IF;

Line 7835: FROM ahl_visits_b

7831: J NUMBER;
7832:
7833: CURSOR c_get_Item_Instance(p_visit_id NUMBER) IS
7834: SELECT ITEM_INSTANCE_ID
7835: FROM ahl_visits_b
7836: WHERE visit_id = p_visit_id;
7837:
7838: CURSOR c_get_visit_applicable_mrs IS
7839: SELECT distinct mr_header_id