eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PVT dependencies on QP_LIST_LINES

Line 63: -- 26-Nov-2002 RSSHARMA Added Flex Field to qp_list_lines

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
67: -- 26-DEC-2002 julou enhancement 2465253: added profile value for override flag.

Line 96: -- Wed Nov 26 2003:3/0 PM rssharma Made process_qp_list_lines public and added an out variable

92: -- populate IEB from cue card if offer is ACTIVE and IEB is null
93: -- Tue Jun 17 2003:2/47 PM RSSHARMA Changed procedure offer_dates. Create the Order and Ship
94: -- Dates with different Group Numbers
95: -- Tue Jul 15 2003:3/35 PM RSSHARMA Added AMOUNT as new Discount Type for Order Value Offers
96: -- Wed Nov 26 2003:3/0 PM rssharma Made process_qp_list_lines public and added an out variable
97: -- Mon Dec 01 2003:7/33 PM RSSHARMA Changed process_regular_discounts to allow creating inactive discount rules.
98: -- Tue Dec 02 2003:1/51 PM RSSHARMA Added Creating inactive discount rules for regular, Order Value , Promotional Goods Offers
99: -- And Skip Validation for minimum 1 discount line for an offer to become active for Soft Fund
100: -- with Custom Setup Id = 110

Line 136: -- DOnt push discount rules to qp if qp_list_lines already exist.

132: -- Thu Aug 19 1999:6/50 AM RSSHARMA Added process to relate ozf and qp discounts and products. Also changed signature of create_offer_tiers
133: -- Tue Sep 27 2005:7/30 PM RSSHARMA Pass end date properly for end dating Discount lines using adjustments.
134: -- issues with trade deal remain. Only one line is end dated
135: -- Wed Sep 28 2005:12/18 PM RSSHARMA Push Accum attribute47 to qp during volume Offer activation.
136: -- DOnt push discount rules to qp if qp_list_lines already exist.
137: -- Wed Sep 28 2005:6/2 PM RSSHARMA During Volume Offer Activation push formula into proper column(price_by_formula_id) in qp_list_lines
138: -- Thu Sep 29 2005:1/46 PM RSSHARMA Corrected Accum Attribute to PRICING_ATTRIBUTE19 from PRICING_ATTRIBUTE47
139: -- Sat Oct 01 2005:5/40 PM RSSHARMA Corrected Qualifier Attribute used for creating sales method Qualifier
140: -- Wed Oct 12 2005:11/47 AM RSSHARMA Added new method debug_message to add debug messages to fnd only if the profile FND: Message Level Threshold level is high.

Line 137: -- Wed Sep 28 2005:6/2 PM RSSHARMA During Volume Offer Activation push formula into proper column(price_by_formula_id) in qp_list_lines

133: -- Tue Sep 27 2005:7/30 PM RSSHARMA Pass end date properly for end dating Discount lines using adjustments.
134: -- issues with trade deal remain. Only one line is end dated
135: -- Wed Sep 28 2005:12/18 PM RSSHARMA Push Accum attribute47 to qp during volume Offer activation.
136: -- DOnt push discount rules to qp if qp_list_lines already exist.
137: -- Wed Sep 28 2005:6/2 PM RSSHARMA During Volume Offer Activation push formula into proper column(price_by_formula_id) in qp_list_lines
138: -- Thu Sep 29 2005:1/46 PM RSSHARMA Corrected Accum Attribute to PRICING_ATTRIBUTE19 from PRICING_ATTRIBUTE47
139: -- Sat Oct 01 2005:5/40 PM RSSHARMA Corrected Qualifier Attribute used for creating sales method Qualifier
140: -- Wed Oct 12 2005:11/47 AM RSSHARMA Added new method debug_message to add debug messages to fnd only if the profile FND: Message Level Threshold level is high.
141: -- Create a pbh line, with same tier but "0" discounts for volume offer products with apply_discount flag set to "NO"

Line 532: FROM qp_list_lines

528: )
529: IS
530: CURSOR cur_get_lines IS
531: SELECT list_line_id,modifier_level_code,price_break_type_code
532: FROM qp_list_lines
533: WHERE list_header_id = p_advanced_options_rec.list_header_id;
534:
535: -- bug 3435528 populate cust_account_id to beneficiary_account_id
536: CURSOR c_cust_account_id(p_site_use_id NUMBER, p_site_use_code VARCHAR2) IS

Line 749: FROM qp_list_lines

745: print_on_invoice_flag ,
746: pricing_phase_id ,
747: modifier_level_code ,
748: automatic_flag
749: FROM qp_list_lines
750: WHERE list_line_id = parent_list_line_id;
751:
752: CURSOR cur_get_prod_info( parent_list_line_id NUMBER) IS
753: SELECT product_attribute_context,

Line 5623: FROM qp_list_lines

5619: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
5620: SELECT 1
5621: FROM DUAL
5622: WHERE EXISTS (SELECT 1
5623: FROM qp_list_lines
5624: WHERE list_header_id = l_list_header_id);
5625:
5626: CURSOR c_adv_options(l_list_header_id NUMBER) IS
5627: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence

Line 5628: FROM qp_list_lines

5624: WHERE list_header_id = l_list_header_id);
5625:
5626: CURSOR c_adv_options(l_list_header_id NUMBER) IS
5627: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence
5628: FROM qp_list_lines
5629: WHERE list_header_id = l_list_header_id;
5630:
5631: l_adv_options_exist NUMBER;
5632:

Line 6490: FROM qp_list_lines

6486: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
6487: SELECT 1
6488: FROM DUAL
6489: WHERE EXISTS (SELECT 1
6490: FROM qp_list_lines
6491: WHERE list_header_id = l_list_header_id);
6492:
6493: CURSOR c_adv_options(l_list_header_id NUMBER) IS
6494: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence

Line 6495: FROM qp_list_lines

6491: WHERE list_header_id = l_list_header_id);
6492:
6493: CURSOR c_adv_options(l_list_header_id NUMBER) IS
6494: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence
6495: FROM qp_list_lines
6496: WHERE list_header_id = l_list_header_id;
6497:
6498: l_adv_options_exist NUMBER;
6499: l_override_flag VARCHAR2(1);

Line 7043: FROM qp_list_lines

7039: l_related_modifier_id NUMBER := 0;
7040:
7041: CURSOR cur_get_PRG_line_id(p_list_header_id NUMBER) IS
7042: SELECT list_line_id
7043: FROM qp_list_lines
7044: WHERE list_header_id = p_list_header_id
7045: AND list_line_type_code = 'PRG';
7046:
7047: l_use_modifier_index boolean;

Line 7061: FROM qp_list_lines

7057: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
7058: SELECT 1
7059: FROM DUAL
7060: WHERE EXISTS (SELECT 1
7061: FROM qp_list_lines
7062: WHERE list_header_id = l_list_header_id);
7063:
7064: CURSOR c_adv_options(l_list_header_id NUMBER) IS
7065: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence

Line 7066: FROM qp_list_lines

7062: WHERE list_header_id = l_list_header_id);
7063:
7064: CURSOR c_adv_options(l_list_header_id NUMBER) IS
7065: SELECT pricing_phase_id,print_on_invoice_flag,incompatibility_grp_code,pricing_group_sequence,product_precedence
7066: FROM qp_list_lines
7067: WHERE list_header_id = l_list_header_id;
7068:
7069: l_adv_options_exist NUMBER;
7070:

Line 8177: PROCEDURE process_qp_list_lines

8173: END LOOP;
8174: END IF;
8175: END validateQpListLines;
8176:
8177: PROCEDURE process_qp_list_lines
8178: (
8179: x_return_status OUT NOCOPY VARCHAR2
8180: ,x_msg_count OUT NOCOPY NUMBER
8181: ,x_msg_data OUT NOCOPY VARCHAR2

Line 8189: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';

8185: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
8186: ,x_error_location OUT NOCOPY NUMBER
8187: )IS
8188: l_api_version CONSTANT NUMBER := 1.0;
8189: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';
8190: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8191: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
8192: -- RSSHARMA changed on 06-Feb-2003
8193: CURSOR c_volume_offer_type IS

Line 8203: SAVEPOINT process_qp_list_lines;

8199: l_modifier_line_rec_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8200:
8201: BEGIN
8202:
8203: SAVEPOINT process_qp_list_lines;
8204:
8205: x_return_status := Fnd_Api.g_ret_sts_success;
8206: x_error_location := 0;
8207: validateQpListLines

Line 8301: ROLLBACK TO process_qp_list_lines;

8297: END IF;
8298: EXCEPTION
8299: WHEN Fnd_Api.G_EXC_ERROR THEN
8300: x_return_status := Fnd_Api.g_ret_sts_error ;
8301: ROLLBACK TO process_qp_list_lines;
8302: Fnd_Msg_Pub.Count_AND_Get
8303: ( p_count => x_msg_count,
8304: p_data => x_msg_data,
8305: p_encoded => Fnd_Api.G_FALSE

Line 8309: ROLLBACK TO process_qp_list_lines;

8305: p_encoded => Fnd_Api.G_FALSE
8306: );
8307: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
8308: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
8309: ROLLBACK TO process_qp_list_lines;
8310: Fnd_Msg_Pub.Count_AND_Get
8311: ( p_count => x_msg_count,
8312: p_data => x_msg_data,
8313: p_encoded => Fnd_Api.G_FALSE

Line 8317: ROLLBACK TO process_qp_list_lines;

8313: p_encoded => Fnd_Api.G_FALSE
8314: );
8315: WHEN OTHERS THEN
8316: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
8317: ROLLBACK TO process_qp_list_lines;
8318: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
8319: THEN
8320: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8321: END IF;

Line 8456: FROM qp_list_lines

8452: IS
8453: l_lines_count NUMBER := 0;
8454: CURSOR c_list_line(l_list_header_id NUMBER) IS
8455: SELECT COUNT(*)
8456: FROM qp_list_lines
8457: WHERE list_header_id = l_list_header_id
8458: AND decode(greatest(end_date_active, sysdate), sysdate,'N','Y') = 'Y';
8459:
8460: CURSOR c_offerType(cp_listHeaderId NUMBER) IS

Line 8734: FROM qp_list_lines

8730: AND act_product_used_by_id = p_modifier_list_rec.qp_list_header_id;
8731:
8732: CURSOR c_list_line IS
8733: SELECT COUNT(*)
8734: FROM qp_list_lines
8735: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
8736:
8737: CURSOR c_na_line IS
8738: SELECT COUNT(*)

Line 8745: FROM qp_list_lines

8741: (SELECT offer_id FROM ozf_offers WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id);
8742:
8743: CURSOR c_prg_buy_count IS
8744: SELECT COUNT(*)
8745: FROM qp_list_lines
8746: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id
8747: AND TRUNC(SYSDATE) <= TRUNC(NVL(end_date_active, SYSDATE))
8748: AND list_line_type_code = 'PRG';
8749:

Line 8752: FROM qp_list_lines

8748: AND list_line_type_code = 'PRG';
8749:
8750: CURSOR c_prg_get_count IS
8751: SELECT COUNT(*)
8752: FROM qp_list_lines
8753: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id
8754: AND TRUNC(SYSDATE) <= TRUNC(NVL(end_date_active, SYSDATE))
8755: AND list_line_type_code = 'DIS';
8756:

Line 9607: process_qp_list_lines

9603:
9604: END IF;
9605: debug_message('p_modifier_line_tbl.COUNT :'|| p_modifier_line_tbl.COUNT);
9606: IF p_modifier_line_tbl.COUNT > 0 THEN
9607: process_qp_list_lines
9608: (
9609: x_return_status => x_return_status,
9610: x_msg_count => x_msg_count,
9611: x_msg_data => x_msg_data,

Line 9618: debug_message('process_qp_list_lines x_return_status '||x_return_status);

9614: p_list_header_id => temp_modifier_list_rec.qp_list_header_id,
9615: x_modifier_line_tbl => v_modifier_line_tbl,
9616: x_error_location => x_error_location
9617: );
9618: debug_message('process_qp_list_lines x_return_status '||x_return_status);
9619: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
9620: RAISE Fnd_Api.g_exc_error;
9621: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
9622: RAISE Fnd_Api.g_exc_unexpected_error;

Line 9693: relations for discounts(ozf_discount_lines and qp_list_lines) are stored only if the OZF Products that have apply discount = y.

9689:
9690: /*
9691: LOgic for buliding relations
9692: 1. Discounts
9693: relations for discounts(ozf_discount_lines and qp_list_lines) are stored only if the OZF Products that have apply discount = y.
9694:
9695: If the OZF Product has apply discount = n (which may be a discount or an exclusion) and is not an exclusion
9696: then a single qp discount line with list line type code DIS and 0% discount is created.
9697: -- This line can be related to the ozf_product since the ozf product in this case has a one to one relation with qp pricing attribute.

Line 10746: columns in tables qp_list_lines and qp_pricing_attributes

10742:
10743: /*
10744: This procedure creates SD offer discount line records.
10745: The mapping b/w QP and SDR lines is stored in orig_sys_line_ref and orig_sys_header_ref
10746: columns in tables qp_list_lines and qp_pricing_attributes
10747: */
10748:
10749: PROCEDURE populateSDDiscountRulesRec(
10750: x_return_status OUT NOCOPY VARCHAR2

Line 10792: FROM qp_list_lines

10788: AND vendor_approved_flag='Y';
10789:
10790: CURSOR cur_get_sys_line_ref_id(p_request_line_id NUMBER,p_qp_list_header_id NUMBER) IS
10791: SELECT list_line_no,list_line_id
10792: FROM qp_list_lines
10793: WHERE list_line_no = to_char(p_request_line_id)
10794: AND list_header_id = p_qp_list_header_id ;
10795:
10796: CURSOR cur_get_header_info IS