APPS.OZF_COPY_OFFER_PVT dependencies on QP_LIST_HEADERS

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 1584: FROM qp_list_headers

1580: l_default_team NUMBER;
1581:
1582: CURSOR c_list_header_detail IS
1583: SELECT *
1584: FROM qp_list_headers
1585: WHERE list_header_id = p_source_object_id;
1586: l_list_header_rec c_list_header_detail%ROWTYPE;
1587:
1588: CURSOR c_offer_detail IS

Line 1605: FROM qp_list_headers

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:
1608: CURSOR c_get_list_header_id(l_name VARCHAR2) IS
1609: SELECT list_header_id

Line 1610: FROM qp_list_headers

1606: WHERE name = l_code);
1607:
1608: CURSOR c_get_list_header_id(l_name VARCHAR2) IS
1609: SELECT list_header_id
1610: FROM qp_list_headers
1611: WHERE name = l_name;
1612:
1613: CURSOR c_new_offer_id IS
1614: SELECT ozf_offers_s.NEXTVAL

Line 1860: UPDATE qp_list_headers_b

1856: FETCH c_get_list_header_id INTO l_offer_rec.qp_list_header_id;
1857: CLOSE c_get_list_header_id;
1858: --14-Jan-2003 JULOU Copy did not put the new description from the UI
1859: -- put description from UI
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