45: begin
46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
47: --
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.objective_id is null) then
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.objective_id is null) then
112: --
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.objective_id is null) then
112: --
113: -- Only execute the validation if absolutely necessary:
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.objective_id is null) then
112: --
113: -- Only execute the validation if absolutely necessary:
114: -- a) During update, the structure column value or any
275:
276: cursor chk_objective_name(c_p_valid_from date, c_p_valid_to date) is
277: select 'Y', nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')),nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
278: from per_objectives_library pml
279: where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)
280: and upper(trim(pml.objective_name)) = upper(trim(p_objective_name))
281: and
282: (
283: (
307:
308: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
309:
310: --
311: hr_api.mandatory_arg_error
312: (p_api_name => l_proc
313: ,p_argument => 'p_objective_name'
314: ,p_argument_value => p_objective_name
315: );
323: (p_objective_id => p_objective_id
324: ,p_object_version_number => p_object_version_number);
325: --
326: /* IF (l_api_updating
327: AND nvl(per_pml_shd.g_old_rec.objective_name, hr_api.g_varchar2)
328: = nvl(p_objective_name, hr_api.g_varchar2))
329: THEN
330: RETURN;
331: END IF;*/
324: ,p_object_version_number => p_object_version_number);
325: --
326: /* IF (l_api_updating
327: AND nvl(per_pml_shd.g_old_rec.objective_name, hr_api.g_varchar2)
328: = nvl(p_objective_name, hr_api.g_varchar2))
329: THEN
330: RETURN;
331: END IF;*/
332:
410: (p_objective_id => p_objective_id
411: ,p_object_version_number => p_object_version_number);
412: --
413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
411: ,p_object_version_number => p_object_version_number);
412: --
413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
419: RETURN;
412: --
413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
419: RETURN;
420: END IF;
413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
419: RETURN;
420: END IF;
421:
502: (p_objective_id => p_objective_id
503: ,p_object_version_number => p_object_version_number);
504: --
505: IF (l_api_updating
506: AND nvl(per_pml_shd.g_old_rec.group_code, hr_api.g_varchar2)
507: = nvl(p_group_code, hr_api.g_varchar2))
508: THEN
509: RETURN;
510: END IF;
503: ,p_object_version_number => p_object_version_number);
504: --
505: IF (l_api_updating
506: AND nvl(per_pml_shd.g_old_rec.group_code, hr_api.g_varchar2)
507: = nvl(p_group_code, hr_api.g_varchar2))
508: THEN
509: RETURN;
510: END IF;
511:
514: --
515: -- Checks that the group code is valid
516: --
517: if p_group_code is not null then
518: if hr_api.not_exists_in_hrstanlookups
519: (p_effective_date => p_effective_date
520: ,p_lookup_type => 'HR_WPM_GROUP'
521: ,p_lookup_code => p_group_code
522: ) then
590: (p_objective_id => p_objective_id
591: ,p_object_version_number => p_object_version_number);
592: --
593: IF (l_api_updating
594: AND nvl(per_pml_shd.g_old_rec.priority_code, hr_api.g_varchar2)
595: = nvl(p_priority_code, hr_api.g_varchar2))
596: THEN
597: RETURN;
598: END IF;
591: ,p_object_version_number => p_object_version_number);
592: --
593: IF (l_api_updating
594: AND nvl(per_pml_shd.g_old_rec.priority_code, hr_api.g_varchar2)
595: = nvl(p_priority_code, hr_api.g_varchar2))
596: THEN
597: RETURN;
598: END IF;
599:
602: --
603: -- Checks that the priority code is valid
604: --
605: if p_priority_code is not null then
606: if hr_api.not_exists_in_hrstanlookups
607: (p_effective_date => p_effective_date
608: ,p_lookup_type => 'HR_WPM_PRIORITY'
609: ,p_lookup_code => p_priority_code
610: ) then
669:
670: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
671:
672: --
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc
675: ,p_argument => 'p_appraise_flag'
676: ,p_argument_value => p_appraise_flag
677: );
685: (p_objective_id => p_objective_id
686: ,p_object_version_number => p_object_version_number);
687: --
688: IF (l_api_updating
689: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
690: = nvl(p_appraise_flag, hr_api.g_varchar2))
691: THEN
692: RETURN;
693: END IF;
686: ,p_object_version_number => p_object_version_number);
687: --
688: IF (l_api_updating
689: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
690: = nvl(p_appraise_flag, hr_api.g_varchar2))
691: THEN
692: RETURN;
693: END IF;
694:
696:
697: --
698: -- Checks that the appraise flag is valid
699: --
700: if hr_api.not_exists_in_hrstanlookups
701: (p_effective_date => p_effective_date
702: ,p_lookup_type => 'YES_NO'
703: ,p_lookup_code => p_appraise_flag
704: ) then
776: (p_objective_id => p_objective_id
777: ,p_object_version_number => p_object_version_number);
778: --
779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
777: ,p_object_version_number => p_object_version_number);
778: --
779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
785: RETURN;
778: --
779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
785: RETURN;
786: END IF;
779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
785: RETURN;
786: END IF;
787:
872:
873: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
874:
875: --
876: hr_api.mandatory_arg_error
877: (p_api_name => l_proc
878: ,p_argument => 'p_measurement_style_code'
879: ,p_argument_value => p_measurement_style_code
880: );
888: (p_objective_id => p_objective_id
889: ,p_object_version_number => p_object_version_number);
890: --
891: IF (l_api_updating
892: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
893: = nvl(p_measurement_style_code, hr_api.g_varchar2))
894: THEN
895: RETURN;
896: END IF;
889: ,p_object_version_number => p_object_version_number);
890: --
891: IF (l_api_updating
892: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
893: = nvl(p_measurement_style_code, hr_api.g_varchar2))
894: THEN
895: RETURN;
896: END IF;
897:
899:
900: --
901: -- Checks that the measurement_style_code is valid
902: --
903: if hr_api.not_exists_in_hrstanlookups
904: (p_effective_date => p_effective_date
905: ,p_lookup_type => 'HR_WPM_MEASURE'
906: ,p_lookup_code => p_measurement_style_code
907: ) then
976: (p_objective_id => p_objective_id
977: ,p_object_version_number => p_object_version_number);
978: --
979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
977: ,p_object_version_number => p_object_version_number);
978: --
979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
985: RETURN;
978: --
979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
985: RETURN;
986: END IF;
979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
985: RETURN;
986: END IF;
987:
995: if p_measurement_style_code <> 'N_M'
996: then
997: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
998:
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc
1001: ,p_argument => 'p_measure_name'
1002: ,p_argument_value => p_measure_name
1003: );
1071: (p_objective_id => p_objective_id
1072: ,p_object_version_number => p_object_version_number);
1073: --
1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1072: ,p_object_version_number => p_object_version_number);
1073: --
1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1080: RETURN;
1073: --
1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1080: RETURN;
1081: END IF;
1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1080: RETURN;
1081: END IF;
1082:
1090: if p_measurement_style_code = 'QUANT_M'
1091: then
1092: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1093:
1094: hr_api.mandatory_arg_error
1095: (p_api_name => l_proc
1096: ,p_argument => 'p_target_value'
1097: ,p_argument_value => p_target_value
1098: );
1165: (p_objective_id => p_objective_id
1166: ,p_object_version_number => p_object_version_number);
1167: --
1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1166: ,p_object_version_number => p_object_version_number);
1167: --
1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1174: RETURN;
1167: --
1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1174: RETURN;
1175: END IF;
1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1174: RETURN;
1175: END IF;
1176:
1184: if p_measurement_style_code = 'QUANT_M'
1185: then
1186: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1187:
1188: hr_api.mandatory_arg_error
1189: (p_api_name => l_proc
1190: ,p_argument => 'p_uom_code'
1191: ,p_argument_value => p_uom_code
1192: );
1199: --
1200: -- Checks that the UOM code is valid
1201: --
1202: if p_uom_code is not null then
1203: if hr_api.not_exists_in_hrstanlookups
1204: (p_effective_date => p_effective_date
1205: ,p_lookup_type => 'HR_WPM_MEASURE_UOM'
1206: ,p_lookup_code => p_uom_code
1207: ) then
1276: (p_objective_id => p_objective_id
1277: ,p_object_version_number => p_object_version_number);
1278: --
1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1277: ,p_object_version_number => p_object_version_number);
1278: --
1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1285: RETURN;
1278: --
1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1285: RETURN;
1286: END IF;
1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1285: RETURN;
1286: END IF;
1287:
1295: if p_measurement_style_code = 'QUANT_M'
1296: then
1297: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1298:
1299: hr_api.mandatory_arg_error
1300: (p_api_name => l_proc
1301: ,p_argument => 'p_measure_type_code'
1302: ,p_argument_value => p_measure_type_code
1303: );
1310: --
1311: -- Checks that the measure type code is valid
1312: --
1313: if p_measure_type_code is not null then
1314: if hr_api.not_exists_in_hrstanlookups
1315: (p_effective_date => p_effective_date
1316: ,p_lookup_type => 'HR_WPM_MEASURE_TYPE'
1317: ,p_lookup_code => p_measure_type_code
1318: ) then
1377:
1378: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1379:
1380: --
1381: hr_api.mandatory_arg_error
1382: (p_api_name => l_proc
1383: ,p_argument => 'p_eligibility_type_code'
1384: ,p_argument_value => p_eligibility_type_code
1385: );
1393: (p_objective_id => p_objective_id
1394: ,p_object_version_number => p_object_version_number);
1395: --
1396: IF (l_api_updating
1397: AND nvl(per_pml_shd.g_old_rec.eligibility_type_code, hr_api.g_varchar2)
1398: = nvl(p_eligibility_type_code, hr_api.g_varchar2))
1399: THEN
1400: RETURN;
1401: END IF;
1394: ,p_object_version_number => p_object_version_number);
1395: --
1396: IF (l_api_updating
1397: AND nvl(per_pml_shd.g_old_rec.eligibility_type_code, hr_api.g_varchar2)
1398: = nvl(p_eligibility_type_code, hr_api.g_varchar2))
1399: THEN
1400: RETURN;
1401: END IF;
1402:
1404:
1405: --
1406: -- Checks that the eligibility type code is valid
1407: --
1408: if hr_api.not_exists_in_hrstanlookups
1409: (p_effective_date => p_effective_date
1410: ,p_lookup_type => 'HR_WPM_ELIGIBILITY'
1411: ,p_lookup_code => p_eligibility_type_code
1412: ) then