[Home] [Help]
PACKAGE: APPS.OE_HEADER_SCREDIT_UTIL
Source
1 PACKAGE OE_Header_Scredit_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUHSCS.pls 120.1 2006/03/29 16:47:46 spooruli noship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_DW_UPDATE_ADVICE CONSTANT NUMBER := 19;
25 G_HEADER CONSTANT NUMBER := 20;
26 G_LAST_UPDATED_BY CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_DATE CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 23;
29 G_LINE CONSTANT NUMBER := 24;
30 G_PERCENT CONSTANT NUMBER := 25;
31 G_QUOTA CONSTANT NUMBER := 26;
32 G_SALESREP CONSTANT NUMBER := 27;
33 G_SALES_CREDIT CONSTANT NUMBER := 28;
34 G_WH_UPDATE_DATE CONSTANT NUMBER := 29;
35 G_ORIG_SYS_CREDIT_REF CONSTANT NUMBER := 30;
36 G_CHANGE_SEQUENCE_ID CONSTANT NUMBER := 31;
37 G_SALES_CREDIT_TYPE CONSTANT NUMBER := 32;
38 G_LOCK_CONTROL CONSTANT NUMBER := 33;
39 --SG{
40 G_SALES_GROUP_ID CONSTANT NUMBER := 34;
41 G_SALES_GROUP CONSTANT NUMBER := 35;
42 G_SALES_GROUP_UPDATED_FLAG CONSTANT NUMBER := 36;
43 G_MAX_ATTR_ID CONSTANT NUMBER := 37;
44 --SG}
45
46
47
48 TYPE sales_credit_rec_type IS RECORD
49 ( salesrep_id NUMBER,
50 sales_credit_pct NUMBER,
51 sales_credit_amt NUMBER,
52 sales_credit_id NUMBER,
53 sales_credit_type VARCHAR2(240),
54 sales_credit_type_id NUMBER,
55 quota_flag Varchar2(1),
56 role_type VARCHAR2(240)
57 );
58
59 TYPE salesrep_id_rec_type Is RECORD
60 (sales_credit_id NUMBER,
61 salesrep_id NUMBER,
62 quota_flag VARCHAR2(1)
63 );
64
65 G_MISS_SALES_CREDIT_REC sales_credit_rec_type;
66
67 TYPE sales_credit_tbl_type IS TABLE OF sales_credit_rec_type INDEX BY BINARY_INTEGER;
68 Type Number_tbl_type Is Table of Number Index By Binary_Integer;
69 Type salesrep_id_tbl_type Is Table of salesrep_id_rec_type Index By Binary_Integer;
70
71 Procedure calculate
72 ( p_header_id IN NUMBER,
73 p_salesrep_id_tbl IN salesrep_id_tbl_type,
74 x_sales_credit_tbl OUT NOCOPY sales_credit_tbl_type,
75 x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE DFLT_Hscredit_Primary_Srep
79 ( p_header_id IN Number
80 ,p_SalesRep_id IN Number
81 ,x_return_status OUT NOCOPY Varchar2
82 );
83
84 FUNCTION G_MISS_OE_AK_HSCREDIT_REC
85 RETURN OE_AK_HEADER_SCREDITS_V%ROWTYPE;
86
87 PROCEDURE API_Rec_To_Rowtype_Rec
88 ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type
89 , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
90 );
91
92 PROCEDURE Rowtype_Rec_To_API_Rec
93 ( p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
94 , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type
95 );
96
97 -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
98
99 PROCEDURE Clear_Dependent_Attr
100 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
101 , p_x_Header_Scredit_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
102 , p_old_Header_Scredit_rec IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
103 := G_MISS_OE_AK_HSCREDIT_REC
104 );
105
106 -- Procedure Clear_Dependent_Attr
107
108 PROCEDURE Clear_Dependent_Attr
109 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
110 , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
111 , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
112 OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
113 );
114
115 -- Procedure Apply_Attribute_Changes
116
117 PROCEDURE Apply_Attribute_Changes
118 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
119 , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
120 OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
121 );
122
123 -- Function Complete_Record
124
125 PROCEDURE Complete_Record
126 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
127 , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
128 ) ;
129
130 -- Function Convert_Miss_To_Null
131
132 PROCEDURE Convert_Miss_To_Null
133 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
134 ) ;
135
136 -- Procedure Update_Row
137
138 PROCEDURE Update_Row
139 ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
140 );
141
142 -- Procedure Insert_Row
143
144 PROCEDURE Insert_Row
145 ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
146 );
147
148 -- Procedure Delete_Row
149
150 PROCEDURE Delete_Row
151 ( p_sales_credit_id IN NUMBER :=
152 FND_API.G_MISS_NUM
153 , p_header_id IN NUMBER :=
154 FND_API.G_MISS_NUM
155 );
156
157 -- Function Query_Row
158
159 PROCEDURE Query_Row
160 ( p_sales_credit_id IN NUMBER,
161 x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
162 ) ;
163
164 -- Function Query_Rows
165
166 --
167
168 PROCEDURE Query_Rows
169 ( p_sales_credit_id IN NUMBER :=
170 FND_API.G_MISS_NUM
171 , p_header_id IN NUMBER :=
172 FND_API.G_MISS_NUM
173 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
174
175 );
176
177 -- Procedure lock_Row
178 --
179
180 PROCEDURE Lock_Row
181 ( x_return_status OUT NOCOPY VARCHAR2
182 , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
183 , p_sales_credit_id IN NUMBER
184 := FND_API.G_MISS_NUM
185 );
186
187 PROCEDURE Lock_Rows
188 ( p_sales_credit_id IN NUMBER :=
189 FND_API.G_MISS_NUM
190 , p_header_id IN NUMBER :=
191 FND_API.G_MISS_NUM
192 , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type
193 , x_return_status OUT NOCOPY VARCHAR2
194 );
195
196 -- Function Get_Values
197
198 FUNCTION Get_Values
199 ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
200 , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
201 OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
202 ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;
203
204 -- Function Get_Ids
205
206 PROCEDURE Get_Ids
207 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
208 , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
209 ) ;
210
211 PROCEDURE Pre_Write_Process
212 ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,
213 p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC );
214
215 --SG{
216 Procedure Get_Sales_Group(p_date IN DATE:=NULL,
217 p_sales_rep_id IN NUMBER,
218 x_sales_group_id OUT NOCOPY NUMBER,
219 -- x_sales_group OUT NOCOPY VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2);
221
222 Procedure Redefault_Sales_Group(p_header_id IN NUMBER,
223 p_date IN DATE);
224 --SG}
225
226 END OE_Header_Scredit_Util;