APPS.PER_PMA_BUS dependencies on HR_API

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 56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 58: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 60: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 62: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 64: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 66: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 68: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 70: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 72: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 74: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 76: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 78: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 80: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 82: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 84: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 86: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 88: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 90: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 92: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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 94: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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 96: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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 98: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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 100: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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 102: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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 104: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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 106: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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 108: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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 110: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 112: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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) <>
116: nvl(p_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 114: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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
118: --

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 116: nvl(p_rec.attribute30, 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:
120: -- a) During update, the structure column value or any

Line 206: hr_api.mandatory_arg_error

202: --
203:
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc
208: ,p_argument => 'p_task_start_date'
209: ,p_argument_value => p_task_start_date
210: );

Line 273: if nvl(p_rec.plan_id,hr_api.g_number) <>

269: fnd_message.raise_error;
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;

Line 280: if nvl(p_rec.appraisal_template_id,hr_api.g_number) <>

276: raise l_error;
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;

Line 290: hr_api.argument_changed_error

286: hr_utility.set_location(l_proc, 30);
287: --
288: EXCEPTION
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

Line 339: hr_api.mandatory_arg_error

335: BEGIN
336:
337: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
338:
339: hr_api.mandatory_arg_error
340: (p_api_name => l_proc
341: ,p_argument => 'p_plan_id'
342: ,p_argument_value => p_plan_id
343: );

Line 414: hr_api.mandatory_arg_error

410: BEGIN
411:
412: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
413:
414: hr_api.mandatory_arg_error
415: (p_api_name => l_proc
416: ,p_argument => 'p_appraisal_template_id'
417: ,p_argument_value => p_appraisal_template_id
418: );

Line 510: hr_api.mandatory_arg_error

506:
507: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
508:
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc
512: ,p_argument => 'p_start_date'
513: ,p_argument_value => p_start_date
514: );

Line 516: hr_api.mandatory_arg_error

512: ,p_argument => 'p_start_date'
513: ,p_argument_value => p_start_date
514: );
515: --
516: hr_api.mandatory_arg_error
517: (p_api_name => l_proc
518: ,p_argument => 'p_end_date'
519: ,p_argument_value => p_end_date
520: );

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 533: = nvl(p_start_date, hr_api.g_date)

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
537: RETURN;

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 535: = nvl(p_end_date, hr_api.g_date))

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;
539:

Line 578: IF p_start_date < nvl(l_apt_date_from, hr_api.g_sot)

574: FETCH csr_dates_within_template INTO l_apt_date_from
575: ,l_apt_date_to;
576: CLOSE csr_dates_within_template;
577:
578: IF p_start_date < nvl(l_apt_date_from, hr_api.g_sot)
579: OR p_end_date > nvl(l_apt_date_to, hr_api.g_eot)
580: THEN
581: fnd_message.set_name('PER', 'HR_50393_PMA_TEMPLATE_DATES');
582: fnd_message.raise_error;

Line 579: OR p_end_date > nvl(l_apt_date_to, hr_api.g_eot)

575: ,l_apt_date_to;
576: CLOSE csr_dates_within_template;
577:
578: IF p_start_date < nvl(l_apt_date_from, hr_api.g_sot)
579: OR p_end_date > nvl(l_apt_date_to, hr_api.g_eot)
580: THEN
581: fnd_message.set_name('PER', 'HR_50393_PMA_TEMPLATE_DATES');
582: fnd_message.raise_error;
583: END IF;

Line 647: AND pma.appraisal_period_id <> nvl(p_appraisal_period_id, hr_api.g_number);

643: WHERE pma.plan_id = p_plan_id
644: AND pma.appraisal_template_id = p_appraisal_template_id
645: AND pma.start_date = p_start_date
646: AND pma.end_date = p_end_date
647: AND pma.appraisal_period_id <> nvl(p_appraisal_period_id, hr_api.g_number);
648: --
649: BEGIN
650:
651: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;

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 664: = nvl(p_plan_id, hr_api.g_number)

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)
668: = nvl(p_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 666: = nvl(p_appraisal_template_id, hr_api.g_number)

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)
670: = nvl(p_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 668: = nvl(p_start_date, hr_api.g_date)

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
672: RETURN;

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 670: = nvl(p_end_date, hr_api.g_date))

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;
674:

Line 749: hr_api.mandatory_arg_error

745:
746: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
747:
748: --
749: hr_api.mandatory_arg_error
750: (p_api_name => l_proc
751: ,p_argument => 'p_initiator_code'
752: ,p_argument_value => p_initiator_code
753: );

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 765: = nvl(p_initiator_code, hr_api.g_varchar2))

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;
769:

Line 775: IF hr_api.not_exists_in_hrstanlookups

771:
772: --
773: -- Checks that the status code is valid
774: --
775: IF hr_api.not_exists_in_hrstanlookups
776: (p_effective_date => p_effective_date
777: ,p_lookup_type => 'HR_WPM_INITIATOR'
778: ,p_lookup_code => p_initiator_code
779: ) THEN

Line 836: hr_api.mandatory_arg_error

832:
833: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
834:
835: --
836: hr_api.mandatory_arg_error
837: (p_api_name => l_proc
838: ,p_argument => 'p_task_start_date'
839: ,p_argument_value => p_task_start_date
840: );

Line 842: hr_api.mandatory_arg_error

838: ,p_argument => 'p_task_start_date'
839: ,p_argument_value => p_task_start_date
840: );
841: --
842: hr_api.mandatory_arg_error
843: (p_api_name => l_proc
844: ,p_argument => 'p_task_end_date'
845: ,p_argument_value => p_task_end_date
846: );

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 1005: <> nvl(p_rec.task_start_date, hr_api.g_date)) then

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: --
1009: