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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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
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
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,
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
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: );
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:
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;
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