[Home] [Help]
PACKAGE: APPS.CSI_PRICING_ATTRIBS_PVT
Source
1 PACKAGE csi_pricing_attribs_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivpas.pls 115.19 2003/09/04 00:48:07 sguthiva ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Procedure name: Initialize_pri_rec_no_dump */
6 /* Description : This procudure gets the first record */
7 /* from the history */
8 /*----------------------------------------------------------*/
9
10 PROCEDURE Initialize_pri_rec_no_dump
11 (
12 x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,
13 p_pri_hist_id IN NUMBER,
14 x_first_no_dump IN OUT NOCOPY DATE
15 );
16
17 /*----------------------------------------------------------*/
18 /* Procedure name: Initialize_pri_rec */
19 /* Description : This procudure recontructs the record */
20 /* from the history */
21 /*----------------------------------------------------------*/
22
23 PROCEDURE Initialize_pri_rec
24 ( x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,
25 p_pri_h_id IN NUMBER,
26 x_nearest_full_dump IN OUT NOCOPY DATE
27 );
28
29
30
31 /*----------------------------------------------------------*/
32 /* Procedure name: Construct_pri_from_hist */
33 /* Description : This procudure recontructs the record */
34 /* from the history */
35 /*----------------------------------------------------------*/
36
37 PROCEDURE Construct_pri_from_hist
38 ( x_pri_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
39 p_time_stamp IN DATE
40 );
41
42
43
44 /*----------------------------------------------------------*/
45 /* Procedure name: Define_pri_Columns */
46 /* Description : This procudure defines column values */
47 /* for Dynamic SQL */
48 /*----------------------------------------------------------*/
49
50 PROCEDURE Define_pri_Columns
51 ( p_get_pri_cursor_id IN NUMBER
52 );
53
54
55
56
57 /*----------------------------------------------------------*/
58 /* Procedure name: Get_pri_Column_Values */
59 /* Description : This procudure gets the column values */
60 /* for the Dynamic SQL */
61 /*----------------------------------------------------------*/
62
63 PROCEDURE Get_pri_Column_Values
64 ( p_get_pri_cursor_id IN NUMBER,
65 x_pri_rec OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
66 );
67
68
69
70
71 /*----------------------------------------------------------*/
72 /* Procedure name: Bind_pri_variable */
73 /* Description : This procudure binds the column values */
74 /* for the Dynamic SQL */
75 /*----------------------------------------------------------*/
76
77 PROCEDURE Bind_pri_variable
78 ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec,
79 p_cur_get_pri IN NUMBER
80 );
81
82
83
84 /*----------------------------------------------------------*/
85 /* Procedure name: Gen_pri_Where_Clause */
86 /* Description : Procedure used to generate the where */
87 /* clause for Extended Attributes units */
88 /*----------------------------------------------------------*/
89
90 PROCEDURE Gen_pri_Where_Clause
91 ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec
92 ,x_where_clause OUT NOCOPY VARCHAR2
93 );
94
95
96 /*------------------------------------------------------*/
97 /* procedure name: create_pricing_attribs */
98 /* description : Associates pricing attributes to an */
99 /* item instance */
100 /* */
101 /*------------------------------------------------------*/
102
103 PROCEDURE create_pricing_attribs
104 ( p_api_version IN NUMBER
105 ,p_commit IN VARCHAR2 := fnd_api.g_false
106 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
107 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
108 ,p_pricing_attribs_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
109 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
114 );
115
116
117 /*------------------------------------------------------*/
118 /* procedure name: update_pricing_attribs */
119 /* description : Updates the existing pricing */
120 /* attributes for an item instance */
121 /* */
122 /*------------------------------------------------------*/
123
124
125 PROCEDURE update_pricing_attribs
126 ( p_api_version IN NUMBER
127 ,p_commit IN VARCHAR2 := fnd_api.g_false
128 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
129 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
130 ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
131 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137
138 /*------------------------------------------------------*/
139 /* procedure name: expire_pricing_attribs */
140 /* description : Deletes the existing pricing */
141 /* attributes for an item instance */
142 /* */
143 /*------------------------------------------------------*/
144
145
146 PROCEDURE expire_pricing_attribs
147 ( p_api_version IN NUMBER
148 ,p_commit IN VARCHAR2 := fnd_api.g_false
149 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
150 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
151 ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
152 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156 );
157
158
159
160
161 END csi_pricing_attribs_pvt;