APPS.OZF_OFFER_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 2285: FROM ozf_request_headers_all_b

2281:
2282: ---Start POS profile Batch changes
2283: cursor check_Ship_From_Stock(p_offr_code VARCHAR2) IS
2284: SELECT ship_from_stock_flag
2285: FROM ozf_request_headers_all_b
2286: WHERE agreement_number=p_offr_code
2287: AND ship_from_stock_flag='Y';
2288:
2289: l_spr_accr_offr VARCHAR2(1):='N';

Line 3768: FROM ozf_request_headers_all_b req,ozf_offers off

3764: )
3765: IS
3766: CURSOR c_req_header_rec(p_offer_id IN NUMBER) IS
3767: SELECT req.request_header_id,req.object_version_number,req.status_code
3768: FROM ozf_request_headers_all_b req,ozf_offers off
3769: WHERE req.request_number = off.offer_code
3770: AND off.qp_list_header_id = p_offer_id;
3771:
3772: l_req_header_id NUMBER;

Line 3789: UPDATE ozf_request_headers_all_b

3785: FETCH c_req_header_rec INTO l_req_header_id, l_obj_ver_num, l_status_code;
3786: CLOSE c_req_header_rec;
3787:
3788: IF l_status_code <> 'APPROVED' THEN
3789: UPDATE ozf_request_headers_all_b
3790: SET status_code ='APPROVED',
3791: object_version_number = l_obj_ver_num + 1
3792: WHERE request_header_id = l_req_header_id;
3793: END IF;

Line 4010: , ozf_request_headers_all_b req

4006: , last_updated_by = FND_GLOBAL.user_id
4007: WHERE approval_access_id IN
4008: (SELECT apr.approval_access_id
4009: FROM ozf_approval_access apr
4010: , ozf_request_headers_all_b req
4011: , jtf_rs_resource_extns jre
4012: WHERE req.request_header_id = apr.object_id
4013: AND apr.object_id = req.request_header_id
4014: AND req.offer_id = p_offer_rec.qp_list_header_id

Line 4080: -- update ozf_request_headers_all_b update activating

4076: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'ACTIVE')
4077: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
4078:
4079: IF p_offer_rec.custom_setup_id = 110 THEN -- soft fund offers
4080: -- update ozf_request_headers_all_b update activating
4081: update_request_status (x_return_status => x_return_status,
4082: x_msg_count => x_msg_count,
4083: x_msg_data => x_msg_data,
4084: p_qp_list_header_id => p_offer_rec.qp_list_header_id);