APPS.OZF_OFFER_PVT dependencies on QP_LIST_HEADERS

Line 62: -- 15-Nov-2002 RSSHARNA Added Flex Fields to QP_List_headers

58: -- is in PENDING_ACTIVE. Changed the order of updating and posting
59: -- LUMPSUM/SCAN_DATA
60: -- 01-NOV-2002 julou pass list_header_id to qualifiers tbl to fix copy API not copying
61: -- order_value_from and order_value_to.
62: -- 15-Nov-2002 RSSHARNA Added Flex Fields to QP_List_headers
63: -- 26-Nov-2002 RSSHARMA Added Flex Field to qp_list_lines
64: -- 12-DEC-2002 julou 1. parent as budget source update issue and creating budget request
65: -- 2. activation issue with LUMPSUM and SCAN_DATA offers
66: -- moved update after posting offers

Line 71: -- 30-JAN-2003 julou changed process_qp_list_headers. if offer is updated from

67: -- 26-DEC-2002 julou enhancement 2465253: added profile value for override flag.
68: -- 06-Jan-2003 rssharma Fixed issue where status code is set to null
69: -- if the user status id is missing
70: -- 09-JAN-2003 julou fixed accrual_flag for multi-tier Accrual offers
71: -- 30-JAN-2003 julou changed process_qp_list_headers. if offer is updated from
72: -- PROGRAM(offer_operation is null) populated active_flag as whatever parsed in.
73: -- 03-Feb-2003 RSSHARMA Added Function discount_lines_exist to check if active discount rules exist for an offer
74: -- this function is required by budgets team
75: -- 06-Feb-2003 RSSHARMA Fixed Bug # 2783888 .Added code for receiving Volume Offer Lines

Line 3034: FROM qp_list_headers

3030: IS
3031:
3032: CURSOR c_creation_date(l_list_header_id NUMBER) IS
3033: SELECT TRUNC(creation_date)
3034: FROM qp_list_headers
3035: WHERE list_header_id = l_list_header_id;
3036:
3037: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Offer_Dates';
3038: l_api_version CONSTANT NUMBER := 1.0;

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