eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFERS

Line 484: FROM ozf_offers

480:
481: CURSOR c_offer_info IS
482: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
483: , beneficiary_account_id,autopay_party_attr,autopay_party_id -- Added for bug 7030415, correct org_id in accrual records
484: FROM ozf_offers
485: WHERE qp_list_header_id = p_list_header_id;
486:
487: CURSOR c_cust_number (p_header_id IN NUMBER) IS
488: SELECT cust.cust_account_id

Line 552: FROM ozf_offers

548: WHERE site_use_id = p_site_use_id;
549:
550: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
551: SELECT autopay_party_attr,autopay_party_id
552: FROM ozf_offers
553: WHERE qp_list_header_id = p_offer_id;
554:
555: l_offer_info c_offer_info%ROWTYPE;
556:

Line 939: FROM ozf_offers

935:
936: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
937: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
938: , beneficiary_account_id, offer_id
939: FROM ozf_offers
940: WHERE qp_list_header_id = p_list_header_id;
941:
942: CURSOR c_cust_number (p_header_id IN NUMBER) IS
943: SELECT cust.cust_account_id

Line 1751: FROM qp_list_headers_all qp, ozf_offers off

1747: off.reusable, off.offer_type,
1748: --kdass 09-DEC-2005 fix for bug 4872799
1749: trunc(off.start_date) start_date
1750: ,off.volume_offer_type
1751: FROM qp_list_headers_all qp, ozf_offers off
1752: WHERE qp.list_header_id = p_list_header_id
1753: AND qp.list_header_id = off.qp_list_header_id;
1754:
1755: l_offer_info c_offer_info%ROWTYPE;

Line 2514: FROM ozf_offers

2510: CURSOR c_offer_info IS
2511: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code,
2512: reusable,
2513: offer_type
2514: FROM ozf_offers
2515: WHERE qp_list_header_id = p_qp_list_header_id;
2516:
2517: -- added by feliu to fix bug 4451500 and 4015372.
2518: CURSOR c_adj_amount(p_utilization_id IN NUMBER) IS

Line 2936: FROM ozf_offers

2932: IS
2933:
2934: CURSOR c_volume_off IS
2935: SELECT qp_list_header_id, volume_offer_type
2936: FROM ozf_offers
2937: WHERE offer_type = 'VOLUME_OFFER'
2938: AND status_code = 'ACTIVE';
2939:
2940: l_api_name CONSTANT VARCHAR2(30) := 'adjust_volume_offer';

Line 2947: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;

2943: l_return_status VARCHAR2 (20);
2944: l_msg_count NUMBER;
2945: l_msg_data VARCHAR2 (2000) := NULL;
2946:
2947: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
2948: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;
2949:
2950: l_qpListHeaderIdTbl qpListHeaderIdTbl;
2951: l_volumeOfferTypeTbl volumeOfferTypeTbl;

Line 2948: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;

2944: l_msg_count NUMBER;
2945: l_msg_data VARCHAR2 (2000) := NULL;
2946:
2947: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
2948: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;
2949:
2950: l_qpListHeaderIdTbl qpListHeaderIdTbl;
2951: l_volumeOfferTypeTbl volumeOfferTypeTbl;
2952:

Line 3107: FROM qp_list_headers_vl qp, ozf_offers ofr

3103:
3104: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
3105: ----- fix bug 5675871
3106: SELECT qp.description, qp.name ,nvl(ofr.transaction_currency_code, ofr.fund_request_curr_code)
3107: FROM qp_list_headers_vl qp, ozf_offers ofr
3108: WHERE qp.list_header_id = p_list_header_id
3109: AND qp.list_header_id = ofr.qp_list_header_id;
3110: /*
3111: SELECT description, name ,currency_code

Line 3565: FROM ozf_offers

3561: WHERE qp_list_header_id = p_list_header_id;
3562:
3563: CURSOR c_offer_curr IS
3564: SELECT nvl(transaction_currency_code,fund_request_curr_code)
3565: FROM ozf_offers
3566: WHERE qp_list_header_id = p_list_header_id;
3567:
3568: l_volume_type VARCHAR2(30);
3569: l_offer_curr VARCHAR2(30);

Line 3884: FROM ozf_offers

3880: AND parent_discount_line_id = p_parent_discount_id;
3881:
3882: CURSOR c_offer_curr IS
3883: SELECT nvl(transaction_currency_code,fund_request_curr_code), offer_id
3884: FROM ozf_offers
3885: WHERE qp_list_header_id = p_qp_list_header_id;
3886:
3887: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
3888: --fix for bug 5979971

Line 4703: FROM ozf_offers

4699: AND line.resale_line_id = adj.resale_line_id;
4700:
4701: CURSOR c_offer_curr IS
4702: SELECT nvl(transaction_currency_code,fund_request_curr_code), offer_id
4703: FROM ozf_offers
4704: WHERE qp_list_header_id = p_qp_list_header_id;
4705:
4706: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
4707: --fix for bug 5979971

Line 4717: FROM ozf_offers

4713:
4714: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
4715: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
4716: , beneficiary_account_id, offer_id
4717: FROM ozf_offers
4718: WHERE qp_list_header_id = p_list_header_id;
4719:
4720: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
4721: SELECT invoice_to_org_id, ship_to_org_id