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_COPY_OFFER_PVT dependencies on OZF_OFFERS

Line 447: SELECT offer_id FROM ozf_offers

443: AND c.language = USERENV('LANG')
444: AND a.offer_id = cp_offerId;
445:
446: CURSOR c_offerId(cp_listHeaderId NUMBER) IS
447: SELECT offer_id FROM ozf_offers
448: WHERE qp_list_header_id = cp_listHeaderId;
449: l_sourceOfferId NUMBER := null;
450: BEGIN
451: -- initialize

Line 708: FROM ozf_offers a, qp_list_headers_all b

704: , b.attribute12
705: , b.attribute13
706: , b.attribute14
707: , b.attribute15
708: FROM ozf_offers a, qp_list_headers_all b
709: WHERE a.qp_list_header_id = b.list_header_id
710: AND a.qp_list_header_id = p_listHeaderId;
711:
712: CURSOR c_offerId (cp_listHeaderId NUMBER) IS

Line 713: SELECT offer_id FROM ozf_offers

709: WHERE a.qp_list_header_id = b.list_header_id
710: AND a.qp_list_header_id = p_listHeaderId;
711:
712: CURSOR c_offerId (cp_listHeaderId NUMBER) IS
713: SELECT offer_id FROM ozf_offers
714: WHERE qp_list_header_id = cp_listHeaderId ;
715:
716: --rvkondur Bug#12888855
717: CURSOR c_funds_all_details(l_fund_id VARCHAR2) IS

Line 1345: FROM ozf_offers

1341: CURSOR c_parent_lines IS
1342: SELECT offer_discount_line_id
1343: FROM ozf_offer_discount_lines
1344: WHERE offer_id = (SELECT offer_id
1345: FROM ozf_offers
1346: WHERE qp_list_header_id = p_source_object_id)
1347: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl
1348:
1349: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS

Line 1353: FROM ozf_offers

1349: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS
1350: SELECT offer_discount_line_id
1351: FROM ozf_offer_discount_lines
1352: WHERE offer_id = (SELECT offer_id
1353: FROM ozf_offers
1354: WHERE qp_list_header_id = p_source_object_id)
1355: AND parent_discount_line_id = p_parent_line_id;
1356:
1357: CURSOR c_product_id(p_line_id NUMBER) IS

Line 1400: FROM ozf_offers

1396: CURSOR c_line_tiers IS
1397: SELECT offer_discount_line_id
1398: FROM ozf_offer_discount_lines
1399: WHERE offer_id = (SELECT offer_id
1400: FROM ozf_offers
1401: WHERE qp_list_header_id = p_source_object_id);
1402:
1403: CURSOR c_parent_products IS
1404: SELECT off_discount_product_id

Line 1407: FROM ozf_offers

1403: CURSOR c_parent_products IS
1404: SELECT off_discount_product_id
1405: FROM ozf_offer_discount_products
1406: WHERE offer_id = (SELECT offer_id
1407: FROM ozf_offers
1408: WHERE qp_list_header_id = p_source_object_id)
1409: AND parent_off_disc_prod_id IS NULL;
1410:
1411: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS

Line 1415: FROM ozf_offers

1411: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS
1412: SELECT off_discount_product_id
1413: FROM ozf_offer_discount_products
1414: WHERE offer_id = (SELECT offer_id
1415: FROM ozf_offers
1416: WHERE qp_list_header_id = p_source_object_id)
1417: AND parent_off_disc_prod_id = p_parent_prod_id;
1418:
1419: l_new_prod_id NUMBER;

Line 1465: FROM ozf_offers

1461: CURSOR c_market_elig IS
1462: SELECT *
1463: FROM ozf_offer_qualifiers
1464: WHERE offer_id = (SELECT offer_id
1465: FROM ozf_offers
1466: WHERE qp_list_header_id = p_source_object_id);
1467:
1468: l_new_qual_id NUMBER;
1469: l_count NUMBER;

Line 1622: FROM ozf_offers

1618: l_list_header_rec c_list_header_detail%ROWTYPE;
1619:
1620: CURSOR c_offer_detail IS
1621: SELECT *
1622: FROM ozf_offers
1623: WHERE qp_list_header_id = p_source_object_id;
1624: l_offer_rec c_offer_detail%ROWTYPE;
1625:
1626: CURSOR c_count_ozf_code(l_code VARCHAR2) IS

Line 1630: FROM ozf_offers

1626: CURSOR c_count_ozf_code(l_code VARCHAR2) IS
1627: SELECT 1
1628: FROM DUAL
1629: WHERE EXISTS (SELECT 1
1630: FROM ozf_offers
1631: WHERE offer_code = l_code);
1632:
1633: CURSOR c_count_qp_code(l_code VARCHAR2) IS
1634: SELECT 1

Line 1646: SELECT ozf_offers_s.NEXTVAL

1642: FROM qp_list_headers_tl -- Bug 13360969 changed table name to fetch list_header_id, fetching of list_header_id was not consisitent with qp_list_headers
1643: WHERE name = l_name;
1644:
1645: CURSOR c_new_offer_id IS
1646: SELECT ozf_offers_s.NEXTVAL
1647: FROM DUAL;
1648:
1649: CURSOR c_offer_id_exists (l_id IN NUMBER) IS
1650: SELECT 1

Line 1653: FROM ozf_offers

1649: CURSOR c_offer_id_exists (l_id IN NUMBER) IS
1650: SELECT 1
1651: FROM DUAL
1652: WHERE EXISTS (SELECT 1
1653: FROM ozf_offers
1654: WHERE offer_id = l_id);
1655:
1656: CURSOR c_new_limit_id IS
1657: SELECT qp_limits_s.NEXTVAL

Line 1914: -- insert into ozf_offers

1910: UPDATE qp_list_headers_b
1911: SET comments = l_modifier_list_rec.comments
1912: WHERE list_header_id = l_offer_rec.qp_list_header_id;
1913:
1914: -- insert into ozf_offers
1915: LOOP
1916: l_dummy := NULL;
1917: OPEN c_new_offer_id;
1918: FETCH c_new_offer_id INTO l_offer_rec.offer_id;

Line 1941: INSERT INTO ozf_offers

1937: l_budget_source_type := null;
1938: l_budget_source_id := null;
1939: END IF;
1940:
1941: INSERT INTO ozf_offers
1942: (offer_id
1943: ,qp_list_header_id
1944: ,offer_type
1945: ,offer_code

Line 2055: -- end insert into ozf_offers

2051: ,l_offer_rec.beneficiary_account_id
2052: ,l_offer_rec.sales_method_flag
2053: ,l_offer_rec.org_id
2054: ,NVL(l_offer_rec.transaction_currency_code, fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')));
2055: -- end insert into ozf_offers
2056:
2057: --7627663,insert the offer details to AMS_SOURCE_CODES for all offers except volume offer.
2058: AMS_CampaignRules_PVT.push_source_code(
2059: l_offer_rec.offer_code,

Line 2851: FROM ozf_offers

2847: x_custom_setup_id OUT NOCOPY NUMBER)
2848: IS
2849: CURSOR c_budget_offer_yn IS
2850: SELECT budget_offer_yn, offer_type, custom_setup_id
2851: FROM ozf_offers
2852: WHERE qp_list_header_id = p_source_object_id;
2853:
2854: l_budget_offer_yn VARCHAR2(1);
2855: l_offer_type VARCHAR2(30);