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 702: FROM ozf_offers a, qp_list_headers_all b

698: , b.attribute12
699: , b.attribute13
700: , b.attribute14
701: , b.attribute15
702: FROM ozf_offers a, qp_list_headers_all b
703: WHERE a.qp_list_header_id = b.list_header_id
704: AND a.qp_list_header_id = p_listHeaderId;
705:
706: CURSOR c_offerId (cp_listHeaderId NUMBER) IS

Line 707: SELECT offer_id FROM ozf_offers

703: WHERE a.qp_list_header_id = b.list_header_id
704: AND a.qp_list_header_id = p_listHeaderId;
705:
706: CURSOR c_offerId (cp_listHeaderId NUMBER) IS
707: SELECT offer_id FROM ozf_offers
708: WHERE qp_list_header_id = cp_listHeaderId ;
709:
710: BEGIN
711: -- establish save point

Line 1318: FROM ozf_offers

1314: CURSOR c_parent_lines IS
1315: SELECT offer_discount_line_id
1316: FROM ozf_offer_discount_lines
1317: WHERE offer_id = (SELECT offer_id
1318: FROM ozf_offers
1319: WHERE qp_list_header_id = p_source_object_id)
1320: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl
1321:
1322: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS

Line 1326: FROM ozf_offers

1322: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS
1323: SELECT offer_discount_line_id
1324: FROM ozf_offer_discount_lines
1325: WHERE offer_id = (SELECT offer_id
1326: FROM ozf_offers
1327: WHERE qp_list_header_id = p_source_object_id)
1328: AND parent_discount_line_id = p_parent_line_id;
1329:
1330: CURSOR c_product_id(p_line_id NUMBER) IS

Line 1373: FROM ozf_offers

1369: CURSOR c_line_tiers IS
1370: SELECT offer_discount_line_id
1371: FROM ozf_offer_discount_lines
1372: WHERE offer_id = (SELECT offer_id
1373: FROM ozf_offers
1374: WHERE qp_list_header_id = p_source_object_id);
1375:
1376: CURSOR c_parent_products IS
1377: SELECT off_discount_product_id

Line 1380: FROM ozf_offers

1376: CURSOR c_parent_products IS
1377: SELECT off_discount_product_id
1378: FROM ozf_offer_discount_products
1379: WHERE offer_id = (SELECT offer_id
1380: FROM ozf_offers
1381: WHERE qp_list_header_id = p_source_object_id)
1382: AND parent_off_disc_prod_id IS NULL;
1383:
1384: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS

Line 1388: FROM ozf_offers

1384: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS
1385: SELECT off_discount_product_id
1386: FROM ozf_offer_discount_products
1387: WHERE offer_id = (SELECT offer_id
1388: FROM ozf_offers
1389: WHERE qp_list_header_id = p_source_object_id)
1390: AND parent_off_disc_prod_id = p_parent_prod_id;
1391:
1392: l_new_prod_id NUMBER;

Line 1438: FROM ozf_offers

1434: CURSOR c_market_elig IS
1435: SELECT *
1436: FROM ozf_offer_qualifiers
1437: WHERE offer_id = (SELECT offer_id
1438: FROM ozf_offers
1439: WHERE qp_list_header_id = p_source_object_id);
1440:
1441: l_new_qual_id NUMBER;
1442: l_count NUMBER;

Line 1590: FROM ozf_offers

1586: l_list_header_rec c_list_header_detail%ROWTYPE;
1587:
1588: CURSOR c_offer_detail IS
1589: SELECT *
1590: FROM ozf_offers
1591: WHERE qp_list_header_id = p_source_object_id;
1592: l_offer_rec c_offer_detail%ROWTYPE;
1593:
1594: CURSOR c_count_ozf_code(l_code VARCHAR2) IS

Line 1598: FROM ozf_offers

1594: CURSOR c_count_ozf_code(l_code VARCHAR2) IS
1595: SELECT 1
1596: FROM DUAL
1597: WHERE EXISTS (SELECT 1
1598: FROM ozf_offers
1599: WHERE offer_code = l_code);
1600:
1601: CURSOR c_count_qp_code(l_code VARCHAR2) IS
1602: SELECT 1

Line 1614: SELECT ozf_offers_s.NEXTVAL

1610: FROM qp_list_headers
1611: WHERE name = l_name;
1612:
1613: CURSOR c_new_offer_id IS
1614: SELECT ozf_offers_s.NEXTVAL
1615: FROM DUAL;
1616:
1617: CURSOR c_offer_id_exists (l_id IN NUMBER) IS
1618: SELECT 1

Line 1621: FROM ozf_offers

1617: CURSOR c_offer_id_exists (l_id IN NUMBER) IS
1618: SELECT 1
1619: FROM DUAL
1620: WHERE EXISTS (SELECT 1
1621: FROM ozf_offers
1622: WHERE offer_id = l_id);
1623:
1624: CURSOR c_new_limit_id IS
1625: SELECT qp_limits_s.NEXTVAL

Line 1864: -- insert into ozf_offers

1860: UPDATE qp_list_headers_b
1861: SET comments = l_modifier_list_rec.comments
1862: WHERE list_header_id = l_offer_rec.qp_list_header_id;
1863:
1864: -- insert into ozf_offers
1865: LOOP
1866: l_dummy := NULL;
1867: OPEN c_new_offer_id;
1868: FETCH c_new_offer_id INTO l_offer_rec.offer_id;

Line 1879: INSERT INTO ozf_offers

1875: END LOOP;
1876:
1877:
1878:
1879: INSERT INTO ozf_offers
1880: (offer_id
1881: ,qp_list_header_id
1882: ,offer_type
1883: ,offer_code

Line 1993: -- end insert into ozf_offers

1989: ,l_offer_rec.beneficiary_account_id
1990: ,l_offer_rec.sales_method_flag
1991: ,l_offer_rec.org_id
1992: ,NVL(l_offer_rec.transaction_currency_code, fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')));
1993: -- end insert into ozf_offers
1994:
1995: --7627663,insert the offer details to AMS_SOURCE_CODES for all offers except volume offer.
1996: AMS_CampaignRules_PVT.push_source_code(
1997: l_offer_rec.offer_code,

Line 2782: FROM ozf_offers

2778: x_custom_setup_id OUT NOCOPY NUMBER)
2779: IS
2780: CURSOR c_budget_offer_yn IS
2781: SELECT budget_offer_yn, offer_type, custom_setup_id
2782: FROM ozf_offers
2783: WHERE qp_list_header_id = p_source_object_id;
2784:
2785: l_budget_offer_yn VARCHAR2(1);
2786: l_offer_type VARCHAR2(30);