APPS.OZF_OFFER_PVT dependencies on QP_LIST_HEADERS_B

Line 3703: FROM qp_list_headers_b q, ozf_offers o

3699: WHERE qp_list_header_id = p_qp_list_header_id;
3700:
3701: CURSOR c_offer_start_date(p_list_header_id NUMBER) IS
3702: SELECT q.start_date_active, o.start_date
3703: FROM qp_list_headers_b q, ozf_offers o
3704: WHERE o.qp_list_header_id = q.list_header_id
3705: AND q.list_header_id = p_list_header_id;
3706:
3707: -- fix for bug 7004273 and 7201785

Line 3928: UPDATE qp_list_headers_b

3924: WHERE request_header_id = l_sdr_req_header_id;
3925: END IF;
3926:
3927: IF p_offer_rec.offer_type NOT IN('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
3928: UPDATE qp_list_headers_b
3929: SET active_flag = 'Y'
3930: WHERE list_header_id = p_offer_rec.qp_list_header_id;
3931:
3932: UPDATE qp_qualifiers

Line 5613: FROM qp_list_headers_b

5609:
5610:
5611: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
5612: SELECT start_date_active, end_date_active
5613: FROM qp_list_headers_b
5614: WHERE list_header_id = p_list_header_id;
5615:
5616: l_end_date date;
5617: l_start_date DATE;

Line 6398: UPDATE qp_list_headers_b

6394: END IF;
6395: */
6396: IF l_amount_error = 'N' THEN -- update qp to active only when validation passes
6397: IF l_offer_rec.offer_type NOT IN('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
6398: UPDATE qp_list_headers_b
6399: SET active_flag = 'Y'
6400: WHERE list_header_id = p_qp_list_header_id;
6401:
6402: UPDATE qp_qualifiers

Line 6478: FROM qp_list_headers_b

6474:
6475:
6476: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
6477: SELECT start_date_active, end_date_active
6478: FROM qp_list_headers_b
6479: WHERE list_header_id = p_list_header_id;
6480:
6481: l_discount_level VARCHAR2(30);
6482: l_order_value_discount_type VARCHAR2(30);

Line 7078: FROM qp_list_headers_b

7074: WHERE qp_list_header_id = l_list_header_id;
7075:
7076: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
7077: SELECT start_date_active, end_date_active
7078: FROM qp_list_headers_b
7079: WHERE list_header_id = p_list_header_id;
7080:
7081: l_break_type VARCHAR2(30);
7082: l_end_date DATE;

Line 8530: FROM qp_list_headers_b q, ozf_offers o

8526: IS
8527:
8528: CURSOR c_offer_start_date(p_list_header_id NUMBER) IS
8529: SELECT q.start_date_active, o.start_date
8530: FROM qp_list_headers_b q, ozf_offers o
8531: WHERE o.qp_list_header_id = q.list_header_id
8532: AND q.list_header_id = p_list_header_id;
8533:
8534: l_start_date_q DATE;

Line 8568: UPDATE qp_list_headers_b

8564: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
8565:
8566: IF p_modifier_list_rec.status_code = 'ACTIVE'
8567: AND p_modifier_list_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
8568: UPDATE qp_list_headers_b
8569: SET active_flag = 'Y'
8570: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
8571: -- Forward port bug 3143594. 11i.10 bug is 3614058
8572: UPDATE qp_qualifiers