12: effective_date date
13: );
14:
15: type ghr_mass_custom_out_rec_type is record
16: (user_attribute1 ghr_mass_actions_preview.user_attribute1%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
13: );
14:
15: type ghr_mass_custom_out_rec_type is record
16: (user_attribute1 ghr_mass_actions_preview.user_attribute1%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
14:
15: type ghr_mass_custom_out_rec_type is record
16: (user_attribute1 ghr_mass_actions_preview.user_attribute1%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
15: type ghr_mass_custom_out_rec_type is record
16: (user_attribute1 ghr_mass_actions_preview.user_attribute1%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
16: (user_attribute1 ghr_mass_actions_preview.user_attribute1%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
17: ,user_attribute2 ghr_mass_actions_preview.user_attribute2%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
18: ,user_attribute3 ghr_mass_actions_preview.user_attribute3%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
19: ,user_attribute4 ghr_mass_actions_preview.user_attribute4%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
20: ,user_attribute5 ghr_mass_actions_preview.user_attribute5%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
21: ,user_attribute6 ghr_mass_actions_preview.user_attribute6%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
22: ,user_attribute7 ghr_mass_actions_preview.user_attribute7%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
23: ,user_attribute8 ghr_mass_actions_preview.user_attribute8%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
24: ,user_attribute9 ghr_mass_actions_preview.user_attribute9%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
25: ,user_attribute10 ghr_mass_actions_preview.user_attribute10%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
26: ,user_attribute11 ghr_mass_actions_preview.user_attribute11%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
27: ,user_attribute12 ghr_mass_actions_preview.user_attribute12%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
28: ,user_attribute13 ghr_mass_actions_preview.user_attribute13%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
29: ,user_attribute14 ghr_mass_actions_preview.user_attribute14%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
30: ,user_attribute15 ghr_mass_actions_preview.user_attribute15%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
31: ,user_attribute16 ghr_mass_actions_preview.user_attribute16%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
32: ,user_attribute17 ghr_mass_actions_preview.user_attribute17%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
33: ,user_attribute18 ghr_mass_actions_preview.user_attribute18%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
34: ,user_attribute19 ghr_mass_actions_preview.user_attribute19%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
35: ,user_attribute20 ghr_mass_actions_preview.user_attribute20%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
36: ,user_attribute21 ghr_mass_actions_preview.user_attribute21%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
37: ,user_attribute22 ghr_mass_actions_preview.user_attribute22%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
45: ,user_attribute30 ghr_mass_actions_preview.user_attribute30%type
38: ,user_attribute23 ghr_mass_actions_preview.user_attribute23%type
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
45: ,user_attribute30 ghr_mass_actions_preview.user_attribute30%type
46: );
39: ,user_attribute24 ghr_mass_actions_preview.user_attribute24%type
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
45: ,user_attribute30 ghr_mass_actions_preview.user_attribute30%type
46: );
47:
40: ,user_attribute25 ghr_mass_actions_preview.user_attribute25%type
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
45: ,user_attribute30 ghr_mass_actions_preview.user_attribute30%type
46: );
47:
48: procedure pre_insert ( p_cust_in_rec in ghr_mass_custom_in_rec_type,
41: ,user_attribute26 ghr_mass_actions_preview.user_attribute26%type
42: ,user_attribute27 ghr_mass_actions_preview.user_attribute27%type
43: ,user_attribute28 ghr_mass_actions_preview.user_attribute28%type
44: ,user_attribute29 ghr_mass_actions_preview.user_attribute29%type
45: ,user_attribute30 ghr_mass_actions_preview.user_attribute30%type
46: );
47:
48: procedure pre_insert ( p_cust_in_rec in ghr_mass_custom_in_rec_type,
49: p_cust_rec in out nocopy ghr_mass_custom_out_rec_type);