[Home] [Help]
PACKAGE: APPS.QP_FORMULA_UTIL
Source
1 PACKAGE QP_Formula_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPRFS.pls 120.1 2005/06/12 22:48:48 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_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_DESCRIPTION CONSTANT NUMBER := 19;
25 G_END_DATE_ACTIVE CONSTANT NUMBER := 20;
26 G_FORMULA 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_NAME CONSTANT NUMBER := 25;
31 G_PRICE_FORMULA CONSTANT NUMBER := 26;
32 G_START_DATE_ACTIVE CONSTANT NUMBER := 27;
33 G_MAX_ATTR_ID CONSTANT NUMBER := 28;
34
35 -- Procedure Clear_Dependent_Attr
36
37 PROCEDURE Clear_Dependent_Attr
38 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39 , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40 , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43 );
44
45 -- Procedure Apply_Attribute_Changes
46
47 PROCEDURE Apply_Attribute_Changes
48 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49 , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52 );
53
54 -- Function Complete_Record
55
56 FUNCTION Complete_Record
57 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58 , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59 ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60
61 -- Function Convert_Miss_To_Null
62
63 FUNCTION Convert_Miss_To_Null
64 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
65 ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
66
67 -- Procedure Update_Row
68
69 PROCEDURE Update_Row
70 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
71 );
72
73 -- Procedure Insert_Row
74
75 PROCEDURE Insert_Row
76 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
77 );
78
79 -- Procedure Delete_Row
80
81 PROCEDURE Delete_Row
82 ( p_price_formula_id IN NUMBER
83 );
84
85 -- Function Query_Row
86
87 FUNCTION Query_Row
88 ( p_price_formula_id IN NUMBER
89 ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
90
91 -- Procedure lock_Row
92 --
93
94 PROCEDURE Lock_Row
95 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
97 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
98 );
99
100 -- Function Get_Values
101
102 FUNCTION Get_Values
103 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104 , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106 ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107
108 -- Function Get_Ids
109
110 FUNCTION Get_Ids
111 ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112 , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113 ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114
115 END QP_Formula_Util;