[Home] [Help]
PACKAGE: APPS.PO_PRICE_ADJUSTMENTS_PKG
Source
1 PACKAGE PO_PRICE_ADJUSTMENTS_PKG AUTHID CURRENT_USER AS
2 -- $Header: PO_PRICE_ADJUSTMENTS_PKG.pls 120.0.12010000.4 2009/07/01 01:32:31 ababujan noship $
3
4 ---------------------------------------------------------------
5 -- Global constants and types.
6 ---------------------------------------------------------------
7 G_EMPTY_NUMBER_TYPE QP_PREQ_GRP.NUMBER_TYPE;
8
9 --Adjustments Copy Mode
10 G_COPY_OVERRIDDEN_MOD CONSTANT VARCHAR2(3):='O';
11 G_COPY_MANUAL_MOD CONSTANT VARCHAR2(3):='M';
12 G_COPY_MANUAL_OVERRIDDEN_MOD CONSTANT VARCHAR2(3):='MO';
13 G_COPY_AUTO_MOD CONSTANT VARCHAR2(3):='A';
14 G_COPY_AUTO_OVERRIDDEN_MOD CONSTANT VARCHAR2(3):='AO';
15 G_COPY_ALL_MOD CONSTANT VARCHAR2(3):='ALL';
16
17 --Applied Modifiers
18 G_MANUAL_MOD CONSTANT VARCHAR2(10):='M_MOD';
19 G_AUTOMATIC_MOD CONSTANT VARCHAR2(10):='A_MOD';
20 G_AUTOMATIC_MANUAL_MOD CONSTANT VARCHAR2(10):='AM_MOD';
21 G_AUTOMATIC_OVR_MOD CONSTANT VARCHAR2(10):='AO_MOD';
22 G_MANUAL_OVR_MOD CONSTANT VARCHAR2(10):='MO_MOD';
23 G_AUTOMATIC_MANUAL_OVR_MOD CONSTANT VARCHAR2(10):='AMO_MOD';
24 G_NO_MOD CONSTANT VARCHAR2(10):='N_MOD';
25
26
27 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
28
29 ---------------------------------------------------------------
30 -- Public subprograms.
31 ---------------------------------------------------------------
32 PROCEDURE get_applied_modifier_code
33 (p_po_header_id IN NUMBER
34 ,p_po_line_id IN NUMBER
35 ,x_modifier_code OUT NOCOPY VARCHAR2
36 );
37
38 PROCEDURE line_modifier_exist
39 (p_po_header_id IN NUMBER
40 ,p_po_line_id IN NUMBER
41 ,x_line_modifier_exist OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE check_man_ovr_mod_exist
45 (p_po_header_id IN NUMBER
46 ,p_po_line_id IN NUMBER
47 ,x_man_ovr_mod_exist OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE popl_manual_overridden_adj
51 (p_draft_id IN NUMBER
52 ,p_order_header_id IN NUMBER
53 ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
54 ,p_quantity_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
55 ,x_return_status OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE extract_price_adjustments
59 (p_draft_id IN NUMBER
60 ,p_order_header_id IN NUMBER
61 ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
62 ,p_pricing_events IN VARCHAR2
63 ,p_calculate_flag IN VARCHAR2
64 ,p_doc_sub_type IN VARCHAR2
65 --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
66 ,p_pricing_call_src IN VARCHAR2
67 --To fix price override not allowed error
68 ,p_allow_price_override_flag IN VARCHAR2
69 ,x_return_status OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE complete_manual_mod_lov_map
73 (p_draft_id IN NUMBER
74 ,p_doc_sub_type IN VARCHAR2
75 ,x_return_status_text OUT NOCOPY VARCHAR2
76 ,x_return_status OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE copy_line_adjustments
80 ( p_src_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
81 , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
82 , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
83 , p_mode IN VARCHAR2
84 , x_return_status_text OUT NOCOPY VARCHAR2
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE copy_draft_line_adjustments
89 ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
90 , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
91 , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
92 , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
93 , p_mode IN VARCHAR2
94 , x_return_status_text OUT NOCOPY VARCHAR2
95 , x_return_status OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE delete_price_adjustments
99 ( p_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
100 , p_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE DEFAULT NULL
101 );
102
103 PROCEDURE delete_adjustment
104 ( p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS.price_adjustment_id%TYPE );
105 /*
106 PROCEDURE delete_adjustment_dependants
107 ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
108 , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE );
109 */
110
111 END PO_PRICE_ADJUSTMENTS_PKG;