APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_OFFERS

Line 1743: FROM ozf_offers

1739: -- yzhao: 02/13/2003 fix bug 2761622 AMS: VALIDATE MARKET ELIGIBILITY AND PRODUCT ELIGIBILITY BREAKS BUDGET APPROVAL
1740: -- get lumpsum or scan data offer's market qualifier
1741: CURSOR c_get_offer_customer IS
1742: SELECT offer_type, qualifier_id
1743: FROM ozf_offers
1744: WHERE qp_list_header_id = p_object_id;
1745: BEGIN
1746:
1747: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1957: FROM ozf_offers

1953: -- yzhao: 02/13/2003 fix bug 2761622 AMS: VALIDATE MARKET ELIGIBILITY AND PRODUCT ELIGIBILITY BREAKS BUDGET APPROVAL
1954: -- get lumpsum or scan data offer's market qualifier
1955: CURSOR c_get_offer_customer IS
1956: SELECT offer_type, qualifier_id
1957: FROM ozf_offers
1958: WHERE qp_list_header_id = p_object_id;
1959:
1960: BEGIN
1961:

Line 2291: FROM ozf_offers

2287: WHERE activity_budget_id = p_actbudget_id;
2288:
2289: CURSOR c_get_offer_type IS
2290: SELECT offer_type
2291: FROM ozf_offers
2292: WHERE qp_list_header_id = p_object_id;
2293:
2294: BEGIN
2295:

Line 2448: FROM ozf_offers

2444: l_msg_data VARCHAR2(2000) := NULL;
2445:
2446: CURSOR c_get_offer_type IS
2447: SELECT offer_type
2448: FROM ozf_offers
2449: WHERE qp_list_header_id = p_object_id;
2450:
2451: BEGIN
2452:

Line 2822: FROM ozf_offers

2818: WHERE schedule_id=p_object_id;
2819: ELSIF p_object_type = 'OFFR' THEN
2820: OPEN l_obj_details FOR
2821: SELECT budget_amount_tc,owner_id
2822: FROM ozf_offers
2823: WHERE qp_list_header_id=p_object_id;
2824: ELSIF p_object_type = 'EVEH' THEN
2825: OPEN l_obj_details FOR
2826: SELECT fund_amount_tc,owner_user_id

Line 2961: FROM ozf_offers , qp_list_headers qph

2957: -- AND status_code = 'PENDING'; -- should it be pending validation?
2958:
2959: CURSOR c_offer_info(p_object_id IN NUMBER) IS
2960: SELECT offer_type,custom_setup_id, reusable,offer_amount,offer_code,owner_id, qph.description
2961: FROM ozf_offers , qp_list_headers qph
2962: WHERE qp_list_header_id = p_object_id
2963: and qp_list_header_id = qph.list_header_id ;
2964:
2965: --kdass 09-DEC-2005 bug 4870218 - SQL ID# 14892629

Line 3309: UPDATE ozf_offers

3305:
3306: ROLLBACK TO conc_validate_offer_budget;
3307:
3308: -- revert to draft status
3309: UPDATE ozf_offers
3310: SET status_code = 'DRAFT'
3311: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
3312: ,status_date = SYSDATE
3313: ,object_version_number = object_version_number + 1

Line 3461: FROM ozf_offers

3457: AND object_attribute = 'BREQ';
3458:
3459: CURSOR c_offer_info(p_object_id IN NUMBER) IS
3460: SELECT NVL(offer_amount,0),owner_id,custom_setup_id,offer_code
3461: FROM ozf_offers
3462: WHERE qp_list_header_id = p_object_id;
3463:
3464: l_act_budget_id NUMBER;
3465: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;