DBA Data[Home] [Help]

APPS.QP_UPG_OE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 11: ( list_header_id OE_PRICE_ADJUSTMENTS.list_header_id%TYPE

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

Line 12: , list_line_id OE_PRICE_ADJUSTMENTS.list_line_id%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

Line 13: , list_line_type_code OE_PRICE_ADJUSTMENTS.list_line_type_code%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

Line 14: , modified_from OE_PRICE_ADJUSTMENTS.modified_from%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

Line 15: , modified_to OE_PRICE_ADJUSTMENTS.modified_to%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

Line 16: , update_allowed OE_PRICE_ADJUSTMENTS.update_allowed%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

Line 17: , operand OE_PRICE_ADJUSTMENTS.operand%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

Line 18: , updated_flag OE_PRICE_ADJUSTMENTS.updated_flag%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

Line 19: , applied_flag OE_PRICE_ADJUSTMENTS.applied_flag%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

Line 20: , arithmetic_operator OE_PRICE_ADJUSTMENTS.arithmetic_operator%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

Line 21: , price_break_type_code OE_PRICE_ADJUSTMENTS.price_break_type_code%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

Line 22: , adjusted_amount OE_PRICE_ADJUSTMENTS.adjusted_amount%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

Line 23: , source_system_code OE_PRICE_ADJUSTMENTS.source_system_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

Line 24: , pricing_phase_id OE_PRICE_ADJUSTMENTS.pricing_phase_id%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

Line 25: , charge_type_code OE_PRICE_ADJUSTMENTS.charge_type_code%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

Line 26: , charge_subtype_code OE_PRICE_ADJUSTMENTS.charge_subtype_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

Line 27: , list_line_no OE_PRICE_ADJUSTMENTS.list_line_no%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

Line 28: , benefit_qty OE_PRICE_ADJUSTMENTS.benefit_qty%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

Line 29: , benefit_uom_code OE_PRICE_ADJUSTMENTS.benefit_uom_code%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

Line 30: , print_on_invoice_flag OE_PRICE_ADJUSTMENTS.print_on_invoice_flag%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: );

Line 31: , modifier_level_code OE_PRICE_ADJUSTMENTS.modifier_level_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: );
35:

Line 32: , pricing_group_sequence OE_PRICE_ADJUSTMENTS.pricing_group_sequence%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:
36:

Line 33: , expiration_date OE_PRICE_ADJUSTMENTS.expiration_date%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:
37: PROCEDURE Upg_Price_Adj_OE_to_QP( p_discount_id IN NUMBER,