[Home] [Help]
PACKAGE: APPS.OE_LINE_SCREDIT_UTIL
Source
1 PACKAGE OE_Line_Scredit_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULSCS.pls 120.0.12000000.1 2007/01/16 22:04:04 appldev ship $ */
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 FUNCTION G_MISS_OE_AK_LINE_SCREDIT_REC
48 RETURN OE_AK_LINE_SCREDITS_V%ROWTYPE;
49
50 PROCEDURE API_Rec_To_Rowtype_Rec
51 ( p_LINE_SCREDIT_rec IN OE_Order_PUB.LINE_SCREDIT_Rec_Type
52 , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_SCREDITS_V%ROWTYPE
53 );
54
55 PROCEDURE Rowtype_Rec_To_API_Rec
56 ( p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
57 , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_SCREDIT_Rec_Type
58 );
59
60 -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
61
62 PROCEDURE Clear_Dependent_Attr
63 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
64 , p_x_Line_Scredit_rec IN OUT NOCOPY OE_AK_LINE_SCREDITS_V%ROWTYPE
65 , p_old_Line_Scredit_rec IN OE_AK_LINE_SCREDITS_V%ROWTYPE :=
66 G_MISS_OE_AK_LINE_SCREDIT_REC
67 );
68
69 -- Procedure Clear_Dependent_Attr
70
71 PROCEDURE Clear_Dependent_Attr
72 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
73 , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
74 , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
75 OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
76 );
77
78 -- Procedure Apply_Attribute_Changes
79
80 PROCEDURE Apply_Attribute_Changes
81 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
82 , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
83 OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
84 );
85
86 -- Procedure Complete_Record
87
88 PROCEDURE Complete_Record
89 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
90 , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
91 );
92
93 -- Procedure Convert_Miss_To_Null
94
95 PROCEDURE Convert_Miss_To_Null
96 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
97 );
98
99 -- Procedure Update_Row
100
101 PROCEDURE Update_Row
102 ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
103 );
104
105 -- Procedure Insert_Row
106
107 PROCEDURE Insert_Row
108 ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
109 );
110
111 -- Procedure Delete_Row
112
113 PROCEDURE Delete_Row
114 ( p_sales_credit_id IN NUMBER :=
115 FND_API.G_MISS_NUM
116 , p_line_id IN NUMBER :=
117 FND_API.G_MISS_NUM
118 );
119
120 -- Procedure Query_Row
121
122 PROCEDURE Query_Row
123 ( p_sales_credit_id IN NUMBER
124 , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
125 );
126
127 -- Procedure Query_Rows
128
129 --
130
131 PROCEDURE Query_Rows
132 ( p_sales_credit_id IN NUMBER :=
133 FND_API.G_MISS_NUM
134 , p_line_id IN NUMBER :=
135 FND_API.G_MISS_NUM
136 , p_header_id IN NUMBER :=
137 FND_API.G_MISS_NUM
138 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
139 );
140
141 -- Procedure lock_Row
142 --
143
144 PROCEDURE Lock_Row
145 ( x_return_status OUT NOCOPY VARCHAR2
146
147 , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
148 , p_sales_credit_id IN NUMBER
149 := FND_API.G_MISS_NUM
150 );
151
152 PROCEDURE Lock_Rows
153 ( p_sales_credit_id IN NUMBER :=
154 FND_API.G_MISS_NUM
155 , p_line_id IN NUMBER :=
156 FND_API.G_MISS_NUM
157 , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type
158 , x_return_status OUT NOCOPY VARCHAR2
159
160 );
161
162 -- Function Get_Values
163
164 FUNCTION Get_Values
165 ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
166 , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
167 OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
168 ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type;
169
170 -- PROCEDURE Get_Ids
171
172 PROCEDURE Get_Ids
173 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
174 , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
175 );
176
177 Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
178 p_old_line_rec IN oe_order_pub.line_rec_type);
179
180 PROCEDURE Pre_Write_Process
181 (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
182 p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
183 OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC);
184
185 END OE_Line_Scredit_Util;