eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PML_BUS dependencies on PER_PML_SHD

Line 40: (p_rec in per_pml_shd.g_rec_type

36: -- Internal Row Handler Use Only.
37: --
38: -- ----------------------------------------------------------------------------
39: procedure chk_df
40: (p_rec in per_pml_shd.g_rec_type
41: ) is
42: --
43: l_proc varchar2(72) := g_package || 'chk_df';
44: --

Line 49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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) <>

Line 89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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) <>

Line 91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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) <>

Line 93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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) <>

Line 95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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) <>

Line 97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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) <>

Line 99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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) <>

Line 101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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) <>

Line 103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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) <>

Line 105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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) <>

Line 107: nvl(per_pml_shd.g_old_rec.attribute29, 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

Line 109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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:

Line 217: ,p_rec in per_pml_shd.g_rec_type

213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure chk_non_updateable_args
216: (p_effective_date in date
217: ,p_rec in per_pml_shd.g_rec_type
218: ) IS
219: --
220: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
221: --

Line 227: IF NOT per_pml_shd.api_updating

223: --
224: -- Only proceed with the validation if a row exists for the current
225: -- record in the HR Schema.
226: --
227: IF NOT per_pml_shd.api_updating
228: (p_objective_id => p_rec.objective_id
229: ,p_object_version_number => p_rec.object_version_number
230: ) THEN
231: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 322: l_api_updating := per_pml_shd.api_updating

318: -- Only proceed with validation if :
319: -- a) The current g_old_rec is current and
320: -- b) The date values have changed
321: --
322: l_api_updating := per_pml_shd.api_updating
323: (p_objective_id => p_objective_id
324: ,p_object_version_number => p_object_version_number);
325: --
326: /* IF (l_api_updating

Line 327: AND nvl(per_pml_shd.g_old_rec.objective_name, hr_api.g_varchar2)

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;*/

Line 409: l_api_updating := per_pml_shd.api_updating

405: -- Only proceed with validation if :
406: -- a) The current g_old_rec is current and
407: -- b) The date values have changed
408: --
409: l_api_updating := per_pml_shd.api_updating
410: (p_objective_id => p_objective_id
411: ,p_object_version_number => p_object_version_number);
412: --
413: IF (l_api_updating

Line 414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)

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

Line 416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)

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;

Line 501: l_api_updating := per_pml_shd.api_updating

497: -- Only proceed with validation if :
498: -- a) The current g_old_rec is current and
499: -- b) The date values have changed
500: --
501: l_api_updating := per_pml_shd.api_updating
502: (p_objective_id => p_objective_id
503: ,p_object_version_number => p_object_version_number);
504: --
505: IF (l_api_updating

Line 506: AND nvl(per_pml_shd.g_old_rec.group_code, hr_api.g_varchar2)

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;

Line 589: l_api_updating := per_pml_shd.api_updating

585: -- Only proceed with validation if :
586: -- a) The current g_old_rec is current and
587: -- b) The date values have changed
588: --
589: l_api_updating := per_pml_shd.api_updating
590: (p_objective_id => p_objective_id
591: ,p_object_version_number => p_object_version_number);
592: --
593: IF (l_api_updating

Line 594: AND nvl(per_pml_shd.g_old_rec.priority_code, hr_api.g_varchar2)

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;

Line 684: l_api_updating := per_pml_shd.api_updating

680: -- Only proceed with validation if :
681: -- a) The current g_old_rec is current and
682: -- b) The date values have changed
683: --
684: l_api_updating := per_pml_shd.api_updating
685: (p_objective_id => p_objective_id
686: ,p_object_version_number => p_object_version_number);
687: --
688: IF (l_api_updating

Line 689: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

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;

Line 775: l_api_updating := per_pml_shd.api_updating

771: -- Only proceed with validation if :
772: -- a) The current g_old_rec is current and
773: -- b) The date values have changed
774: --
775: l_api_updating := per_pml_shd.api_updating
776: (p_objective_id => p_objective_id
777: ,p_object_version_number => p_object_version_number);
778: --
779: IF (l_api_updating

Line 780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

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

Line 782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_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;
786: END IF;

Line 887: l_api_updating := per_pml_shd.api_updating

883: -- Only proceed with validation if :
884: -- a) The current g_old_rec is current and
885: -- b) The date values have changed
886: --
887: l_api_updating := per_pml_shd.api_updating
888: (p_objective_id => p_objective_id
889: ,p_object_version_number => p_object_version_number);
890: --
891: IF (l_api_updating

Line 892: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

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;

Line 975: l_api_updating := per_pml_shd.api_updating

971: -- Only proceed with validation if :
972: -- a) The current g_old_rec is current and
973: -- b) The date values have changed
974: --
975: l_api_updating := per_pml_shd.api_updating
976: (p_objective_id => p_objective_id
977: ,p_object_version_number => p_object_version_number);
978: --
979: IF (l_api_updating

Line 980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

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

Line 982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)

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;

Line 1070: l_api_updating := per_pml_shd.api_updating

1066: -- Only proceed with validation if :
1067: -- a) The current g_old_rec is current and
1068: -- b) The date values have changed
1069: --
1070: l_api_updating := per_pml_shd.api_updating
1071: (p_objective_id => p_objective_id
1072: ,p_object_version_number => p_object_version_number);
1073: --
1074: IF (l_api_updating

Line 1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

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

Line 1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_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;
1081: END IF;

Line 1164: l_api_updating := per_pml_shd.api_updating

1160: -- Only proceed with validation if :
1161: -- a) The current g_old_rec is current and
1162: -- b) The date values have changed
1163: --
1164: l_api_updating := per_pml_shd.api_updating
1165: (p_objective_id => p_objective_id
1166: ,p_object_version_number => p_object_version_number);
1167: --
1168: IF (l_api_updating

Line 1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

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

Line 1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)

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;

Line 1275: l_api_updating := per_pml_shd.api_updating

1271: -- Only proceed with validation if :
1272: -- a) The current g_old_rec is current and
1273: -- b) The date values have changed
1274: --
1275: l_api_updating := per_pml_shd.api_updating
1276: (p_objective_id => p_objective_id
1277: ,p_object_version_number => p_object_version_number);
1278: --
1279: IF (l_api_updating

Line 1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

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

Line 1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)

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;

Line 1392: l_api_updating := per_pml_shd.api_updating

1388: -- Only proceed with validation if :
1389: -- a) The current g_old_rec is current and
1390: -- b) The date values have changed
1391: --
1392: l_api_updating := per_pml_shd.api_updating
1393: (p_objective_id => p_objective_id
1394: ,p_object_version_number => p_object_version_number);
1395: --
1396: IF (l_api_updating

Line 1397: AND nvl(per_pml_shd.g_old_rec.eligibility_type_code, hr_api.g_varchar2)

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;

Line 1552: ,p_rec in per_pml_shd.g_rec_type

1548: -- ----------------------------------------------------------------------------
1549: --
1550: Procedure insert_validate
1551: (p_effective_date in date
1552: ,p_rec in per_pml_shd.g_rec_type
1553: ,p_duplicate_name_warning out nocopy boolean
1554: ,p_weighting_over_100_warning out nocopy boolean
1555: ,p_weighting_appraisal_warning out nocopy boolean
1556: ) is

Line 1738: ,p_rec in per_pml_shd.g_rec_type

1734: -- ----------------------------------------------------------------------------
1735: --
1736: Procedure update_validate
1737: (p_effective_date in date
1738: ,p_rec in per_pml_shd.g_rec_type
1739: ,p_duplicate_name_warning out nocopy boolean
1740: ,p_weighting_over_100_warning out nocopy boolean
1741: ,p_weighting_appraisal_warning out nocopy boolean
1742: ) is

Line 1925: (p_rec in per_pml_shd.g_rec_type

1921: -- |---------------------------< delete_validate >----------------------------|
1922: -- ----------------------------------------------------------------------------
1923: --
1924: Procedure delete_validate
1925: (p_rec in per_pml_shd.g_rec_type
1926: ) is
1927: --
1928: l_proc varchar2(72) := g_package||'delete_validate';
1929: --