41: message_tokens VARCHAR2 (240), -- Bug 3036930
42: application_short_name fnd_application.application_short_name%TYPE,
43: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
45: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
46: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
47: on_oa_msg_stack BOOLEAN := FALSE, --AI5
48: message_extent VARCHAR2 (20) --Bug#2873563
49: );
42: application_short_name fnd_application.application_short_name%TYPE,
43: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
45: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
46: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
47: on_oa_msg_stack BOOLEAN := FALSE, --AI5
48: message_extent VARCHAR2 (20) --Bug#2873563
49: );
50:
55: --
56: -- APP_ATTRIBUTES
57: --
58: TYPE app_attributes IS RECORD (
59: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
60: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
61: attribute_name hxc_mapping_components.field_name%TYPE,
62: attribute_value hxc_time_attributes.attribute1%TYPE,
63: attribute_index number,
58: TYPE app_attributes IS RECORD (
59: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
60: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
61: attribute_name hxc_mapping_components.field_name%TYPE,
62: attribute_value hxc_time_attributes.attribute1%TYPE,
63: attribute_index number,
64: segment hxc_mapping_components.segment%type,
65: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
66: CATEGORY hxc_bld_blk_info_type_usages.building_block_category%TYPE,
75: --
76: -- ATTRIBUTES
77: --
78: TYPE attribute_info IS RECORD (
79: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
80: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
81: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
82: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
79: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
80: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
81: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
82: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
80: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
81: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
82: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
81: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
82: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
82: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
83: attribute1 hxc_time_attributes.attribute1%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
84: attribute2 hxc_time_attributes.attribute2%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
85: attribute3 hxc_time_attributes.attribute3%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
86: attribute4 hxc_time_attributes.attribute4%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
87: attribute5 hxc_time_attributes.attribute5%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
88: attribute6 hxc_time_attributes.attribute6%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
89: attribute7 hxc_time_attributes.attribute7%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
90: attribute8 hxc_time_attributes.attribute8%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
91: attribute9 hxc_time_attributes.attribute9%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
92: attribute10 hxc_time_attributes.attribute10%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
93: attribute11 hxc_time_attributes.attribute11%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
94: attribute12 hxc_time_attributes.attribute12%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
95: attribute13 hxc_time_attributes.attribute13%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
96: attribute14 hxc_time_attributes.attribute14%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
97: attribute15 hxc_time_attributes.attribute15%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
98: attribute16 hxc_time_attributes.attribute16%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
99: attribute17 hxc_time_attributes.attribute17%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
100: attribute18 hxc_time_attributes.attribute18%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
101: attribute19 hxc_time_attributes.attribute19%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
102: attribute20 hxc_time_attributes.attribute20%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
103: attribute21 hxc_time_attributes.attribute21%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
104: attribute22 hxc_time_attributes.attribute22%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
105: attribute23 hxc_time_attributes.attribute23%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
106: attribute24 hxc_time_attributes.attribute24%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114: object_version_number hxc_time_attributes.object_version_number%TYPE,
107: attribute25 hxc_time_attributes.attribute25%TYPE,
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114: object_version_number hxc_time_attributes.object_version_number%TYPE,
115: NEW VARCHAR2 (30),
108: attribute26 hxc_time_attributes.attribute26%TYPE,
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114: object_version_number hxc_time_attributes.object_version_number%TYPE,
115: NEW VARCHAR2 (30),
116: changed VARCHAR2 (30),
109: attribute27 hxc_time_attributes.attribute27%TYPE,
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114: object_version_number hxc_time_attributes.object_version_number%TYPE,
115: NEW VARCHAR2 (30),
116: changed VARCHAR2 (30),
117: process VARCHAR2 (30));
110: attribute28 hxc_time_attributes.attribute28%TYPE,
111: attribute29 hxc_time_attributes.attribute29%TYPE,
112: attribute30 hxc_time_attributes.attribute30%TYPE,
113: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114: object_version_number hxc_time_attributes.object_version_number%TYPE,
115: NEW VARCHAR2 (30),
116: changed VARCHAR2 (30),
117: process VARCHAR2 (30));
118:
152:
153: TYPE r_time_attributes IS RECORD (
154: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
155: ,field_name hxc_mapping_components.field_name%TYPE
156: ,value hxc_time_attributes.attribute1%TYPE
157: ,context hxc_bld_blk_info_types.bld_blk_info_type%TYPE
158: ,category hxc_bld_blk_info_type_usages.building_block_category%TYPE );
159:
160: TYPE t_time_attribute