[Home] [Help]
PACKAGE: APPS.QP_CURR_DETAILS_UTIL
Source
1 PACKAGE QP_Curr_Details_Util AS
2 /* $Header: QPXUCDTS.pls 120.1.12010000.1 2008/07/28 11:56:22 appldev 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_CONTEXT CONSTANT NUMBER := 16;
22 G_CONVERSION_DATE CONSTANT NUMBER := 17;
23 G_CONVERSION_DATE_TYPE CONSTANT NUMBER := 18;
24 -- G_CONVERSION_METHOD CONSTANT NUMBER := 19;
25 G_CONVERSION_TYPE CONSTANT NUMBER := 19;
26 G_CREATED_BY CONSTANT NUMBER := 20;
27 G_CREATION_DATE CONSTANT NUMBER := 21;
28 G_CURRENCY_DETAIL CONSTANT NUMBER := 22;
29 G_CURRENCY_HEADER CONSTANT NUMBER := 23;
30 G_END_DATE_ACTIVE CONSTANT NUMBER := 24;
31 G_FIXED_VALUE CONSTANT NUMBER := 25;
32 G_LAST_UPDATED_BY CONSTANT NUMBER := 26;
33 G_LAST_UPDATE_DATE CONSTANT NUMBER := 27;
34 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 28;
35 G_MARKUP_FORMULA CONSTANT NUMBER := 29;
36 G_MARKUP_OPERATOR CONSTANT NUMBER := 30;
37 G_MARKUP_VALUE CONSTANT NUMBER := 31;
38 G_PRICE_FORMULA CONSTANT NUMBER := 32;
39 G_PROGRAM_APPLICATION CONSTANT NUMBER := 33;
40 G_PROGRAM CONSTANT NUMBER := 34;
41 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 35;
42 G_REQUEST CONSTANT NUMBER := 36;
43 G_ROUNDING_FACTOR CONSTANT NUMBER := 37;
44 G_START_DATE_ACTIVE CONSTANT NUMBER := 38;
45 G_TO_CURRENCY CONSTANT NUMBER := 39;
46 G_CURR_ATTRIBUTE_TYPE CONSTANT NUMBER := 40;
47 G_CURR_ATTRIBUTE_CONTEXT CONSTANT NUMBER := 41;
48 G_CURR_ATTRIBUTE CONSTANT NUMBER := 42;
49 G_CURR_ATTRIBUTE_VALUE CONSTANT NUMBER := 43;
50 G_PRECEDENCE CONSTANT NUMBER := 44;
51 G_MAX_ATTR_ID CONSTANT NUMBER := 45;
52 G_SELLING_ROUNDING_FACTOR CONSTANT NUMBER := 46;
53
54 -- Procedure Clear_Dependent_Attr
55
56 PROCEDURE Clear_Dependent_Attr
57 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
58 , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
59 , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
60 QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
61 , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
62 );
63
64 -- Procedure Apply_Attribute_Changes
65
66 PROCEDURE Apply_Attribute_Changes
67 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
68 , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
69 QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
70 , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
71 );
72
73 -- Function Complete_Record
74
75 FUNCTION Complete_Record
76 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
77 , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
78 ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
79
80 -- Function Convert_Miss_To_Null
81
82 FUNCTION Convert_Miss_To_Null
83 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
84 ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
85
86 -- Procedure Update_Row
87
88 PROCEDURE Update_Row
89 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
90 );
91
92 -- Procedure Insert_Row
93
94 PROCEDURE Insert_Row
95 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
96 );
97
98 -- Procedure Delete_Row
99
100 PROCEDURE Delete_Row
101 ( p_currency_detail_id IN NUMBER
102 );
103
104 -- Function Query_Row
105
106 FUNCTION Query_Row
107 ( p_currency_detail_id IN NUMBER
108 ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
109
110 -- Function Query_Rows
111
112 --
113
114 FUNCTION Query_Rows
115 ( p_currency_detail_id IN NUMBER :=
116 FND_API.G_MISS_NUM
117 , p_currency_header_id IN NUMBER :=
118 FND_API.G_MISS_NUM
119 ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type;
120
121 -- Procedure lock_Row
122 --
123
124 PROCEDURE Lock_Row
125 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
127 , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
128 );
129
130 -- Function Get_Values
131
132 FUNCTION Get_Values
133 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
134 , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
135 QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
136 ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type;
137
138 -- Function Get_Ids
139
140 FUNCTION Get_Ids
141 ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
142 , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
143 ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
144
145 END QP_Curr_Details_Util;