[Home] [Help]
PACKAGE: APPS.QP_CURR_LISTS_UTIL
Source
1 PACKAGE QP_Curr_Lists_Util AS
2 /* $Header: QPXUCURS.pls 120.1 2005/06/10 00:00:24 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_BASE_CURRENCY CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATION_DATE CONSTANT NUMBER := 19;
25 G_CURRENCY_HEADER CONSTANT NUMBER := 20;
26 G_DESCRIPTION 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_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_BASE_MARKUP_FORMULA CONSTANT NUMBER := 30;
36 G_BASE_MARKUP_OPERATOR CONSTANT NUMBER := 31;
37 G_BASE_MARKUP_VALUE CONSTANT NUMBER := 32;
38 G_BASE_ROUNDING_FACTOR CONSTANT NUMBER := 33;
39 G_ROW CONSTANT NUMBER := 34;
40 G_MAX_ATTR_ID CONSTANT NUMBER := 35;
41
42 -- Procedure Clear_Dependent_Attr
43
44 PROCEDURE Clear_Dependent_Attr
45 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46 , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
47 , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
48 QP_Currency_PUB.G_MISS_CURR_LISTS_REC
49 , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
50 );
51
52 -- Procedure Apply_Attribute_Changes
53
54 PROCEDURE Apply_Attribute_Changes
55 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
56 , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
57 QP_Currency_PUB.G_MISS_CURR_LISTS_REC
58 , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
59 );
60
61 -- Function Complete_Record
62
63 FUNCTION Complete_Record
64 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
65 , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
66 ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
67
68 -- Function Convert_Miss_To_Null
69
70 FUNCTION Convert_Miss_To_Null
71 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
72 ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
73
74 -- Procedure Update_Row
75
76 PROCEDURE Update_Row
77 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
78 );
79
80 -- Procedure Insert_Row
81
82 PROCEDURE Insert_Row
83 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
84 );
85
86 -- Procedure Delete_Row
87
88 PROCEDURE Delete_Row
89 ( p_currency_header_id IN NUMBER
90 );
91
92 -- Function Query_Row
93
94 FUNCTION Query_Row
95 ( p_currency_header_id IN NUMBER
96 ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
97
98 -- Procedure lock_Row
99 --
100
101 PROCEDURE Lock_Row
102 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
104 , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
105 );
106
107 -- Function Get_Values
108
109 FUNCTION Get_Values
110 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
111 , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
112 QP_Currency_PUB.G_MISS_CURR_LISTS_REC
113 ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
114
115 -- Function Get_Ids
116
117 FUNCTION Get_Ids
118 ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
119 , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
120 ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
121
122 END QP_Curr_Lists_Util;