[Home] [Help]
PACKAGE: APPS.AS_MULTI_CURRENCIES_PKG
Source
1 PACKAGE AS_MULTI_CURRENCIES_PKG as
2 /* $Header: asxtmcps.pls 120.1 2005/06/05 22:53:15 appldev $ */
3 -- Start of Comments
4 -- Package name : AS_MULTI_CURRENCIES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name: TYPE_MAPPINGS_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- PERIOD_SET_NAME
19 -- PERIOD_TYPE
20 -- CONVERSION_TYPE
21 -- DESCRIPTION
22 -- UPDATEABLE_FLAG
23 -- DELETEABLE_FLAG
24 -- LAST_UPDATE_DATE
25 -- LAST_UPDATED_BY
26 -- CREATION_DATE
27 -- CREATED_BY
28 -- LAST_UPDATE_LOGIN
29 -- SECURITY_GROUP_ID
30 --
31 -- Required:
32 -- Defaults:
33 -- Note: This record maps to AS_MC_TYPE_MAPPINGS table.
34 --
35 -- End of Comments
36
37 TYPE TYPE_MAPPINGS_Rec_Type IS RECORD
38 (
39 PERIOD_SET_NAME VARCHAR2(15) := FND_API.G_MISS_CHAR,
40 PERIOD_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
41 CONVERSION_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42 DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
43 UPDATEABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
44 DELETEABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47 CREATION_DATE DATE := FND_API.G_MISS_DATE,
48 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
49 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
50 SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
51 );
52
53 G_MISS_TYPE_MAPPINGS_REC TYPE_MAPPINGS_Rec_Type;
54 TYPE TYPE_MAPPINGS_Tbl_Type IS TABLE OF TYPE_MAPPINGS_Rec_Type
55 INDEX BY BINARY_INTEGER;
56 G_MISS_TYPE_MAPPINGS_TBL TYPE_MAPPINGS_Tbl_Type;
57
58 -- *******************************************************
59 -- Start of Comments
60 -- -------------------------------------------------------
61 -- Record name: PERIOD_RATES_Rec_Type
62 -- -------------------------------------------------------
63 -- Parameters:
64 -- FROM_CURRENCY
65 -- TO_CURRENCY
66 -- CONVERSION_DATE
67 -- USER_CONVERSION_TYPE
68 -- CONVERSION_RATE
69 -- MODE_FLAG
70 -- INVERSE_CONVERSION_RATE
71 --
72 -- Required:
73 -- Defaults:
74 -- Note: This record is basically mapping to GL_DAILY_RATES_INTERFACE table.
75 --
76 -- End of Comments
77
78 TYPE PERIOD_RATES_Rec_Type IS RECORD
79 (
80 FROM_CURRENCY VARCHAR2(15) := FND_API.G_MISS_CHAR,
81 TO_CURRENCY VARCHAR2(15) := FND_API.G_MISS_CHAR,
82 CONVERSION_DATE DATE := FND_API.G_MISS_DATE,
83 CONVERSION_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84 CONVERSION_RATE NUMBER := FND_API.G_MISS_NUM
85 -- MODE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
86 -- INVERSE_CONVERSION_RATE NUMBER := FND_API.G_MISS_NUM
87 );
88
89 G_MISS_PERIOD_RATES_REC PERIOD_RATES_Rec_Type;
90 TYPE PERIOD_RATES_Tbl_Type IS TABLE OF PERIOD_RATES_Rec_Type
91 INDEX BY BINARY_INTEGER;
92 G_MISS_PERIOD_RATES_TBL PERIOD_RATES_Tbl_Type;
93
94 PROCEDURE Insert_Type_Mappings(
95 p_TYPE_MAPPINGS_TBL IN TYPE_MAPPINGS_Tbl_Type
96 DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
97 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
99 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
100
101 PROCEDURE Update_Type_Mappings(
102 p_TYPE_MAPPINGS_TBL IN TYPE_MAPPINGS_Tbl_Type
103 DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
104 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
105 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
106 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
107
108 PROCEDURE Delete_Type_Mappings(
109 p_TYPE_MAPPINGS_TBL IN TYPE_MAPPINGS_Tbl_Type
110 DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
111 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
113 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
114
115 PROCEDURE Insert_Period_Rates(
116 p_PERIOD_RATES_TBL IN PERIOD_RATES_Tbl_Type
117 DEFAULT G_MISS_PERIOD_RATES_TBL,
118 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
120 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
121
122 PROCEDURE Update_Period_Rates(
123 p_PERIOD_RATES_TBL IN PERIOD_RATES_Tbl_Type
124 DEFAULT G_MISS_PERIOD_RATES_TBL,
125 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
126 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
127 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
128
129 PROCEDURE Delete_Period_Rates(
130 p_PERIOD_RATES_TBL IN PERIOD_RATES_Tbl_Type
131 DEFAULT G_MISS_PERIOD_RATES_TBL,
132 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
133 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
134 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
135
136 End AS_MULTI_CURRENCIES_PKG;