[Home] [Help]
PACKAGE: APPS.OE_PRICE_LIST_LINE_UTIL
Source
1 PACKAGE OE_Price_List_Line_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUPRLS.pls 120.1 2005/06/15 03:35:36 appldev $ */
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_COMMENTS CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 19;
24 G_CREATION_DATE CONSTANT NUMBER := 20;
25 G_CUSTOMER_ITEM CONSTANT NUMBER := 21;
26 G_END_DATE_ACTIVE CONSTANT NUMBER := 22;
27 G_INVENTORY_ITEM CONSTANT NUMBER := 23;
28 G_LAST_UPDATED_BY CONSTANT NUMBER := 24;
29 G_LAST_UPDATE_DATE CONSTANT NUMBER := 25;
30 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 26;
31 G_LIST_PRICE CONSTANT NUMBER := 27;
32 G_METHOD CONSTANT NUMBER := 28;
33 G_PRICE_LIST CONSTANT NUMBER := 29;
34 G_PRICE_LIST_LINE CONSTANT NUMBER := 30;
35 G_PRICING_ATTRIBUTE1 CONSTANT NUMBER := 31;
36 G_PRICING_ATTRIBUTE10 CONSTANT NUMBER := 32;
37 G_PRICING_ATTRIBUTE11 CONSTANT NUMBER := 33;
38 G_PRICING_ATTRIBUTE12 CONSTANT NUMBER := 34;
39 G_PRICING_ATTRIBUTE13 CONSTANT NUMBER := 35;
40 G_PRICING_ATTRIBUTE14 CONSTANT NUMBER := 36;
41 G_PRICING_ATTRIBUTE15 CONSTANT NUMBER := 37;
42 G_PRICING_ATTRIBUTE2 CONSTANT NUMBER := 38;
43 G_PRICING_ATTRIBUTE3 CONSTANT NUMBER := 39;
44 G_PRICING_ATTRIBUTE4 CONSTANT NUMBER := 40;
45 G_PRICING_ATTRIBUTE5 CONSTANT NUMBER := 41;
46 G_PRICING_ATTRIBUTE6 CONSTANT NUMBER := 42;
47 G_PRICING_ATTRIBUTE7 CONSTANT NUMBER := 43;
48 G_PRICING_ATTRIBUTE8 CONSTANT NUMBER := 44;
49 G_PRICING_ATTRIBUTE9 CONSTANT NUMBER := 45;
50 G_PRICING_CONTEXT CONSTANT NUMBER := 46;
51 G_PRICING_RULE CONSTANT NUMBER := 47;
52 G_PRIMARY CONSTANT NUMBER := 48;
53 G_PROGRAM_APPLICATION CONSTANT NUMBER := 49;
54 G_PROGRAM CONSTANT NUMBER := 50;
55 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 51;
56 G_REPRICE CONSTANT NUMBER := 52;
57 G_REQUEST CONSTANT NUMBER := 53;
58 G_REVISION CONSTANT NUMBER := 54;
59 G_REVISION_DATE CONSTANT NUMBER := 55;
60 G_REVISION_REASON CONSTANT NUMBER := 56;
61 G_START_DATE_ACTIVE CONSTANT NUMBER := 57;
62 G_UNIT CONSTANT NUMBER := 58;
63 G_LIST_LINE_TYPE_CODE CONSTANT NUMBER := 59;
64 G_MAX_ATTR_ID CONSTANT NUMBER := 60;
65
66 -- Procedure Clear_Dependent_Attr
67
68 PROCEDURE Clear_Dependent_Attr
69 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
70 , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
71 , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
72 OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
73 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
74 );
75
76 -- Procedure Apply_Attribute_Changes
77
78 PROCEDURE Apply_Attribute_Changes
79 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
80 , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
81 OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
82 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
83 );
84
85 -- Function Complete_Record
86
87 FUNCTION Complete_Record
88 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
89 , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
90 ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
91
92 -- Function Convert_Miss_To_Null
93
94 FUNCTION Convert_Miss_To_Null
95 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
96 ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
97
98 -- Procedure Update_Row
99
100 PROCEDURE Update_Row
101 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
102 );
103
104 -- Procedure Insert_Row
105
106 PROCEDURE Insert_Row
107 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
108 );
109
110 -- Procedure Delete_Row
111
112 PROCEDURE Delete_Row
113 ( p_price_list_line_id IN NUMBER
114 );
115
116 -- Function Query_Row
117
118 FUNCTION Query_Row
119 ( p_price_list_Line_id IN NUMBER
120 , p_price_list_id IN NUMBER
121 ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
122
123 -- Function Query_Rows
124
125 --
126
127 FUNCTION Query_Rows
128 ( p_price_list_line_id IN NUMBER :=
129 FND_API.G_MISS_NUM
130 , p_price_list_id IN NUMBER :=
131 FND_API.G_MISS_NUM
132 ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type;
133
134
135 PROCEDURE Lock_Row
136 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
138 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
139 );
140
141 -- Function Get_Values
142
143 FUNCTION Get_Values
144 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
145 , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
146 OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
147 ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
148
149 -- Function Get_Ids
150
151 FUNCTION Get_Ids
152 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
153 , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
154 ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
155
156 PROCEDURE maintain_pricing_attributes
157 ( p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,
158 operation in varchar2,
159 x_return_status out NOCOPY /* file.sql.39 change */ varchar2);
160
161 PROCEDURE lock_pricing_attributes( p_list_line_id in number,
162 x_return_status out NOCOPY /* file.sql.39 change */ varchar2);
163
164 FUNCTION Query_Pricing_Attributes
165 ( p_pricing_attribute_id IN NUMBER :=
166 FND_API.G_MISS_NUM
167 , p_list_line_id IN NUMBER :=
168 FND_API.G_MISS_NUM
169 ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
170
171
172 END OE_Price_List_Line_Util;