58: hr_utility.set_location('Entering:'||l_proc,10);
59: end if;
60: --
61: if ((p_rec.time_entry_rule_id is not null) and (
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
59: end if;
60: --
61: if ((p_rec.time_entry_rule_id is not null) and (
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
60: --
61: if ((p_rec.time_entry_rule_id is not null) and (
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
61: if ((p_rec.time_entry_rule_id is not null) and (
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
63: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
64: nvl(hxc_ter_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
65: nvl(p_rec.attribute1, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
66: nvl(hxc_ter_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
67: nvl(p_rec.attribute2, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
68: nvl(hxc_ter_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
69: nvl(p_rec.attribute3, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
70: nvl(hxc_ter_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
71: nvl(p_rec.attribute4, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
72: nvl(hxc_ter_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
73: nvl(p_rec.attribute5, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
74: nvl(hxc_ter_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
75: nvl(p_rec.attribute6, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
76: nvl(hxc_ter_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
77: nvl(p_rec.attribute7, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
78: nvl(hxc_ter_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
79: nvl(p_rec.attribute8, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
80: nvl(hxc_ter_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
81: nvl(p_rec.attribute9, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
82: nvl(hxc_ter_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
83: nvl(p_rec.attribute10, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
84: nvl(hxc_ter_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
85: nvl(p_rec.attribute11, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
86: nvl(hxc_ter_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
87: nvl(p_rec.attribute12, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
88: nvl(hxc_ter_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
89: nvl(p_rec.attribute13, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
90: nvl(hxc_ter_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
91: nvl(p_rec.attribute14, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
92: nvl(hxc_ter_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
93: nvl(p_rec.attribute15, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
94: nvl(hxc_ter_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
95: nvl(p_rec.attribute16, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
96: nvl(hxc_ter_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
97: nvl(p_rec.attribute17, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
98: nvl(hxc_ter_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
99: nvl(p_rec.attribute18, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
100: nvl(hxc_ter_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
101: nvl(p_rec.attribute19, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
102: nvl(hxc_ter_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
103: nvl(p_rec.attribute20, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
104: nvl(hxc_ter_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
105: nvl(p_rec.attribute21, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
106: nvl(hxc_ter_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
107: nvl(p_rec.attribute22, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
108: nvl(hxc_ter_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
109: nvl(p_rec.attribute23, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
110: nvl(hxc_ter_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
111: nvl(p_rec.attribute24, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
112: nvl(hxc_ter_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
113: nvl(p_rec.attribute25, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
114: nvl(hxc_ter_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
115: nvl(p_rec.attribute26, hr_api.g_varchar2) or
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
123: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
116: nvl(hxc_ter_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
123: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
124: or (p_rec.time_entry_rule_id is null) then
117: nvl(p_rec.attribute27, hr_api.g_varchar2) or
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
123: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
124: or (p_rec.time_entry_rule_id is null) then
125: --
118: nvl(hxc_ter_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
123: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
124: or (p_rec.time_entry_rule_id is null) then
125: --
126: -- Only execute the validation if absolutely necessary:
119: nvl(p_rec.attribute28, hr_api.g_varchar2) or
120: nvl(hxc_ter_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
121: nvl(p_rec.attribute29, hr_api.g_varchar2) or
122: nvl(hxc_ter_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
123: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
124: or (p_rec.time_entry_rule_id is null) then
125: --
126: -- Only execute the validation if absolutely necessary:
127: -- a) During update, the structure column value or any
254: -- not been updated.
255: --
256: EXCEPTION
257: WHEN l_error THEN
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => l_argument);
261: WHEN OTHERS THEN
262: RAISE;
1105: ,p_bg_id => p_rec.business_group_id
1106: );
1107: --
1108: if p_rec.business_group_id is not null then
1109: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1110: end if;
1111: -- Validate the legislation_code
1112: chk_legislation_code
1113: (p_business_group_id => p_rec.business_group_id,
1220: );
1221: --
1222: --
1223: if p_rec.business_group_id is not null then
1224: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1225: end if;
1226: -- Validate the legislation_code
1227: chk_legislation_code
1228: (p_business_group_id => p_rec.business_group_id,