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_LIST_LINES

Line 324: x_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;

320:
321:
322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_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;

Line 325: v_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;

321:
322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_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;

Line 326: v_price_break_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;

322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_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;

Line 329: x_operand QP_LIST_LINES.OPERAND%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;
333: v_cust_qualifier_grp_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE := 0;

Line 330: x_arithmetic_operator QP_LIST_LINES.ARITHMETIC_OPERATOR%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;
333: v_cust_qualifier_grp_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE := 0;
334: v_context VARCHAR2(30);

Line 936: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount columns

932:
933: IF (are_there_discount_lines = 'N' ) THEN /* Order Level Discount */
934:
935:
936: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount columns
937: -- in so_discounts table
938:
939: Get_Percent(i.percent , i.amount , 0 , x_operand , x_arithmetic_operator);
940:

Line 1150: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount

1146: -- If percent and amount and price is null , then it is a price break.
1147: -- Ex ecute this logic only if it is a product or qualifier. This is because we are not dealing
1148: -- with any entities other than those handled in Get_Context_Attributes procedure
1149:
1150: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount
1151: Get_Percent(j.percent , j.amount , j.price , x_operand , x_arithmetic_operator);
1152:
1153: IF (j.percent IS NOT NULL OR j.amount IS NOT NULL OR j.price IS NOT NULL) THEN
1154: IF (x_arithmetic_operator = 'AMT') THEN

Line 1470: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount

1466: -- If percent and amount and price is null , then it is a price break.
1467: -- Execute this logic only if it is a product or qualifier. This is because we are not dealing
1468: -- with any entities other than those handled in Get_Context_Attributes procedure
1469:
1470: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount
1471: Get_Percent(j.percent , j.amount , j.price , x_operand , x_arithmetic_operator);
1472:
1473: IF (j.entity_id IS NOT NULL AND (v_product_flag = TRUE OR v_qualifier_flag = TRUE OR v_pricing_flag = TRUE))
1474: THEN

Line 1652: -- be a Qualifier and there will be a discount line 2% in qp_list_lines.

1648: -- v_qualifier_flag = TRUE indicates that it is a Qualifier with one pricing attribute Units or
1649: -- Dollars.
1650: -- In this case , if it is a discount line , there will not be any pricing attributes for this
1651: -- Qualifier. Ex: Give 2% discount where Order Type = 'Standard'. In this case Order Type will
1652: -- be a Qualifier and there will be a discount line 2% in qp_list_lines.
1653:
1654: IF (v_qualifier_flag = TRUE) THEN
1655:
1656:

Line 1707: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount

1703:
1704: FOR k IN get_price_break_lines(j.discount_line_id)
1705: LOOP
1706:
1707: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount
1708: Get_Percent(k.percent,k.amount,k.price,x_operand , x_arithmetic_operator);
1709:
1710: IF (x_arithmetic_operator = 'AMT') THEN
1711: IF (x_operand < 0) THEN