APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_OFFERS

Line 1739: FROM ozf_offers

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

Line 1953: FROM ozf_offers

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

Line 2287: FROM ozf_offers

2283: WHERE activity_budget_id = p_actbudget_id;
2284:
2285: CURSOR c_get_offer_type IS
2286: SELECT offer_type
2287: FROM ozf_offers
2288: WHERE qp_list_header_id = p_object_id;
2289:
2290: BEGIN
2291:

Line 2444: FROM ozf_offers

2440: l_msg_data VARCHAR2(2000) := NULL;
2441:
2442: CURSOR c_get_offer_type IS
2443: SELECT offer_type
2444: FROM ozf_offers
2445: WHERE qp_list_header_id = p_object_id;
2446:
2447: BEGIN
2448:

Line 2818: FROM ozf_offers

2814: WHERE schedule_id=p_object_id;
2815: ELSIF p_object_type = 'OFFR' THEN
2816: OPEN l_obj_details FOR
2817: SELECT budget_amount_tc,owner_id
2818: FROM ozf_offers
2819: WHERE qp_list_header_id=p_object_id;
2820: ELSIF p_object_type = 'EVEH' THEN
2821: OPEN l_obj_details FOR
2822: SELECT fund_amount_tc,owner_user_id

Line 2957: FROM ozf_offers , qp_list_headers qph

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

Line 3305: UPDATE ozf_offers

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

Line 3457: FROM ozf_offers

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