[Home] [Help]
PACKAGE: APPS.OE_PRICE_LIST_UTIL
Source
1 PACKAGE OE_Price_List_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUPRHS.pls 120.3 2006/03/27 12:59:05 rnayani 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_COMMENTS CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATION_DATE CONSTANT NUMBER := 19;
25 G_CURRENCY CONSTANT NUMBER := 20;
26 G_DESCRIPTION CONSTANT NUMBER := 21;
27 G_END_DATE_ACTIVE CONSTANT NUMBER := 22;
28 G_FREIGHT_TERMS CONSTANT NUMBER := 23;
29 G_LAST_UPDATED_BY CONSTANT NUMBER := 24;
30 G_LAST_UPDATE_DATE CONSTANT NUMBER := 25;
31 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 26;
32 G_NAME CONSTANT NUMBER := 27;
33 G_PRICE_LIST CONSTANT NUMBER := 28;
34 G_PROGRAM_APPLICATION CONSTANT NUMBER := 29;
35 G_PROGRAM CONSTANT NUMBER := 30;
36 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 31;
37 G_REQUEST CONSTANT NUMBER := 32;
38 G_ROUNDING_FACTOR CONSTANT NUMBER := 33;
39 G_SECONDARY_PRICE_LIST CONSTANT NUMBER := 34;
40 G_SHIP_METHOD CONSTANT NUMBER := 35;
41 G_START_DATE_ACTIVE CONSTANT NUMBER := 36;
42 G_TERMS CONSTANT NUMBER := 37;
43 G_MAX_ATTR_ID CONSTANT NUMBER := 38;
44
45 -- Procedure Clear_Dependent_Attr
46
47 PROCEDURE Clear_Dependent_Attr
48 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49 , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50 , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51 OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53 );
54
55 -- Procedure Apply_Attribute_Changes
56
57 PROCEDURE Apply_Attribute_Changes
58 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59 , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60 OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62 );
63
64 -- Function Complete_Record
65
66 FUNCTION Complete_Record
67 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68 , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69 ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70
71 -- Function Convert_Miss_To_Null
72
73 FUNCTION Convert_Miss_To_Null
74 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
75 ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
76
77 -- Procedure Update_Row
78
79 PROCEDURE Update_Row
80 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
81 );
82
83 -- Procedure Insert_Row
84
85 PROCEDURE Insert_Row
86 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
87 );
88
89 -- Procedure Delete_Row
90
91 PROCEDURE Delete_Row
92 ( p_name IN VARCHAR2
93 , p_price_list_id IN NUMBER
94 );
95
96 -- Function Query_Row
97
98 FUNCTION Query_Row
99 ( p_name IN VARCHAR2
100 , p_price_list_id IN NUMBER
101 ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
102
103 -- Procedure lock_Row
104 --
105
106 PROCEDURE Lock_Row
107 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
109 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
110 );
111
112 -- Function Get_Values
113
114 FUNCTION Get_Values
115 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116 , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117 OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118 ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119
120 -- Function Get_Ids
121
122 FUNCTION Get_Ids
123 ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124 , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125 ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126
127 -- Function Get_Ids
128
129 END OE_Price_List_Util;