APPS.PER_PMA_BUS dependencies on PER_PMA_SHD

Line 46: (p_rec in per_pma_shd.g_rec_type

42: -- Internal Row Handler Use Only.
43: --
44: -- ----------------------------------------------------------------------------
45: procedure chk_df
46: (p_rec in per_pma_shd.g_rec_type
47: ) is
48: --
49: l_proc varchar2(72) := g_package || 'chk_df';
50: --

Line 55: nvl(per_pma_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

51: begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.appraisal_period_id is not null) and (
55: nvl(per_pma_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(per_pma_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 57: nvl(per_pma_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

53: --
54: if ((p_rec.appraisal_period_id is not null) and (
55: nvl(per_pma_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(per_pma_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

55: nvl(per_pma_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(per_pma_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

57: nvl(per_pma_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

59: nvl(per_pma_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

61: nvl(per_pma_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

63: nvl(per_pma_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

65: nvl(per_pma_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

67: nvl(per_pma_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

69: nvl(per_pma_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

71: nvl(per_pma_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

73: nvl(per_pma_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

75: nvl(per_pma_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

77: nvl(per_pma_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

79: nvl(per_pma_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

81: nvl(per_pma_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

83: nvl(per_pma_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

85: nvl(per_pma_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

87: nvl(per_pma_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

89: nvl(per_pma_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

91: nvl(per_pma_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

93: nvl(per_pma_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

95: nvl(per_pma_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

97: nvl(per_pma_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

99: nvl(per_pma_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

101: nvl(per_pma_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

103: nvl(per_pma_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

105: nvl(per_pma_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(per_pma_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

107: nvl(per_pma_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(per_pma_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(per_pma_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 113: nvl(per_pma_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

109: nvl(per_pma_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(per_pma_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(per_pma_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.appraisal_period_id is null) then

Line 115: nvl(per_pma_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

111: nvl(per_pma_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(per_pma_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(per_pma_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.appraisal_period_id is null) then
118: --
119: -- Only execute the validation if absolutely necessary:

Line 250: ,p_rec in per_pma_shd.g_rec_type

246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure chk_non_updateable_args
249: (p_effective_date in date
250: ,p_rec in per_pma_shd.g_rec_type
251: ) IS
252: --
253: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
254: l_error EXCEPTION;

Line 262: IF NOT per_pma_shd.api_updating

258: --
259: -- Only proceed with the validation if a row exists for the current
260: -- record in the HR Schema.
261: --
262: IF NOT per_pma_shd.api_updating
263: (p_appraisal_period_id => p_rec.appraisal_period_id
264: ,p_object_version_number => p_rec.object_version_number
265: ) THEN
266: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 274: per_pma_shd.g_old_rec.plan_id then

270: END IF;
271: --
272: hr_utility.set_location(l_proc, 10);
273: if nvl(p_rec.plan_id,hr_api.g_number) <>
274: per_pma_shd.g_old_rec.plan_id then
275: l_argument := 'plan_id';
276: raise l_error;
277: end if;
278: --

Line 281: per_pma_shd.g_old_rec.appraisal_template_id then

277: end if;
278: --
279: hr_utility.set_location(l_proc, 20);
280: if nvl(p_rec.appraisal_template_id,hr_api.g_number) <>
281: per_pma_shd.g_old_rec.appraisal_template_id then
282: l_argument := 'appraisal_template_id';
283: raise l_error;
284: end if;
285: --

Line 293: ,p_base_table => per_pma_shd.g_tab_nam);

289: WHEN l_error THEN
290: hr_api.argument_changed_error
291: (p_api_name => l_proc
292: ,p_argument => l_argument
293: ,p_base_table => per_pma_shd.g_tab_nam);
294: WHEN OTHERS THEN
295: RAISE;
296: End chk_non_updateable_args;
297: --

Line 527: l_api_updating := per_pma_shd.api_updating

523: -- Only proceed with validation if :
524: -- a) The current g_old_rec is current and
525: -- b) The date values have changed
526: --
527: l_api_updating := per_pma_shd.api_updating
528: (p_appraisal_period_id => p_appraisal_period_id
529: ,p_object_version_number => p_object_version_number);
530: --
531: IF (l_api_updating

Line 532: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)

528: (p_appraisal_period_id => p_appraisal_period_id
529: ,p_object_version_number => p_object_version_number);
530: --
531: IF (l_api_updating
532: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)
533: = nvl(p_start_date, hr_api.g_date)
534: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)
535: = nvl(p_end_date, hr_api.g_date))
536: THEN

Line 534: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)

530: --
531: IF (l_api_updating
532: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)
533: = nvl(p_start_date, hr_api.g_date)
534: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)
535: = nvl(p_end_date, hr_api.g_date))
536: THEN
537: RETURN;
538: END IF;

Line 658: l_api_updating := per_pma_shd.api_updating

654: -- Only proceed with validation if :
655: -- a) The current g_old_rec is current and
656: -- b) The date values have changed
657: --
658: l_api_updating := per_pma_shd.api_updating
659: (p_appraisal_period_id => p_appraisal_period_id
660: ,p_object_version_number => p_object_version_number);
661: --
662: IF (l_api_updating

Line 663: AND nvl(per_pma_shd.g_old_rec.plan_id, hr_api.g_number)

659: (p_appraisal_period_id => p_appraisal_period_id
660: ,p_object_version_number => p_object_version_number);
661: --
662: IF (l_api_updating
663: AND nvl(per_pma_shd.g_old_rec.plan_id, hr_api.g_number)
664: = nvl(p_plan_id, hr_api.g_number)
665: AND nvl(per_pma_shd.g_old_rec.appraisal_template_id, hr_api.g_number)
666: = nvl(p_appraisal_template_id, hr_api.g_number)
667: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)

Line 665: AND nvl(per_pma_shd.g_old_rec.appraisal_template_id, hr_api.g_number)

661: --
662: IF (l_api_updating
663: AND nvl(per_pma_shd.g_old_rec.plan_id, hr_api.g_number)
664: = nvl(p_plan_id, hr_api.g_number)
665: AND nvl(per_pma_shd.g_old_rec.appraisal_template_id, hr_api.g_number)
666: = nvl(p_appraisal_template_id, hr_api.g_number)
667: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)
668: = nvl(p_start_date, hr_api.g_date)
669: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)

Line 667: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)

663: AND nvl(per_pma_shd.g_old_rec.plan_id, hr_api.g_number)
664: = nvl(p_plan_id, hr_api.g_number)
665: AND nvl(per_pma_shd.g_old_rec.appraisal_template_id, hr_api.g_number)
666: = nvl(p_appraisal_template_id, hr_api.g_number)
667: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)
668: = nvl(p_start_date, hr_api.g_date)
669: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)
670: = nvl(p_end_date, hr_api.g_date))
671: THEN

Line 669: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)

665: AND nvl(per_pma_shd.g_old_rec.appraisal_template_id, hr_api.g_number)
666: = nvl(p_appraisal_template_id, hr_api.g_number)
667: AND nvl(per_pma_shd.g_old_rec.start_date, hr_api.g_date)
668: = nvl(p_start_date, hr_api.g_date)
669: AND nvl(per_pma_shd.g_old_rec.end_date, hr_api.g_date)
670: = nvl(p_end_date, hr_api.g_date))
671: THEN
672: RETURN;
673: END IF;

Line 759: l_api_updating := per_pma_shd.api_updating

755: -- Only proceed with validation if :
756: -- a) The current g_old_rec is current and
757: -- b) The date values have changed
758: --
759: l_api_updating := per_pma_shd.api_updating
760: (p_appraisal_period_id => p_appraisal_period_id
761: ,p_object_version_number => p_object_version_number);
762: --
763: IF (l_api_updating

Line 764: AND nvl(per_pma_shd.g_old_rec.initiator_code, hr_api.g_varchar2)

760: (p_appraisal_period_id => p_appraisal_period_id
761: ,p_object_version_number => p_object_version_number);
762: --
763: IF (l_api_updating
764: AND nvl(per_pma_shd.g_old_rec.initiator_code, hr_api.g_varchar2)
765: = nvl(p_initiator_code, hr_api.g_varchar2))
766: THEN
767: RETURN;
768: END IF;

Line 878: ,p_rec in per_pma_shd.g_rec_type

874: -- |---------------------------< insert_validate >----------------------------|
875: -- ----------------------------------------------------------------------------
876: Procedure insert_validate
877: (p_effective_date in date
878: ,p_rec in per_pma_shd.g_rec_type
879: ) is
880: --
881: l_proc varchar2(72) := g_package||'insert_validate';
882: --

Line 953: ,p_rec in per_pma_shd.g_rec_type

949: -- |---------------------------< update_validate >----------------------------|
950: -- ----------------------------------------------------------------------------
951: Procedure update_validate
952: (p_effective_date in date
953: ,p_rec in per_pma_shd.g_rec_type
954: ) is
955: --
956: l_proc varchar2(72) := g_package||'update_validate';
957: --

Line 1004: if( nvl(per_pma_shd.g_old_rec.task_start_date, hr_api.g_date)

1000: (p_task_start_date => p_rec.task_start_date
1001: ,p_task_end_date => p_rec.task_end_date);
1002:
1003: --
1004: if( nvl(per_pma_shd.g_old_rec.task_start_date, hr_api.g_date)
1005: <> nvl(p_rec.task_start_date, hr_api.g_date)) then
1006: chk_start_date(p_task_start_date => p_rec.task_start_date);
1007: end if;
1008: --

Line 1021: (p_rec in per_pma_shd.g_rec_type

1017: -- ----------------------------------------------------------------------------
1018: -- |---------------------------< delete_validate >----------------------------|
1019: -- ----------------------------------------------------------------------------
1020: Procedure delete_validate
1021: (p_rec in per_pma_shd.g_rec_type
1022: ) is
1023: --
1024: l_proc varchar2(72) := g_package||'delete_validate';
1025: --