APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VISITS_B

Line 67: FROM ahl_visits_b

63: -- Define Local Cursors
64: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
65: SELECT status_code, outside_party_flag, price_list_id, actual_price, estimated_price,
66: any_task_chg_flag, service_request_id, start_date_time, close_date_time
67: FROM ahl_visits_b
68: WHERE visit_id = p_visit_id;
69:
70: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS
71: SELECT customer_id FROM cs_incidents_all_b

Line 167: 'Visit id not found in ahl_visits_b table'

163: fnd_log.string
164: (
165: fnd_log.level_exception,
166: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
167: 'Visit id not found in ahl_visits_b table'
168: );
169: END IF;
170: CLOSE visit_info_csr;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 430: FROM ahl_visits_b

426: -- Define local cursors
427: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
428: SELECT outside_party_flag, service_request_id,
429: status_code,start_date_time, close_date_time
430: FROM ahl_visits_b
431: WHERE visit_id = p_visit_id;
432:
433: CURSOR visit_tasks_csr(p_visit_id IN NUMBER) IS
434: SELECT 'x' FROM ahl_visit_tasks_b

Line 543: 'Visit id not found in ahl_visits_b table'

539: fnd_log.string
540: (
541: fnd_log.level_exception,
542: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
543: 'Visit id not found in ahl_visits_b table'
544: );
545: END IF;
546:
547: ELSIF (l_visit_status_code = 'CLOSED')THEN

Line 1363: From ahl_visits_b

1359: SERVICE_REQUEST_ID,
1360: OUTSIDE_PARTY_FLAG,
1361: ORGANIZATION_ID,
1362: any_task_chg_flag
1363: From ahl_visits_b
1364: where visit_id=p_visit_id;
1365:
1366: l_visit_rec visit_info_csr%rowtype;
1367:

Line 2140: FROM ahl_visit_tasks_b VT, ahl_visits_b V

2136:
2137: CURSOR other_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2138:
2139: SELECT VT.visit_task_id, VT.mr_id,VT.estimated_price,VT.actual_price,VT.visit_task_number, V.visit_number
2140: FROM ahl_visit_tasks_b VT, ahl_visits_b V
2141: WHERE VT.VISIT_ID = V.VISIT_ID
2142: AND NOT (task_type_code = 'SUMMARY' AND mr_id IS NULL)
2143: AND V.visit_id = p_visit_id
2144: AND nvl(VT.status_code,'x') <> 'DELETED'

Line 2753: From ahl_visits_b

2749: outside_party_flag,
2750: organization_id,
2751: price_list_id,
2752: service_request_id
2753: From ahl_visits_b
2754: where visit_id=c_visit_id;
2755:
2756: l_visit_rec c_visit_csr%rowtype;
2757:

Line 3286: From ahl_visits_b

3282: -- Cursor to retrieve visit info
3283: Cursor c_visit_csr(c_visit_id in number)
3284: Is
3285: Select any_task_chg_flag, status_code
3286: From ahl_visits_b
3287: where visit_id=c_visit_id;
3288: --Bug fix #4542684 10Aug2005 yazhou ends
3289:
3290: -- Cursor to get all tasks associated to visit