[Home] [Help]
PACKAGE: APPS.QP_LIMITS_UTIL
Source
1 PACKAGE QP_Limits_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXULMTS.pls 120.1.12000000.1 2007/01/17 22:31:17 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_AMOUNT 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_BASIS 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_LAST_UPDATED_BY CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_DATE CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 23;
29 G_LIMIT_EXCEED_ACTION CONSTANT NUMBER := 24;
30 G_LIMIT CONSTANT NUMBER := 25;
31 G_LIMIT_LEVEL CONSTANT NUMBER := 26;
32 G_LIMIT_NUMBER CONSTANT NUMBER := 27;
33 G_LIST_HEADER CONSTANT NUMBER := 28;
34 G_LIST_LINE CONSTANT NUMBER := 29;
35 G_ORGANIZATION 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_REQUEST CONSTANT NUMBER := 34;
40 G_MAX_ATTR_ID CONSTANT NUMBER := 35;
41 G_LIMIT_HOLD CONSTANT NUMBER := 36;
42 G_MULTIVAL_ATTR1_TYPE CONSTANT NUMBER := 37;
43 G_MULTIVAL_ATTR1_CONTEXT CONSTANT NUMBER := 38;
44 G_MULTIVAL_ATTRIBUTE1 CONSTANT NUMBER := 39;
45 G_MULTIVAL_ATTR1_DATATYPE CONSTANT NUMBER := 40;
46 G_MULTIVAL_ATTR2_TYPE CONSTANT NUMBER := 41;
47 G_MULTIVAL_ATTR2_CONTEXT CONSTANT NUMBER := 42;
48 G_MULTIVAL_ATTRIBUTE2 CONSTANT NUMBER := 43;
49 G_MULTIVAL_ATTR2_DATATYPE 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_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57 QP_Limits_PUB.G_MISS_LIMITS_REC
58 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59 );
60
61 -- Procedure Apply_Attribute_Changes
62
63 PROCEDURE Apply_Attribute_Changes
64 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66 QP_Limits_PUB.G_MISS_LIMITS_REC
67 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68 );
69
70 -- Function Complete_Record
71
72 FUNCTION Complete_Record
73 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75 ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76
77 -- Function Convert_Miss_To_Null
78
79 FUNCTION Convert_Miss_To_Null
80 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
81 ) RETURN QP_Limits_PUB.Limits_Rec_Type;
82
83 -- Procedure Update_Row
84
85 PROCEDURE Update_Row
86 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
87 );
88
89 -- Procedure Insert_Row
90
91 PROCEDURE Insert_Row
92 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
93 );
94
95 -- Procedure Delete_Row
96
97 PROCEDURE Delete_Row
98 ( p_limit_id IN NUMBER
99 );
100
101 -- Function Query_Row
102
103 FUNCTION Query_Row
104 ( p_limit_id IN NUMBER
105 ) RETURN QP_Limits_PUB.Limits_Rec_Type;
106
107 -- Procedure lock_Row
108 --
109
110 PROCEDURE Lock_Row
111 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
113 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
114 );
115
116 -- Function Get_Values
117
118 FUNCTION Get_Values
119 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121 QP_Limits_PUB.G_MISS_LIMITS_REC
122 ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123
124 -- Function Get_Ids
125
126 FUNCTION Get_Ids
127 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128 , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129 ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130
131 Procedure Pre_Write_Process
132 ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134 QP_Limits_PUB.G_MISS_LIMITS_REC
135 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136 );
137
138
139 END QP_Limits_Util;