[Home] [Help]
PACKAGE: APPS.QP_PRICE_LIST_UTIL
Source
1 PACKAGE QP_Price_List_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPLHS.pls 120.3 2006/03/27 12:58:43 rnayani 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_AUTOMATIC CONSTANT NUMBER := 16;
22 G_COMMENTS CONSTANT NUMBER := 17;
23 G_CONTEXT CONSTANT NUMBER := 18;
24 G_CREATED_BY CONSTANT NUMBER := 19;
25 G_CREATION_DATE CONSTANT NUMBER := 20;
26 G_CURRENCY CONSTANT NUMBER := 21;
27 G_DISCOUNT_LINES CONSTANT NUMBER := 22;
28 G_END_DATE_ACTIVE CONSTANT NUMBER := 23;
29 G_FREIGHT_TERMS CONSTANT NUMBER := 24;
30 G_GSA_INDICATOR CONSTANT NUMBER := 25;
31 G_LAST_UPDATED_BY CONSTANT NUMBER := 26;
32 G_LAST_UPDATE_DATE CONSTANT NUMBER := 27;
33 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 28;
34 G_LIST_HEADER CONSTANT NUMBER := 29;
35 G_LIST_TYPE CONSTANT NUMBER := 30;
36 G_PROGRAM_APPLICATION CONSTANT NUMBER := 31;
37 G_PROGRAM CONSTANT NUMBER := 32;
38 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 33;
39 G_PRORATE CONSTANT NUMBER := 34;
40 G_REQUEST CONSTANT NUMBER := 35;
41 G_ROUNDING_FACTOR CONSTANT NUMBER := 36;
42 G_SHIP_METHOD CONSTANT NUMBER := 37;
43 G_START_DATE_ACTIVE CONSTANT NUMBER := 38;
44 G_TERMS CONSTANT NUMBER := 39;
45 G_NAME CONSTANT NUMBER := 40;
46 G_DESCRIPTION CONSTANT NUMBER := 41;
47 G_VERSION_NO CONSTANT NUMBER := 42;
48 G_ACTIVE_FLAG CONSTANT NUMBER := 43;
49 G_MAX_ATTR_ID CONSTANT NUMBER := 44;
50 G_MOBILE_DOWNLOAD CONSTANT NUMBER := 45; --mkarya for bug 1944882
51 G_CURRENCY_HEADER CONSTANT NUMBER := 46; -- Multi-Currency SunilPandey
52 G_PTE CONSTANT NUMBER := 47; -- Attributes Manager Giri
53 G_LIST_SOURCE CONSTANT NUMBER := 48; -- Blanket Sales Order
54 ORIG_SYSTEM_HEADER_REF CONSTANT NUMBER := 49; -- Blanket Sales Order
55 G_GLOBAL_FLAG CONSTANT NUMBER := 50; -- Pricing Security gtippire
56 G_SHAREABLE_FLAG CONSTANT NUMBER := 51;
57 G_SOLD_TO_ORG_ID CONSTANT NUMBER := 52;
58 G_SOURCE_SYSTEM_CODE CONSTANT NUMBER := 53;
59 G_LOCKED_FROM_LIST_HEADER CONSTANT NUMBER := 54;
60 --added for MOAC
61 G_ORG_ID CONSTANT NUMBER := 55;
62
63
64 -- Procedure Clear_Dependent_Attr
65
66 PROCEDURE Clear_Dependent_Attr
67 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
68 , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
69 , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
70 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
71 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
72 );
73
74 -- Procedure Apply_Attribute_Changes
75
76 PROCEDURE Apply_Attribute_Changes
77 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
78 , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
79 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
80 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
81 );
82
83 -- Function Complete_Record
84
85 FUNCTION Complete_Record
86 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
87 , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
88 ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
89
90 -- Function Convert_Miss_To_Null
91
92 FUNCTION Convert_Miss_To_Null
93 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
94 ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
95
96 -- Procedure Update_Row
97
98 PROCEDURE Update_Row
99 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
100 );
101
102 -- Procedure Insert_Row
103
104 PROCEDURE Insert_Row
105 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
106 );
107
108 -- Procedure Delete_Row
109
110 PROCEDURE Delete_Row
111 ( p_list_header_id IN NUMBER
112 );
113
114 -- Function Query_Row
115
116 FUNCTION Query_Row
117 ( p_list_header_id IN NUMBER
118 ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
119
120 -- Procedure lock_Row
121 --
122
123 PROCEDURE Lock_Row
124 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
126 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
127 );
128
129 -- Function Get_Values
130
131 FUNCTION Get_Values
132 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
133 , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
134 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
135 ) RETURN QP_Price_List_PUB.Price_List_Val_Rec_Type;
136
137 -- Function Get_Ids
138
139 FUNCTION Get_Ids
140 ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
141 , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
142 ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
143
144
145 --ENH Upgrade BOAPI for orig_sys...ref RAVI
146 FUNCTION Get_Orig_Sys_Hdr(
147 p_LIST_HEADER_ID NUMBER
148 ) RETURN VARCHAR2;
149
150
151 END QP_Price_List_Util;