APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_VISITS_B

Line 110: FROM ahl_visits_b

106:
107: -- Define Local Cursors
108: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
109: SELECT status_code
110: FROM ahl_visits_b
111: WHERE visit_id = p_visit_id;
112:
113: --Cursor to retrieve Costs associated to Task
114: CURSOR Get_task_cost_price_cur (C_VISIT_TASK_ID IN NUMBER)

Line 129: ahl_visits_b vs,

125: vs.close_date_time,
126: ci.customer_id
127:
128: FROM ahl_visit_tasks_b vt,
129: ahl_visits_b vs,
130: cs_incidents_all_b ci
131:
132: WHERE vt.visit_task_id = C_VISIT_TASK_ID
133: AND vt.visit_id=vs.visit_id

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

413: fnd_log.string
414: (
415: fnd_log.level_exception,
416: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
417: 'Visit id not found in ahl_visits_b table'
418: );
419: END IF;
420: CLOSE visit_info_csr;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1000: fnd_log.string
1001: (
1002: fnd_log.level_error,
1003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1004: 'Visit id not found in ahl_visits_b table'
1005: );
1006: END IF;
1007: CLOSE Get_visit_dtls_cur;
1008: RAISE FND_API.G_EXC_ERROR;

Line 1321: ahl_visits_b vs

1317: SELECT vt.visit_id,
1318: vt.visit_task_id,
1319: vs.any_task_chg_flag
1320: FROM ahl_visit_tasks_b vt,
1321: ahl_visits_b vs
1322: WHERE vt.visit_task_id = C_VISIT_TASK_ID
1323: AND vt.visit_id = vs.visit_id
1324: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');
1325:

Line 2482: ' Before updating visit ahl_visits_b, Actual Price: ' || l_visit_task_dtls_rec.visit_actual_price

2478: fnd_log.string
2479: (
2480: fnd_log.level_statement,
2481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2482: ' Before updating visit ahl_visits_b, Actual Price: ' || l_visit_task_dtls_rec.visit_actual_price
2483: );
2484: fnd_log.string
2485: (
2486: fnd_log.level_statement,

Line 2488: ' Before updating visit ahl_visits_b, Estimated Price: ' || l_visit_task_dtls_rec.visit_estimated_price

2484: fnd_log.string
2485: (
2486: fnd_log.level_statement,
2487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2488: ' Before updating visit ahl_visits_b, Estimated Price: ' || l_visit_task_dtls_rec.visit_estimated_price
2489: );
2490:
2491: END IF;
2492:

Line 2494: UPDATE AHL_VISITS_B

2490:
2491: END IF;
2492:
2493: -- Update Visit cost details with new values
2494: UPDATE AHL_VISITS_B
2495: SET actual_price = l_visit_task_dtls_rec.visit_actual_price,
2496: estimated_price = l_visit_task_dtls_rec.visit_estimated_price,
2497: object_version_number = l_visit_task_dtls_rec.visit_object_version_number + 1
2498: WHERE visit_id = l_visit_task_dtls_rec.visit_id;

Line 2662: FROM ahl_visits_b

2658: -- bug fix #4542676
2659: -- Cursor to get visit status
2660: CURSOR visit_info_csr(c_visit_id IN NUMBER) IS
2661: SELECT status_code
2662: FROM ahl_visits_b
2663: WHERE visit_id = c_visit_id;
2664:
2665: l_visit_status VARCHAR2(30);
2666: -- yazhou 09Aug2005 ends

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

2719: fnd_log.string
2720: (
2721: fnd_log.level_exception,
2722: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2723: 'Visit id not found in ahl_visits_b table'
2724: );
2725: END IF;
2726: CLOSE visit_info_csr;
2727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3675: From AHL_VISIT_TASKS_B a,ahl_visits_b b

3671:
3672: Cursor c_task_csr (c_visit_task_id in number)
3673: Is
3674: Select a.mr_route_id,a.mr_id,b.organization_id
3675: From AHL_VISIT_TASKS_B a,ahl_visits_b b
3676: Where a.visit_task_id=c_visit_task_id
3677: and a.visit_id=b.visit_id;
3678:
3679: l_task_rec c_task_csr%rowtype;