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

1133: ,x_new_line_id OUT NOCOPY NUMBER)
1134: IS
1135: CURSOR c_new_line_id IS
1136: SELECT ozf_offer_discount_lines_s.NEXTVAL
1137: FROM DUAL;
1138:
1139: CURSOR c_line_id_exists(l_id NUMBER) IS
1140: SELECT 1
1141: FROM DUAL

Line 1141: FROM DUAL

1137: FROM DUAL;
1138:
1139: CURSOR c_line_id_exists(l_id NUMBER) IS
1140: SELECT 1
1141: FROM DUAL
1142: WHERE EXISTS (SELECT 1
1143: FROM ozf_offer_discount_lines
1144: WHERE offer_discount_line_id = l_id);
1145:

Line 1241: FROM DUAL;

1237: ,x_new_prod_id OUT NOCOPY NUMBER)
1238: IS
1239: CURSOR c_new_prod_id IS
1240: SELECT ozf_offer_discount_products_s.NEXTVAL
1241: FROM DUAL;
1242:
1243: CURSOR c_prod_id_exists(l_id NUMBER) IS
1244: SELECT 1
1245: FROM DUAL

Line 1245: FROM DUAL

1241: FROM DUAL;
1242:
1243: CURSOR c_prod_id_exists(l_id NUMBER) IS
1244: SELECT 1
1245: FROM DUAL
1246: WHERE EXISTS (SELECT 1
1247: FROM ozf_offer_discount_products
1248: WHERE off_discount_product_id = l_id);
1249:

Line 1425: FROM DUAL;

1421: ,p_new_offer_id IN NUMBER)
1422: IS
1423: CURSOR c_new_qual_id IS
1424: SELECT ozf_offer_qualifiers_s.NEXTVAL
1425: FROM DUAL;
1426:
1427: CURSOR c_qual_id_exists(l_id NUMBER) IS
1428: SELECT 1
1429: FROM DUAL

Line 1429: FROM DUAL

1425: FROM DUAL;
1426:
1427: CURSOR c_qual_id_exists(l_id NUMBER) IS
1428: SELECT 1
1429: FROM DUAL
1430: WHERE EXISTS (SELECT 1
1431: FROM ozf_offer_qualifiers
1432: WHERE qualifier_id = l_id);
1433:

Line 1596: FROM DUAL

1592: l_offer_rec c_offer_detail%ROWTYPE;
1593:
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:

Line 1603: FROM DUAL

1599: WHERE offer_code = l_code);
1600:
1601: CURSOR c_count_qp_code(l_code VARCHAR2) IS
1602: SELECT 1
1603: FROM DUAL
1604: WHERE EXISTS (SELECT 1
1605: FROM qp_list_headers
1606: WHERE name = l_code);
1607:

Line 1615: FROM DUAL;

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

Line 1619: FROM DUAL

1615: FROM DUAL;
1616:
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:

Line 1626: FROM DUAL;

1622: WHERE offer_id = l_id);
1623:
1624: CURSOR c_new_limit_id IS
1625: SELECT qp_limits_s.NEXTVAL
1626: FROM DUAL;
1627:
1628: CURSOR c_limit_id_exists (l_id IN NUMBER) IS
1629: SELECT 1
1630: FROM DUAL

Line 1630: FROM DUAL

1626: FROM DUAL;
1627:
1628: CURSOR c_limit_id_exists (l_id IN NUMBER) IS
1629: SELECT 1
1630: FROM DUAL
1631: WHERE EXISTS (SELECT 1
1632: FROM qp_limits
1633: WHERE limit_id = l_id);
1634: