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

3195: IS
3196:
3197: CURSOR c_creation_date(l_list_header_id NUMBER) IS
3198: SELECT TRUNC(creation_date)
3199: FROM qp_list_headers
3200: WHERE list_header_id = l_list_header_id;
3201:
3202: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Offer_Dates';
3203: l_api_version CONSTANT NUMBER := 1.0;

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 4479: FROM qp_list_headers_all_b hdr

4475: WHERE limit_id = p_limit_id;
4476:
4477: CURSOR get_offer_info_frm_hdr(l_list_hdr_id NUMBER) IS
4478: SELECT hdr.orig_org_id, hdr.global_flag
4479: FROM qp_list_headers_all_b hdr
4480: WHERE hdr.list_header_id = l_list_hdr_id;
4481:
4482: l_org_id NUMBER := FND_API.G_MISS_NUM;
4483: l_global_flag VARCHAR2(5) := FND_API.G_MISS_CHAR;

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