1427:
1428: CURSOR default_contact IS
1429: SELECT employee_id
1430: FROM fnd_user
1431: WHERE user_id = fnd_global.user_id;
1432:
1433: CURSOR default_customer_type IS
1434: SELECT party_type
1435: FROM hz_parties
2244: x_msg_count => l_msg_count,
2245: x_msg_data => l_msg_data,
2246: p_resp_appl_id => NULL,
2247: p_resp_id => NULL,
2248: p_user_id => fnd_global.user_id,
2249: p_login_id => fnd_global.conc_login_id,
2250: p_org_id => NULL,
2251: p_request_id => NULL,
2252: p_request_number => NULL,
2245: x_msg_data => l_msg_data,
2246: p_resp_appl_id => NULL,
2247: p_resp_id => NULL,
2248: p_user_id => fnd_global.user_id,
2249: p_login_id => fnd_global.conc_login_id,
2250: p_org_id => NULL,
2251: p_request_id => NULL,
2252: p_request_number => NULL,
2253: p_service_request_rec => l_service_request_rec,
2449:
2450: END IF;
2451:
2452: -- for planner
2453: IF (fnd_global.resp_id <> l_tranit_tech_resp_id and
2454: fnd_global.resp_id <> l_tech_resp_id and
2455: fnd_global.resp_id <> l_data_clerk_resp_id) THEN
2456:
2457: l_user_role := ahl_warranty_entl_pvt.G_USER_PLANNER;
2450: END IF;
2451:
2452: -- for planner
2453: IF (fnd_global.resp_id <> l_tranit_tech_resp_id and
2454: fnd_global.resp_id <> l_tech_resp_id and
2455: fnd_global.resp_id <> l_data_clerk_resp_id) THEN
2456:
2457: l_user_role := ahl_warranty_entl_pvt.G_USER_PLANNER;
2458: IF (l_warranty_entl_tbl(l_rec_count).warranty_contract_id IS NOT null) THEN
2451:
2452: -- for planner
2453: IF (fnd_global.resp_id <> l_tranit_tech_resp_id and
2454: fnd_global.resp_id <> l_tech_resp_id and
2455: fnd_global.resp_id <> l_data_clerk_resp_id) THEN
2456:
2457: l_user_role := ahl_warranty_entl_pvt.G_USER_PLANNER;
2458: IF (l_warranty_entl_tbl(l_rec_count).warranty_contract_id IS NOT null) THEN
2459: l_warranty_entl_tbl(l_rec_count).entitlement_status_code := 'APPROVED';
2739: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
2740: x_return_status => x_return_status,
2741: x_msg_count => x_msg_count,
2742: x_msg_data => x_msg_data,
2743: p_user_id => fnd_global.user_id,
2744: p_login_id => fnd_global.login_id,
2745: p_request_id => p_x_task_tbl(i).Incident_id,
2746: p_object_version_number => p_x_task_tbl(i).Incident_object_version_number,
2747: p_request_number => p_x_task_tbl(i).Incident_number,
2740: x_return_status => x_return_status,
2741: x_msg_count => x_msg_count,
2742: x_msg_data => x_msg_data,
2743: p_user_id => fnd_global.user_id,
2744: p_login_id => fnd_global.login_id,
2745: p_request_id => p_x_task_tbl(i).Incident_id,
2746: p_object_version_number => p_x_task_tbl(i).Incident_object_version_number,
2747: p_request_number => p_x_task_tbl(i).Incident_number,
2748: p_x_sr_mr_association_tbl => l_x_sr_mr_association_tbl