APPS.OZF_OFFER_PVT dependencies on QP_LIST_HEADERS_B

Line 3869: FROM qp_list_headers_b q, ozf_offers o

3865: WHERE qp_list_header_id = p_qp_list_header_id;
3866:
3867: CURSOR c_offer_start_date(p_list_header_id NUMBER) IS
3868: SELECT q.start_date_active, o.start_date
3869: FROM qp_list_headers_b q, ozf_offers o
3870: WHERE o.qp_list_header_id = q.list_header_id
3871: AND q.list_header_id = p_list_header_id;
3872:
3873: -- nepanda : start : fix for bug 8507709 : added cursor to find out if data is already there in qp_list_line table for an offer

Line 4109: UPDATE qp_list_headers_b

4105: WHERE request_header_id = l_sdr_req_header_id;
4106: END IF;
4107:
4108: IF p_offer_rec.offer_type NOT IN('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
4109: UPDATE qp_list_headers_b
4110: SET active_flag = 'Y'
4111: WHERE list_header_id = p_offer_rec.qp_list_header_id;
4112:
4113: UPDATE qp_qualifiers

Line 6113: FROM qp_list_headers_b

6109:
6110:
6111: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
6112: SELECT start_date_active, end_date_active
6113: FROM qp_list_headers_b
6114: WHERE list_header_id = p_list_header_id;
6115:
6116: l_end_date date;
6117: l_start_date DATE;

Line 6928: UPDATE qp_list_headers_b

6924: END IF;
6925: */
6926: IF l_amount_error = 'N' THEN -- update qp to active only when validation passes
6927: IF l_offer_rec.offer_type NOT IN('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
6928: UPDATE qp_list_headers_b
6929: SET active_flag = 'Y'
6930: WHERE list_header_id = p_qp_list_header_id;
6931:
6932: UPDATE qp_qualifiers

Line 7008: FROM qp_list_headers_b

7004:
7005:
7006: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
7007: SELECT start_date_active, end_date_active
7008: FROM qp_list_headers_b
7009: WHERE list_header_id = p_list_header_id;
7010:
7011: l_discount_level VARCHAR2(30);
7012: l_order_value_discount_type VARCHAR2(30);

Line 7612: FROM qp_list_headers_b

7608: WHERE qp_list_header_id = l_list_header_id;
7609:
7610: CURSOR cur_get_offer_enddate(p_list_header_id NUMBER) IS
7611: SELECT start_date_active, end_date_active
7612: FROM qp_list_headers_b
7613: WHERE list_header_id = p_list_header_id;
7614:
7615: l_break_type VARCHAR2(30);
7616: l_end_date DATE;

Line 9064: FROM qp_list_headers_b q, ozf_offers o

9060: IS
9061:
9062: CURSOR c_offer_start_date(p_list_header_id NUMBER) IS
9063: SELECT q.start_date_active, o.start_date
9064: FROM qp_list_headers_b q, ozf_offers o
9065: WHERE o.qp_list_header_id = q.list_header_id
9066: AND q.list_header_id = p_list_header_id;
9067:
9068: l_start_date_q DATE;

Line 9102: UPDATE qp_list_headers_b

9098: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
9099:
9100: IF p_modifier_list_rec.status_code = 'ACTIVE'
9101: AND p_modifier_list_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA', 'NET_ACCRUAL') THEN
9102: UPDATE qp_list_headers_b
9103: SET active_flag = 'Y'
9104: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
9105: -- Forward port bug 3143594. 11i.10 bug is 3614058
9106: UPDATE qp_qualifiers