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 1146: -- Update ozf_offers with status code 'PENDING' by incrementing object_version_number.

1142: RAISE fnd_api.g_exc_unexpected_error;
1143: END IF;
1144: END IF;
1145:
1146: -- Update ozf_offers with status code 'PENDING' by incrementing object_version_number.
1147: IF l_offer_pending_flag = 'T' THEN
1148: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1149:
1150: -- 10/11/2002 mpande pass the default user status and check what is the default status code

Line 1151: UPDATE ozf_offers

1147: IF l_offer_pending_flag = 'T' THEN
1148: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1149:
1150: -- 10/11/2002 mpande pass the default user status and check what is the default status code
1151: UPDATE ozf_offers
1152: SET status_code = 'PENDING',
1153: user_status_id = l_offer_hdr_rec.user_status_id,
1154: object_version_number = object_version_number + 1
1155: WHERE offer_id = l_ozf_offer_id;