[Home] [Help]
PACKAGE: APPS.QP_LIMIT_BALANCES_UTIL
Source
1 PACKAGE QP_Limit_Balances_Util AS
2 /* $Header: QPXULMBS.pls 120.1 2005/06/10 02:15:10 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_AVAILABLE_AMOUNT CONSTANT NUMBER := 16;
22 G_CONSUMED_AMOUNT 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_BALANCE CONSTANT NUMBER := 24;
30 G_LIMIT CONSTANT NUMBER := 25;
31 G_PROGRAM_APPLICATION CONSTANT NUMBER := 26;
32 G_PROGRAM CONSTANT NUMBER := 27;
33 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 28;
34 G_REQUEST CONSTANT NUMBER := 29;
35 G_RESERVED_AMOUNT CONSTANT NUMBER := 30;
36 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
37 G_MULTIVAL_ATTR1_TYPE CONSTANT NUMBER := 32;
38 G_MULTIVAL_ATTR1_CONTEXT CONSTANT NUMBER := 33;
39 G_MULTIVAL_ATTRIBUTE1 CONSTANT NUMBER := 34;
40 G_MULTIVAL_ATTR1_VALUE CONSTANT NUMBER := 35;
41 G_MULTIVAL_ATTR1_DATATYPE CONSTANT NUMBER := 36;
42 G_MULTIVAL_ATTR2_TYPE CONSTANT NUMBER := 37;
43 G_MULTIVAL_ATTR2_CONTEXT CONSTANT NUMBER := 38;
44 G_MULTIVAL_ATTRIBUTE2 CONSTANT NUMBER := 39;
45 G_MULTIVAL_ATTR2_VALUE CONSTANT NUMBER := 40;
46 G_MULTIVAL_ATTR2_DATATYPE CONSTANT NUMBER := 41;
47 G_ORGANIZATION_ATTR_CONTEXT CONSTANT NUMBER := 42;
48 G_ORGANIZATION_ATTRIBUTE CONSTANT NUMBER := 43;
49 G_ORGANIZATION_ATTR_VALUE CONSTANT NUMBER := 44;
50
51
52 -- Procedure Clear_Dependent_Attr
53
54 PROCEDURE Clear_Dependent_Attr
55 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56 , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
57 , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
58 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
59 , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
60 );
61
62 -- Procedure Apply_Attribute_Changes
63
64 PROCEDURE Apply_Attribute_Changes
65 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
66 , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
67 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
68 , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
69 );
70
71 -- Function Complete_Record
72
73 FUNCTION Complete_Record
74 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
75 , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
76 ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
77
78 -- Function Convert_Miss_To_Null
79
80 FUNCTION Convert_Miss_To_Null
81 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
82 ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
83
84 -- Procedure Update_Row
85
86 PROCEDURE Update_Row
87 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
88 );
89
90 -- Procedure Insert_Row
91
92 PROCEDURE Insert_Row
93 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
94 );
95
96 -- Procedure Delete_Row
97
98 PROCEDURE Delete_Row
99 ( p_limit_balance_id IN NUMBER
100 );
101
102 -- Function Query_Row
103
104 FUNCTION Query_Row
105 ( p_limit_balance_id IN NUMBER
106 ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
107
108 -- Function Query_Rows
109
110 --
111
112 FUNCTION Query_Rows
113 ( p_limit_balance_id IN NUMBER :=
114 FND_API.G_MISS_NUM
115 , p_limit_id IN NUMBER :=
116 FND_API.G_MISS_NUM
117 ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type;
118
119 -- Procedure lock_Row
120 --
121
122 PROCEDURE Lock_Row
123 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
125 , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
126 );
127
128 -- Function Get_Values
129
130 FUNCTION Get_Values
131 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
132 , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
133 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
134 ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
135
136 -- Function Get_Ids
137
138 FUNCTION Get_Ids
139 ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
140 , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
141 ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
142
143 END QP_Limit_Balances_Util;