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.OKC_QP_UPGRADE_PUB dependencies on QP_LIST_LINES

Line 1991: FROM qp_list_lines

1987: AND NVL(line_list_price,0) <> NVL(price_negotiated,0);
1988:
1989: CURSOR csr_list_lines(p_list_line_type_code IN VARCHAR2) IS
1990: SELECT *
1991: FROM qp_list_lines
1992: WHERE list_line_type_code = p_list_line_type_code
1993: AND list_header_id IN (
1994: SELECT list_header_id
1995: FROM qp_list_headers

Line 2000: l_qp_list_lines_rec qp_list_lines%ROWTYPE;

1996: WHERE name = 'OKC_QP_UPGRADE'
1997: );
1998:
1999: l_k_lines_rec okc_k_lines_b%ROWTYPE;
2000: l_qp_list_lines_rec qp_list_lines%ROWTYPE;
2001: l_adj_amt number;
2002: l_id number;
2003:
2004: BEGIN

Line 2026: FETCH csr_list_lines INTO l_qp_list_lines_rec;

2022:
2023: IF l_adj_amt > 0 THEN
2024: -- this is discount as list pr > negotiated pr
2025: OPEN csr_list_lines(p_list_line_type_code => 'DIS');
2026: FETCH csr_list_lines INTO l_qp_list_lines_rec;
2027: ELSE
2028: -- this is surcharge
2029: OPEN csr_list_lines(p_list_line_type_code => 'SUR');
2030: FETCH csr_list_lines INTO l_qp_list_lines_rec;

Line 2030: FETCH csr_list_lines INTO l_qp_list_lines_rec;

2026: FETCH csr_list_lines INTO l_qp_list_lines_rec;
2027: ELSE
2028: -- this is surcharge
2029: OPEN csr_list_lines(p_list_line_type_code => 'SUR');
2030: FETCH csr_list_lines INTO l_qp_list_lines_rec;
2031: END IF;
2032:
2033: -- generate Primary Key
2034: l_id := get_seq_id;

Line 2085: l_qp_list_lines_rec.accrual_conversion_rate, -- ACCRUAL_CONVERSION_RATE

2081: (
2082: l_id , -- ID
2083: p_chr_id, -- CHR_ID
2084: l_k_lines_rec.id, -- CLE_ID
2085: l_qp_list_lines_rec.accrual_conversion_rate, -- ACCRUAL_CONVERSION_RATE
2086: l_qp_list_lines_rec.accrual_flag,-- ACCRUAL_FLAG
2087: -1*(l_adj_amt),-- ADJUSTED_AMOUNT
2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR

Line 2086: l_qp_list_lines_rec.accrual_flag,-- ACCRUAL_FLAG

2082: l_id , -- ID
2083: p_chr_id, -- CHR_ID
2084: l_k_lines_rec.id, -- CLE_ID
2085: l_qp_list_lines_rec.accrual_conversion_rate, -- ACCRUAL_CONVERSION_RATE
2086: l_qp_list_lines_rec.accrual_flag,-- ACCRUAL_FLAG
2087: -1*(l_adj_amt),-- ADJUSTED_AMOUNT
2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG

Line 2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR

2085: l_qp_list_lines_rec.accrual_conversion_rate, -- ACCRUAL_CONVERSION_RATE
2086: l_qp_list_lines_rec.accrual_flag,-- ACCRUAL_FLAG
2087: -1*(l_adj_amt),-- ADJUSTED_AMOUNT
2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE

Line 2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG

2086: l_qp_list_lines_rec.accrual_flag,-- ACCRUAL_FLAG
2087: -1*(l_adj_amt),-- ADJUSTED_AMOUNT
2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE

Line 2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY

2087: -1*(l_adj_amt),-- ADJUSTED_AMOUNT
2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE

Line 2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE

2088: 'Y',-- APPLIED_FLAG
2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG

Line 2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE

2089: l_qp_list_lines_rec.arithmetic_operator, -- ARITHMETIC_OPERATOR
2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID

Line 2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE

2090: l_qp_list_lines_rec.automatic_flag,-- AUTOMATIC_FLAG
2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID

Line 2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE

2091: l_qp_list_lines_rec.benefit_qty , -- BENEFIT_QTY
2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO

Line 2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG

2092: l_qp_list_lines_rec.benefit_uom_code , -- BENEFIT_UOM_CODE
2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE

Line 2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID

2093: l_qp_list_lines_rec.charge_subtype_code , -- CHARGE_SUBTYPE_CODE
2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE

Line 2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID

2094: l_qp_list_lines_rec.charge_type_code , -- CHARGE_TYPE_CODE
2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE

Line 2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO

2095: l_qp_list_lines_rec.expiration_date , -- EXPIRATION_DATE
2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT

Line 2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE

2096: l_qp_list_lines_rec.include_on_returns_flag , -- INCLUDE_ON_RETURNS_FLAG
2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE

Line 2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE

2097: l_qp_list_lines_rec.list_header_id , -- LIST_HEADER_ID
2098: l_qp_list_lines_rec.list_line_id , -- LIST_LINE_ID
2099: l_qp_list_lines_rec.list_line_no , -- LIST_LINE_NO
2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE

Line 2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE

2100: l_qp_list_lines_rec.list_line_type_code , -- LIST_LINE_TYPE_CODE
2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE
2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID
2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE

Line 2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE

2101: l_qp_list_lines_rec.modifier_level_code , -- MODIFIER_LEVEL_CODE
2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE
2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID
2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY

Line 2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID

2102: 'DLT' , -- MODIFIER_MECHANISM_TYPE_CODE
2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE
2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID
2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY
2110: NULL , -- SOURCE_SYSTEM_CODE

Line 2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE

2103: l_adj_amt , -- OPERAND this is reverse of ADJUSTED_AMOUNT
2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE
2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID
2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY
2110: NULL , -- SOURCE_SYSTEM_CODE
2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE

Line 2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE

2104: l_qp_list_lines_rec.price_break_type_code , -- PRICE_BREAK_TYPE_CODE
2105: l_qp_list_lines_rec.pricing_group_sequence , -- PRICING_GROUP_SEQUENCE
2106: l_qp_list_lines_rec.pricing_phase_id , -- PRICING_PHASE_ID
2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY
2110: NULL , -- SOURCE_SYSTEM_CODE
2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE
2112: l_qp_list_lines_rec.override_flag , -- UPDATE_ALLOWED

Line 2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE

2107: l_qp_list_lines_rec.proration_type_code , -- PRORATION_TYPE_CODE
2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY
2110: NULL , -- SOURCE_SYSTEM_CODE
2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE
2112: l_qp_list_lines_rec.override_flag , -- UPDATE_ALLOWED
2113: 'Y' , -- UPDATED_FLAG
2114: 1, -- OBJECT_VERSION_NUMBER
2115: fnd_global.user_id,

Line 2112: l_qp_list_lines_rec.override_flag , -- UPDATE_ALLOWED

2108: l_qp_list_lines_rec.rebate_transaction_type_code , -- REBATE_TRANSACTION_TYPE_CODE
2109: NULL , -- RANGE_BREAK_QUANTITY
2110: NULL , -- SOURCE_SYSTEM_CODE
2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE
2112: l_qp_list_lines_rec.override_flag , -- UPDATE_ALLOWED
2113: 'Y' , -- UPDATED_FLAG
2114: 1, -- OBJECT_VERSION_NUMBER
2115: fnd_global.user_id,
2116: sysdate,

Line 2161: l_qp_list_lines_rec qp_list_lines%ROWTYPE;

2157: -- local variables and cursors
2158:
2159: l_proc varchar2(72) := g_package||'check_modifier';
2160: l_status varchar2(10) := 'N';
2161: l_qp_list_lines_rec qp_list_lines%ROWTYPE;
2162:
2163: CURSOR csr_list_lines IS
2164: SELECT *
2165: FROM qp_list_lines

Line 2165: FROM qp_list_lines

2161: l_qp_list_lines_rec qp_list_lines%ROWTYPE;
2162:
2163: CURSOR csr_list_lines IS
2164: SELECT *
2165: FROM qp_list_lines
2166: WHERE list_header_id IN (
2167: SELECT list_header_id
2168: FROM qp_list_headers
2169: WHERE name = 'OKC_QP_UPGRADE'

Line 2181: FETCH csr_list_lines INTO l_qp_list_lines_rec;

2177: END IF;
2178:
2179: OPEN csr_list_lines;
2180: -- only one line for the modifier OKC_QP_UPGRADE
2181: FETCH csr_list_lines INTO l_qp_list_lines_rec;
2182: -- check if the above Modifier is defined else give message
2183: IF csr_list_lines%NOTFOUND THEN
2184: IF (l_debug = 'Y') THEN
2185: okc_debug.Log('100: Aborting as the Modifier OKC_QP_UPGRADE is not defined ',2);