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.QP_MODIFIER_UPGRADE_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 327: x_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;

323: v_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
324: x_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
325: v_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
326: v_price_break_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
327: x_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;
328: v_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;
329: x_operand QP_LIST_LINES.OPERAND%TYPE;
330: x_arithmetic_operator QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE;
331: x_qualifier_grouping_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE;

Line 328: v_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;

324: x_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
325: v_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
326: v_price_break_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
327: x_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;
328: v_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;
329: x_operand QP_LIST_LINES.OPERAND%TYPE;
330: x_arithmetic_operator QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE;
331: x_qualifier_grouping_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE;
332: v_qualifier_grouping_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE := 0;

Line 1035: -- Create a record in qp_pricing_attributes for ALL products and ALL pricing attributes only if

1031:
1032: Create_Discount_Mapping_Record(i.discount_id,NULL,v_list_header_id,v_list_line_id,null,'O',
1033: null,null,null,null,null,null);
1034:
1035: -- Create a record in qp_pricing_attributes for ALL products and ALL pricing attributes only if
1036: -- LINE LEVEL Discounts with no actual discount lines
1037: -- Added after discounts upgrade review with Jay and Alison
1038:
1039: IF (v_discount_level = G_LINE_LEVEL) THEN

Line 1808: -- If is a product then there will be only 1 record in qp_pricing_attributes with both

1804: 'DISCOUNTS',
1805: x_rltd_modifier_id);
1806:
1807:
1808: -- If is a product then there will be only 1 record in qp_pricing_attributes with both
1809: -- Product and Pricing info in 1 record
1810:
1811: IF (v_product_flag = TRUE ) THEN
1812:

Line 1845: -- This record the product record in qp_pricing_attributes for PBH Line(Parent Line)

1841: x_pricing_attribute_id);
1842: END IF; /* v_product_flag = TRUE */
1843:
1844: -- This record is needed , if this is a break on qualifier
1845: -- This record the product record in qp_pricing_attributes for PBH Line(Parent Line)
1846: -- Insert only 1 record
1847: IF (v_qualifier_flag = TRUE and v_break_count = 0 ) THEN
1848: -- Create the Product/Pricing Attribute
1849: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,

Line 1929: UPDATE QP_PRICING_ATTRIBUTES

1925: END LOOP; -- Price Break Lines Cursor
1926:
1927: -- Update the Unit Code on the PBH line(parent Line)
1928: -- makes PRICING_ATTRIBUTE10 to PRICING_ATTRIBUTE12(if needed)
1929: UPDATE QP_PRICING_ATTRIBUTES
1930: SET PRODUCT_UOM_CODE = v_unit_code,
1931: PRICING_ATTRIBUTE = v_price_break_attribute
1932: WHERE LIST_LINE_ID = v_list_line_id;
1933: v_break_count := 0; -- Re-init