eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VISITS_B

Line 68: FROM ahl_visits_b

64: --salogan::Modified Cursor to add CP request id CP ER 9299910::01-JUN-2009::BEGIN
65: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
66: SELECT status_code, outside_party_flag, price_list_id, actual_price, estimated_price,
67: any_task_chg_flag, service_request_id, start_date_time, close_date_time, cst_est_request_id
68: FROM ahl_visits_b
69: WHERE visit_id = p_visit_id;
70: --salogan::Modified Cursor to add CP request id CP ER 9299910::01-JUN-2009::END
71:
72: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS

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

182: fnd_log.string
183: (
184: fnd_log.level_exception,
185: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
186: 'Visit id not found in ahl_visits_b table'
187: );
188: END IF;
189: CLOSE visit_info_csr;
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 476: FROM ahl_visits_b

472: -- Define local cursors
473: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
474: SELECT outside_party_flag, service_request_id,
475: status_code,start_date_time, close_date_time
476: FROM ahl_visits_b
477: WHERE visit_id = p_visit_id;
478:
479: CURSOR visit_tasks_csr(p_visit_id IN NUMBER) IS
480: SELECT 'x' FROM ahl_visit_tasks_b

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

586: fnd_log.string
587: (
588: fnd_log.level_exception,
589: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
590: 'Visit id not found in ahl_visits_b table'
591: );
592: END IF;
593:
594: ELSIF (l_visit_status_code = 'CLOSED')THEN

Line 1432: From ahl_visits_b

1428: SERVICE_REQUEST_ID,
1429: OUTSIDE_PARTY_FLAG,
1430: ORGANIZATION_ID,
1431: any_task_chg_flag
1432: From ahl_visits_b
1433: where visit_id=p_visit_id;
1434:
1435: l_visit_rec visit_info_csr%rowtype;
1436:

Line 2221: FROM ahl_visit_tasks_b VT, ahl_visits_b V

2217:
2218: CURSOR other_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2219:
2220: SELECT VT.visit_task_id, VT.mr_id,VT.estimated_price,VT.actual_price,VT.visit_task_number, V.visit_number
2221: FROM ahl_visit_tasks_b VT, ahl_visits_b V
2222: WHERE VT.VISIT_ID = V.VISIT_ID
2223: AND NOT (task_type_code = 'SUMMARY' AND mr_id IS NULL)
2224: AND V.visit_id = p_visit_id
2225: AND nvl(VT.status_code,'x') <> 'DELETED'

Line 2834: From ahl_visits_b

2830: outside_party_flag,
2831: organization_id,
2832: price_list_id,
2833: service_request_id
2834: From ahl_visits_b
2835: where visit_id=c_visit_id;
2836:
2837: l_visit_rec c_visit_csr%rowtype;
2838:

Line 3367: From ahl_visits_b

3363: -- Cursor to retrieve visit info
3364: Cursor c_visit_csr(c_visit_id in number)
3365: Is
3366: Select any_task_chg_flag, status_code
3367: From ahl_visits_b
3368: where visit_id=c_visit_id;
3369: --Bug fix #4542684 10Aug2005 yazhou ends
3370:
3371: -- Cursor to get all tasks associated to visit

Line 3613: SELECT * FROM AHL_VISITS_B

3609: l_log_unexpected NUMBER := fnd_log.level_unexpected;
3610: -----------------------------------------------------------------
3611: -- To find visit related information
3612: CURSOR c_visit (c_id IN NUMBER) IS
3613: SELECT * FROM AHL_VISITS_B
3614: WHERE VISIT_ID = c_id
3615: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3616: c_visit_rec c_visit%ROWTYPE;
3617:

Line 3621: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

3617:
3618: --Cursor to fetch phase
3619: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
3620: SELECT 'X'
3621: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
3622: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
3623: AND FCR.PHASE_CODE IN ('P', 'R')
3624: AND AVB.VISIT_ID = c_id;
3625: l_dummy c_conc_req_phase%ROWTYPE;

Line 3648: SELECT visit_number, status_code INTO l_visit_num, l_visit_status FROM AHL_VISITS_B WHERE visit_id = p_x_cost_price_rec.Visit_id;

3644: L_API_NAME,G_PKG_NAME) THEN
3645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3646: END IF;
3647:
3648: SELECT visit_number, status_code INTO l_visit_num, l_visit_status FROM AHL_VISITS_B WHERE visit_id = p_x_cost_price_rec.Visit_id;
3649:
3650: IF (l_log_procedure >= l_log_current_level) THEN
3651: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','After fetching the visit number, status from visit id. Visit Number = ' || l_visit_num|| 'Visit Status Code = '||l_visit_status);
3652: END IF;

Line 3745: UPDATE ahl_visits_b

3741: END IF;
3742:
3743: x_request_id := l_req_id;
3744: --Update the table with l_req_id
3745: UPDATE ahl_visits_b
3746: SET CST_EST_REQUEST_ID = l_req_id,
3747: OBJECT_VERSION_NUMBER = object_version_number + 1,
3748: LAST_UPDATE_DATE = SYSDATE,
3749: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;

3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851:
3852: IF l_cost_price_rec.visit_id IS NOT NULL THEN
3853: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost');
3854: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_cost_price_rec.visit_id);