APPS.OZF_OFFER_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 3602: FROM ozf_request_headers_all_b req,ozf_offers off

3598: )
3599: IS
3600: CURSOR c_req_header_rec(p_offer_id IN NUMBER) IS
3601: SELECT req.request_header_id,req.object_version_number,req.status_code
3602: FROM ozf_request_headers_all_b req,ozf_offers off
3603: WHERE req.request_number = off.offer_code
3604: AND off.qp_list_header_id = p_offer_id;
3605:
3606: l_req_header_id NUMBER;

Line 3623: UPDATE ozf_request_headers_all_b

3619: FETCH c_req_header_rec INTO l_req_header_id, l_obj_ver_num, l_status_code;
3620: CLOSE c_req_header_rec;
3621:
3622: IF l_status_code <> 'APPROVED' THEN
3623: UPDATE ozf_request_headers_all_b
3624: SET status_code ='APPROVED',
3625: object_version_number = l_obj_ver_num + 1
3626: WHERE request_header_id = l_req_header_id;
3627: END IF;

Line 3829: , ozf_request_headers_all_b req

3825: , last_updated_by = FND_GLOBAL.user_id
3826: WHERE approval_access_id IN
3827: (SELECT apr.approval_access_id
3828: FROM ozf_approval_access apr
3829: , ozf_request_headers_all_b req
3830: , jtf_rs_resource_extns jre
3831: WHERE req.request_header_id = apr.object_id
3832: AND apr.object_id = req.request_header_id
3833: AND req.offer_id = p_offer_rec.qp_list_header_id

Line 3899: -- update ozf_request_headers_all_b update activating

3895: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'ACTIVE')
3896: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3897:
3898: IF p_offer_rec.custom_setup_id = 110 THEN -- soft fund offers
3899: -- update ozf_request_headers_all_b update activating
3900: update_request_status (x_return_status => x_return_status,
3901: x_msg_count => x_msg_count,
3902: x_msg_data => x_msg_data,
3903: p_qp_list_header_id => p_offer_rec.qp_list_header_id);