APPS.OZF_FUNDRULES_PVT dependencies on OZF_OFFERS

Line 834: FROM ozf_offers

830: CURSOR c_offer_id(
831: p_list_header_id IN NUMBER) IS
832: SELECT offer_id,
833: object_version_number
834: FROM ozf_offers
835: WHERE qp_list_header_id = p_list_header_id;
836:
837: CURSOR c_old_fund(
838: cv_fund_id IN NUMBER)

Line 1195: -- Update ozf_offers with status code 'PENDING' by incrementing object_version_number.

1191: RAISE fnd_api.g_exc_unexpected_error;
1192: END IF;
1193: END IF;
1194:
1195: -- Update ozf_offers with status code 'PENDING' by incrementing object_version_number.
1196: IF l_offer_pending_flag = 'T' THEN
1197: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1198:
1199: -- 10/11/2002 mpande pass the default user status and check what is the default status code

Line 1200: UPDATE ozf_offers

1196: IF l_offer_pending_flag = 'T' THEN
1197: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1198:
1199: -- 10/11/2002 mpande pass the default user status and check what is the default status code
1200: UPDATE ozf_offers
1201: SET status_code = 'PENDING',
1202: user_status_id = l_offer_hdr_rec.user_status_id,
1203: object_version_number = object_version_number + 1
1204: WHERE offer_id = l_ozf_offer_id;