[Home] [Help]
PACKAGE: APPS.OZF_ADJUSTMENT_EXT_PVT
Source
1 PACKAGE ozf_adjustment_ext_pvt AS
2 /*$Header: ozfvades.pls 120.3.12000000.2 2007/05/11 13:52:45 nirprasa ship $*/
3 ---------------------------------------------------------------------
4 -- PROCEDURE
5 --
6 --
7 -- PURPOSE
8 --
9 -- PARAMETERS
10 -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
11 -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
12 -- NOTES
13 -- HISTORY
14 -- 4/18/2002 Mumu Pande Create.
15 ----------------------------------------------------------------------
16 PROCEDURE adjust_backdated_offer(
17 x_errbuf OUT NOCOPY VARCHAR2
18 ,x_retcode OUT NOCOPY NUMBER
19 ,p_debug IN VARCHAR2 := 'N' );
20 ---------------------------------------------------------------------
21 -- PROCEDURE
22 --
23 --
24 -- PURPOSE
25 --
26 -- PARAMETERS
27 -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
28 -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
29 -- NOTES
30 -- HISTORY
31 -- 7/30/2002 Mumu Pande Create.
32 ----------------------------------------------------------------------
33 PROCEDURE adjust_volume_offer(
34 x_errbuf OUT NOCOPY VARCHAR2
35 ,x_retcode OUT NOCOPY NUMBER
36 ,p_debug IN VARCHAR2 := 'N' );
37 ---------------------------------------------------------------------
38 -- FUNCTION
39 -- get_order_amount_quantity
40 --
41 -- PURPOSE
42 --
43 -- PARAMETERS
44 -- p_list_header_id IN NUMBER,
45 -- x_order_amount OUT NOCOPY NUMBER,
46 -- x_new_discount OUT NOCOPY NUMBER,
47 -- x_new_operator OUT NOCOPY VARCHAR2,
48 -- x_old_discount OUT NOCOPY NUMBER,
49 -- x_old_operator OUT NOCOPY VARCHAR2,
50 -- x_return_status OUT NOCOPY VARCHAR2
51 -- NOTES
52 -- HISTORY
53 -- 8/6/2002 Mumu Pande Create.
54 ----------------------------------------------------------------------
55
56 FUNCTION get_order_amount_quantity( p_list_header_id IN NUMBER,
57 x_order_amount_quantity OUT NOCOPY NUMBER,
58 x_new_discount OUT NOCOPY NUMBER,
59 x_new_operator OUT NOCOPY VARCHAR2,
60 x_old_discount OUT NOCOPY NUMBER,
61 x_old_operator OUT NOCOPY VARCHAR2,
62 x_volume_type OUT NOCOPY VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2
64 ) RETURN NUMBER;
65 ---------------------------------------------------------------------
66 -- FUNCTION
67 -- get_order_amount_quantity
68 --
69 -- PURPOSE -- Called from Offers UI
70 --
71 -- PARAMETERS
72 -- p_list_header_id IN NUMBER,
73 -- x_order_amount OUT NOCOPY NUMBER,
74 -- NOTES
75 -- HISTORY
76 -- 10/18/2002 Mumu Pande Create.
77 ----------------------------------------------------------------------
78
79 FUNCTION get_order_amount_quantity(
80 p_list_header_id IN NUMBER
81 ) RETURN NUMBER;
82
83
84
85 ---------------------------------------------------------------------
86 -- PROCEDURE
87 -- volume_offer_adjustment
88 --
89 -- PURPOSE
90 -- adjustment for volume offer. it is called when
91 -- 1. run volume offer adjutment from accrual engine.
92 -- 2. run backdated adjustment for volume offer.
93
94 -- PARAMETERS
95 -- p_qp_list_header_id IN NUMBER
96 -- p_offer_adjustment_id IN NUMBER,
97 -- p_retroactive IN VARCHAR2,
98 -- p_vol_off_type IN VARCHAR2
99
100 -- NOTES
101 -- HISTORY
102 -- 6/10/2005 feliu Create.
103
104 ----------------------------------------------------------------------
105
106 PROCEDURE volume_offer_adjustment (
107 p_qp_list_header_id IN NUMBER,
108 p_vol_off_type IN VARCHAR2,
109 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110 p_commit IN VARCHAR2 := fnd_api.g_false,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE volume_offer_util_adjustment(
117 p_qp_list_header_id IN NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 END ozf_adjustment_ext_pvt;
124