APPS.OZF_COPY_OFFER_PVT dependencies on QP_LIMITS

Line 1657: SELECT qp_limits_s.NEXTVAL

1653: FROM ozf_offers
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

Line 1664: FROM qp_limits

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:
1667: CURSOR c_related_deal_lines IS
1668: SELECT *

Line 1698: FROM qp_limits

1694: WHERE list_header_id = p_source_object_id;
1695:
1696: CURSOR c_line_limits IS
1697: SELECT *
1698: FROM qp_limits
1699: WHERE list_header_id = p_source_object_id
1700: ORDER BY list_line_id;
1701:
1702: CURSOR c_contact_point IS

Line 2218: INSERT INTO qp_limits

2214: CLOSE c_limit_id_exists;
2215: EXIT WHEN l_dummy IS NULL;
2216: END LOOP;
2217:
2218: INSERT INTO qp_limits
2219: (limit_id
2220: ,creation_date
2221: ,created_by
2222: ,last_update_date

Line 2341: INSERT INTO qp_limits

2337: CLOSE c_limit_id_exists;
2338: EXIT WHEN l_dummy IS NULL;
2339: END LOOP;
2340:
2341: INSERT INTO qp_limits
2342: (limit_id
2343: ,creation_date
2344: ,created_by
2345: ,last_update_date