7:
8: PROCEDURE Upg_Pricing_Attribs (p_upg_line_rec IN OE_UPG_SO_NEW.LINE_REC_TYPE);
9:
10: TYPE Price_Adj_Rec_Type IS RECORD
11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
8: PROCEDURE Upg_Pricing_Attribs (p_upg_line_rec IN OE_UPG_SO_NEW.LINE_REC_TYPE);
9:
10: TYPE Price_Adj_Rec_Type IS RECORD
11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
9:
10: TYPE Price_Adj_Rec_Type IS RECORD
11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
10: TYPE Price_Adj_Rec_Type IS RECORD
11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
17: , operand OE_PRICE_ADJUSTMENTS.operand%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%TYPE
26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_code%TYPE
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%TYPE
34: );
27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%TYPE
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%TYPE
34: );
35:
28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%TYPE
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%TYPE
34: );
35:
36:
29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%TYPE
30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%TYPE
31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_code%TYPE
32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%TYPE
33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%TYPE
34: );
35:
36:
37: PROCEDURE Upg_Price_Adj_OE_to_QP( p_discount_id IN NUMBER,