[Home] [Help]
PACKAGE: APPS.QP_PRICING_ATTR_UTIL
Source
1 PACKAGE QP_Pricing_Attr_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPRAS.pls 120.1.12010000.1 2008/07/28 11:57:23 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ACCUMULATE CONSTANT NUMBER := 1;
7 G_ATTRIBUTE1 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE10 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE11 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE12 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE13 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE14 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE15 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE2 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE3 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE4 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE5 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE6 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE7 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE8 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE9 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE_GROUPING_NO 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_EXCLUDER CONSTANT NUMBER := 21;
27 G_LAST_UPDATED_BY CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_DATE CONSTANT NUMBER := 23;
29 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 24;
30 G_LIST_LINE CONSTANT NUMBER := 25;
31 G_PRICING_ATTRIBUTE CONSTANT NUMBER := 26;
32 G_PRICING_ATTRIBUTE_CONTEXT CONSTANT NUMBER := 27;
33 --G_PRICING_ATTRIBUTE CONSTANT NUMBER := 28;
34 G_PRICING_ATTR_VALUE_FROM CONSTANT NUMBER := 29;
35 G_PRICING_ATTR_VALUE_TO CONSTANT NUMBER := 30;
36 G_PRODUCT_ATTRIBUTE CONSTANT NUMBER := 31;
37 G_PRODUCT_ATTRIBUTE_CONTEXT CONSTANT NUMBER := 32;
38 G_PRODUCT_ATTR_VALUE CONSTANT NUMBER := 33;
39 G_PRODUCT_UOM CONSTANT NUMBER := 34;
40 G_PROGRAM_APPLICATION CONSTANT NUMBER := 35;
41 G_PROGRAM CONSTANT NUMBER := 36;
42 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 37;
43 G_REQUEST CONSTANT NUMBER := 38;
44 G_PRODUCT_ATTRIBUTE_DATATYPE CONSTANT NUMBER := 39;
45 G_PRICING_ATTRIBUTE_DATATYPE CONSTANT NUMBER := 40;
46 G_COMPARISON_OPERATOR CONSTANT NUMBER := 41;
47 G_LIST_HEADER CONSTANT NUMBER := 42;
48 G_PRICING_PHASE CONSTANT NUMBER := 43;
49 G_MAX_ATTR_ID CONSTANT NUMBER := 44;
50
51 -- Procedure Clear_Dependent_Attr
52
53 PROCEDURE Clear_Dependent_Attr
54 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55 , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
56 , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
57 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
58 , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
59 );
60
61 -- Procedure Apply_Attribute_Changes
62
63 PROCEDURE Apply_Attribute_Changes
64 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
65 , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
66 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
67 , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
68 );
69
70 -- Function Complete_Record
71
72 FUNCTION Complete_Record
73 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
74 , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
75 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
76
77 -- Function Convert_Miss_To_Null
78
79 FUNCTION Convert_Miss_To_Null
80 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
81 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
82
83 -- Procedure Update_Row
84
85 PROCEDURE Update_Row
86 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
87 );
88
89 -- Procedure Insert_Row
90
91 PROCEDURE Insert_Row
92 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
93 );
94
95 -- Procedure Delete_Row
96
97 PROCEDURE Delete_Row
98 ( p_pricing_attribute_id IN NUMBER
99 );
100
101 -- Function Query_Row
102
103 FUNCTION Query_Row
104 ( p_pricing_attribute_id IN NUMBER
105 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
106
107 -- Function Query_Rows
108
109 --
110
111 FUNCTION Query_Rows
112 ( p_pricing_attribute_id IN NUMBER :=
113 FND_API.G_MISS_NUM
114 , p_list_line_id IN NUMBER :=
115 FND_API.G_MISS_NUM
116 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
117
118 -- Procedure lock_Row
119 --
120
121 PROCEDURE Lock_Row
122 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
124 , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
125 );
126
127 -- Function Get_Values
128
129 FUNCTION Get_Values
130 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
131 , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
132 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
133 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
134
135 -- Function Get_Ids
136
137 FUNCTION Get_Ids
138 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
139 , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type
140 ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141
142 Procedure Pre_Write_Process
143 ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144 , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
145 QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC
146 , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
147 );
148
149 END QP_Pricing_Attr_Util;