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 DUAL

Line 1164: FROM DUAL;

1160: ,x_new_line_id OUT NOCOPY NUMBER)
1161: IS
1162: CURSOR c_new_line_id IS
1163: SELECT ozf_offer_discount_lines_s.NEXTVAL
1164: FROM DUAL;
1165:
1166: CURSOR c_line_id_exists(l_id NUMBER) IS
1167: SELECT 1
1168: FROM DUAL

Line 1168: FROM DUAL

1164: FROM DUAL;
1165:
1166: CURSOR c_line_id_exists(l_id NUMBER) IS
1167: SELECT 1
1168: FROM DUAL
1169: WHERE EXISTS (SELECT 1
1170: FROM ozf_offer_discount_lines
1171: WHERE offer_discount_line_id = l_id);
1172:

Line 1268: FROM DUAL;

1264: ,x_new_prod_id OUT NOCOPY NUMBER)
1265: IS
1266: CURSOR c_new_prod_id IS
1267: SELECT ozf_offer_discount_products_s.NEXTVAL
1268: FROM DUAL;
1269:
1270: CURSOR c_prod_id_exists(l_id NUMBER) IS
1271: SELECT 1
1272: FROM DUAL

Line 1272: FROM DUAL

1268: FROM DUAL;
1269:
1270: CURSOR c_prod_id_exists(l_id NUMBER) IS
1271: SELECT 1
1272: FROM DUAL
1273: WHERE EXISTS (SELECT 1
1274: FROM ozf_offer_discount_products
1275: WHERE off_discount_product_id = l_id);
1276:

Line 1452: FROM DUAL;

1448: ,p_new_offer_id IN NUMBER)
1449: IS
1450: CURSOR c_new_qual_id IS
1451: SELECT ozf_offer_qualifiers_s.NEXTVAL
1452: FROM DUAL;
1453:
1454: CURSOR c_qual_id_exists(l_id NUMBER) IS
1455: SELECT 1
1456: FROM DUAL

Line 1456: FROM DUAL

1452: FROM DUAL;
1453:
1454: CURSOR c_qual_id_exists(l_id NUMBER) IS
1455: SELECT 1
1456: FROM DUAL
1457: WHERE EXISTS (SELECT 1
1458: FROM ozf_offer_qualifiers
1459: WHERE qualifier_id = l_id);
1460:

Line 1628: FROM DUAL

1624: l_offer_rec c_offer_detail%ROWTYPE;
1625:
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:

Line 1635: FROM DUAL

1631: WHERE offer_code = l_code);
1632:
1633: CURSOR c_count_qp_code(l_code VARCHAR2) IS
1634: SELECT 1
1635: FROM DUAL
1636: WHERE EXISTS (SELECT 1
1637: FROM qp_list_headers_tl -- Bug 13360969 changed table name
1638: WHERE name = l_code);
1639:

Line 1647: FROM DUAL;

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
1651: FROM DUAL

Line 1651: FROM DUAL

1647: FROM DUAL;
1648:
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:

Line 1658: FROM DUAL;

1654: WHERE offer_id = l_id);
1655:
1656: CURSOR c_new_limit_id IS
1657: SELECT qp_limits_s.NEXTVAL
1658: FROM DUAL;
1659:
1660: CURSOR c_limit_id_exists (l_id IN NUMBER) IS
1661: SELECT 1
1662: FROM DUAL

Line 1662: FROM DUAL

1658: FROM DUAL;
1659:
1660: CURSOR c_limit_id_exists (l_id IN NUMBER) IS
1661: SELECT 1
1662: FROM DUAL
1663: WHERE EXISTS (SELECT 1
1664: FROM qp_limits
1665: WHERE limit_id = l_id);
1666: