13:
14: -- Definition of all the entities
15: TYPE header_rec_type IS RECORD
16: (
17: period_id cm_cmpt_dtl.period_id%TYPE,
18: calendar_code cm_cldr_hdr_b.calendar_code%TYPE,
19: period_code cm_cldr_dtl.period_code%TYPE,
20: cost_type_id cm_cmpt_dtl.cost_type_id%TYPE,
21: cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE,
16: (
17: period_id cm_cmpt_dtl.period_id%TYPE,
18: calendar_code cm_cldr_hdr_b.calendar_code%TYPE,
19: period_code cm_cldr_dtl.period_code%TYPE,
20: cost_type_id cm_cmpt_dtl.cost_type_id%TYPE,
21: cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE,
22: organization_id cm_cmpt_dtl.organization_id%TYPE,
23: organization_code mtl_parameters.organization_code%TYPE,
24: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
18: calendar_code cm_cldr_hdr_b.calendar_code%TYPE,
19: period_code cm_cldr_dtl.period_code%TYPE,
20: cost_type_id cm_cmpt_dtl.cost_type_id%TYPE,
21: cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE,
22: organization_id cm_cmpt_dtl.organization_id%TYPE,
23: organization_code mtl_parameters.organization_code%TYPE,
24: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
25: item_number mtl_item_flexfields.item_number%TYPE,
26: user_name fnd_user.user_name%TYPE
20: cost_type_id cm_cmpt_dtl.cost_type_id%TYPE,
21: cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE,
22: organization_id cm_cmpt_dtl.organization_id%TYPE,
23: organization_code mtl_parameters.organization_code%TYPE,
24: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
25: item_number mtl_item_flexfields.item_number%TYPE,
26: user_name fnd_user.user_name%TYPE
27: );
28:
30: (
31: cmpntcost_id NUMBER,
32: cost_cmpntcls_id NUMBER,
33: cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE,
34: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
35: cmpnt_cost NUMBER,
36: burden_ind NUMBER,
37: total_qty NUMBER,
38: costcalc_orig NUMBER,
37: total_qty NUMBER,
38: costcalc_orig NUMBER,
39: rmcalc_type NUMBER,
40: delete_mark NUMBER,
41: attribute1 cm_cmpt_dtl.attribute1%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
38: costcalc_orig NUMBER,
39: rmcalc_type NUMBER,
40: delete_mark NUMBER,
41: attribute1 cm_cmpt_dtl.attribute1%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
39: rmcalc_type NUMBER,
40: delete_mark NUMBER,
41: attribute1 cm_cmpt_dtl.attribute1%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
40: delete_mark NUMBER,
41: attribute1 cm_cmpt_dtl.attribute1%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
41: attribute1 cm_cmpt_dtl.attribute1%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
42: attribute2 cm_cmpt_dtl.attribute2%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
43: attribute3 cm_cmpt_dtl.attribute3%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
44: attribute4 cm_cmpt_dtl.attribute4%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
45: attribute5 cm_cmpt_dtl.attribute5%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
46: attribute6 cm_cmpt_dtl.attribute6%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
47: attribute7 cm_cmpt_dtl.attribute7%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
48: attribute8 cm_cmpt_dtl.attribute8%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
49: attribute9 cm_cmpt_dtl.attribute9%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
50: attribute10 cm_cmpt_dtl.attribute10%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
51: attribute11 cm_cmpt_dtl.attribute11%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
52: attribute12 cm_cmpt_dtl.attribute12%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
53: attribute13 cm_cmpt_dtl.attribute13%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
54: attribute14 cm_cmpt_dtl.attribute14%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
55: attribute15 cm_cmpt_dtl.attribute15%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
56: attribute16 cm_cmpt_dtl.attribute16%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
57: attribute17 cm_cmpt_dtl.attribute17%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
58: attribute18 cm_cmpt_dtl.attribute18%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
59: attribute19 cm_cmpt_dtl.attribute19%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
60: attribute20 cm_cmpt_dtl.attribute20%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
61: attribute21 cm_cmpt_dtl.attribute21%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
62: attribute22 cm_cmpt_dtl.attribute22%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
63: attribute23 cm_cmpt_dtl.attribute23%TYPE,
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
71: attribute_category cm_cmpt_dtl.attribute_category%TYPE
64: attribute24 cm_cmpt_dtl.attribute24%TYPE,
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
71: attribute_category cm_cmpt_dtl.attribute_category%TYPE
72: );
65: attribute25 cm_cmpt_dtl.attribute25%TYPE,
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
71: attribute_category cm_cmpt_dtl.attribute_category%TYPE
72: );
73:
66: attribute26 cm_cmpt_dtl.attribute26%TYPE,
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
71: attribute_category cm_cmpt_dtl.attribute_category%TYPE
72: );
73:
74: TYPE this_level_dtl_tbl_type IS TABLE OF this_level_dtl_rec_type INDEX BY BINARY_INTEGER;
67: attribute27 cm_cmpt_dtl.attribute27%TYPE,
68: attribute28 cm_cmpt_dtl.attribute28%TYPE,
69: attribute29 cm_cmpt_dtl.attribute29%TYPE,
70: attribute30 cm_cmpt_dtl.attribute30%TYPE,
71: attribute_category cm_cmpt_dtl.attribute_category%TYPE
72: );
73:
74: TYPE this_level_dtl_tbl_type IS TABLE OF this_level_dtl_rec_type INDEX BY BINARY_INTEGER;
75:
77: (
78: cmpntcost_id NUMBER,
79: cost_cmpntcls_id NUMBER,
80: cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE,
81: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
82: cmpnt_cost NUMBER,
83: delete_mark NUMBER
84: );
85:
87:
88: TYPE costcmpnt_ids_rec_type IS RECORD
89: (
90: cost_cmpntcls_id NUMBER,
91: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
92: cost_level NUMBER,
93: cmpntcost_id NUMBER
94: );
95: