7: TYPE translate_bb_ids_tab IS TABLE OF translate_bb_ids_rec
8: INDEX BY BINARY_INTEGER;
9:
10: TYPE translate_ta_ids_rec IS RECORD (
11: actual_ta_id hxc_time_attributes.time_attribute_id%TYPE);
12:
13: TYPE translate_ta_ids_tab IS TABLE OF translate_ta_ids_rec
14: INDEX BY BINARY_INTEGER;
15:
24: message_tokens VARCHAR2 (4000), -- Bug 3036930
25: application_short_name fnd_application.application_short_name%TYPE,
26: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
27: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
28: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
29: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
30: on_oa_msg_stack BOOLEAN := FALSE, --AI5
31: message_extent VARCHAR2 (20) --Bug#2873563
32: );
25: application_short_name fnd_application.application_short_name%TYPE,
26: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
27: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
28: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
29: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
30: on_oa_msg_stack BOOLEAN := FALSE, --AI5
31: message_extent VARCHAR2 (20) --Bug#2873563
32: );
33:
34: TYPE message_table IS TABLE OF message_info
35: INDEX BY BINARY_INTEGER;
36:
37: TYPE attribute_info IS RECORD (
38: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
39: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
40: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
38: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
39: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
40: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
39: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
40: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
40: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
44: attribute3 hxc_time_attributes.attribute3%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
45: attribute4 hxc_time_attributes.attribute4%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
46: attribute5 hxc_time_attributes.attribute5%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
47: attribute6 hxc_time_attributes.attribute6%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
48: attribute7 hxc_time_attributes.attribute7%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
49: attribute8 hxc_time_attributes.attribute8%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
50: attribute9 hxc_time_attributes.attribute9%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
51: attribute10 hxc_time_attributes.attribute10%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
52: attribute11 hxc_time_attributes.attribute11%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
53: attribute12 hxc_time_attributes.attribute12%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
54: attribute13 hxc_time_attributes.attribute13%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
55: attribute14 hxc_time_attributes.attribute14%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
56: attribute15 hxc_time_attributes.attribute15%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
57: attribute16 hxc_time_attributes.attribute16%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
58: attribute17 hxc_time_attributes.attribute17%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
59: attribute18 hxc_time_attributes.attribute18%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
60: attribute19 hxc_time_attributes.attribute19%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
61: attribute20 hxc_time_attributes.attribute20%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
62: attribute21 hxc_time_attributes.attribute21%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
63: attribute22 hxc_time_attributes.attribute22%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
64: attribute23 hxc_time_attributes.attribute23%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
65: attribute24 hxc_time_attributes.attribute24%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
73: object_version_number hxc_time_attributes.object_version_number%TYPE,
66: attribute25 hxc_time_attributes.attribute25%TYPE,
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
73: object_version_number hxc_time_attributes.object_version_number%TYPE,
74: NEW VARCHAR2 (30),
67: attribute26 hxc_time_attributes.attribute26%TYPE,
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
73: object_version_number hxc_time_attributes.object_version_number%TYPE,
74: NEW VARCHAR2 (30),
75: changed VARCHAR2 (30),
68: attribute27 hxc_time_attributes.attribute27%TYPE,
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
73: object_version_number hxc_time_attributes.object_version_number%TYPE,
74: NEW VARCHAR2 (30),
75: changed VARCHAR2 (30),
76: process VARCHAR2 (30));
69: attribute28 hxc_time_attributes.attribute28%TYPE,
70: attribute29 hxc_time_attributes.attribute29%TYPE,
71: attribute30 hxc_time_attributes.attribute30%TYPE,
72: bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
73: object_version_number hxc_time_attributes.object_version_number%TYPE,
74: NEW VARCHAR2 (30),
75: changed VARCHAR2 (30),
76: process VARCHAR2 (30));
77:
78: TYPE building_block_attribute_info IS TABLE OF attribute_info
79: INDEX BY BINARY_INTEGER;
80:
81: TYPE app_attributes IS RECORD (
82: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
83: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
84: attribute_name hxc_mapping_components.field_name%TYPE,
85: attribute_value hxc_time_attributes.attribute1%TYPE,
86: attribute_index number,
81: TYPE app_attributes IS RECORD (
82: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
83: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
84: attribute_name hxc_mapping_components.field_name%TYPE,
85: attribute_value hxc_time_attributes.attribute1%TYPE,
86: attribute_index number,
87: segment hxc_mapping_components.segment%type,
88: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
89: CATEGORY hxc_bld_blk_info_type_usages.building_block_category%TYPE,