APPS.PER_PML_BUS dependencies on HR_API

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

46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(per_pml_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(per_pml_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(per_pml_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(per_pml_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(per_pml_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(per_pml_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(per_pml_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(per_pml_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(per_pml_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(per_pml_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(per_pml_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(per_pml_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(per_pml_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(per_pml_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(per_pml_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(per_pml_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(per_pml_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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

84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(per_pml_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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

86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(per_pml_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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

88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(per_pml_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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

90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(per_pml_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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

92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(per_pml_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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

94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(per_pml_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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

96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(per_pml_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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

98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(per_pml_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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

100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(per_pml_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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

102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(per_pml_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))

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

104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(per_pml_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(per_pml_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(per_pml_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.objective_id is null) then
112: --

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

Line 279: where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)

275:
276: cursor chk_objective_name(c_p_valid_from date, c_p_valid_to date) is
277: select 'Y', nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')),nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
278: from per_objectives_library pml
279: where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)
280: and upper(trim(pml.objective_name)) = upper(trim(p_objective_name))
281: and
282: (
283: (

Line 311: hr_api.mandatory_arg_error

307:
308: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
309:
310: --
311: hr_api.mandatory_arg_error
312: (p_api_name => l_proc
313: ,p_argument => 'p_objective_name'
314: ,p_argument_value => p_objective_name
315: );

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

324: ,p_object_version_number => p_object_version_number);
325: --
326: /* IF (l_api_updating
327: AND nvl(per_pml_shd.g_old_rec.objective_name, hr_api.g_varchar2)
328: = nvl(p_objective_name, hr_api.g_varchar2))
329: THEN
330: RETURN;
331: END IF;*/
332:

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

411: ,p_object_version_number => p_object_version_number);
412: --
413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
419: RETURN;

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

413: IF (l_api_updating
414: AND nvl(per_pml_shd.g_old_rec.valid_from, hr_api.g_date)
415: = nvl(p_valid_from, hr_api.g_date)
416: AND nvl(per_pml_shd.g_old_rec.valid_to, hr_api.g_date)
417: = nvl(p_valid_to, hr_api.g_date))
418: THEN
419: RETURN;
420: END IF;
421:

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

503: ,p_object_version_number => p_object_version_number);
504: --
505: IF (l_api_updating
506: AND nvl(per_pml_shd.g_old_rec.group_code, hr_api.g_varchar2)
507: = nvl(p_group_code, hr_api.g_varchar2))
508: THEN
509: RETURN;
510: END IF;
511:

Line 518: if hr_api.not_exists_in_hr_lookups

514: --
515: -- Checks that the group code is valid
516: --
517: if p_group_code is not null then
518: if hr_api.not_exists_in_hr_lookups
519: (p_effective_date => p_effective_date
520: ,p_lookup_type => 'HR_WPM_GROUP'
521: ,p_lookup_code => p_group_code
522: ) then

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

591: ,p_object_version_number => p_object_version_number);
592: --
593: IF (l_api_updating
594: AND nvl(per_pml_shd.g_old_rec.priority_code, hr_api.g_varchar2)
595: = nvl(p_priority_code, hr_api.g_varchar2))
596: THEN
597: RETURN;
598: END IF;
599:

Line 606: if hr_api.not_exists_in_hr_lookups

602: --
603: -- Checks that the priority code is valid
604: --
605: if p_priority_code is not null then
606: if hr_api.not_exists_in_hr_lookups
607: (p_effective_date => p_effective_date
608: ,p_lookup_type => 'HR_WPM_PRIORITY'
609: ,p_lookup_code => p_priority_code
610: ) then

Line 673: hr_api.mandatory_arg_error

669:
670: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
671:
672: --
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc
675: ,p_argument => 'p_appraise_flag'
676: ,p_argument_value => p_appraise_flag
677: );

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

686: ,p_object_version_number => p_object_version_number);
687: --
688: IF (l_api_updating
689: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
690: = nvl(p_appraise_flag, hr_api.g_varchar2))
691: THEN
692: RETURN;
693: END IF;
694:

Line 700: if hr_api.not_exists_in_hrstanlookups

696:
697: --
698: -- Checks that the appraise flag is valid
699: --
700: if hr_api.not_exists_in_hrstanlookups
701: (p_effective_date => p_effective_date
702: ,p_lookup_type => 'YES_NO'
703: ,p_lookup_code => p_appraise_flag
704: ) then

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

777: ,p_object_version_number => p_object_version_number);
778: --
779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
785: RETURN;

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

779: IF (l_api_updating
780: AND nvl(per_pml_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
781: = nvl(p_appraise_flag, hr_api.g_varchar2)
782: AND nvl(per_pml_shd.g_old_rec.weighting_percent, hr_api.g_number)
783: = nvl(p_weighting_percent, hr_api.g_number))
784: THEN
785: RETURN;
786: END IF;
787:

Line 876: hr_api.mandatory_arg_error

872:
873: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
874:
875: --
876: hr_api.mandatory_arg_error
877: (p_api_name => l_proc
878: ,p_argument => 'p_measurement_style_code'
879: ,p_argument_value => p_measurement_style_code
880: );

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

889: ,p_object_version_number => p_object_version_number);
890: --
891: IF (l_api_updating
892: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
893: = nvl(p_measurement_style_code, hr_api.g_varchar2))
894: THEN
895: RETURN;
896: END IF;
897:

Line 903: if hr_api.not_exists_in_hrstanlookups

899:
900: --
901: -- Checks that the measurement_style_code is valid
902: --
903: if hr_api.not_exists_in_hrstanlookups
904: (p_effective_date => p_effective_date
905: ,p_lookup_type => 'HR_WPM_MEASURE'
906: ,p_lookup_code => p_measurement_style_code
907: ) then

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

977: ,p_object_version_number => p_object_version_number);
978: --
979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
985: RETURN;

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

979: IF (l_api_updating
980: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
981: = nvl(p_measurement_style_code, hr_api.g_varchar2)
982: AND nvl(per_pml_shd.g_old_rec.measure_name, hr_api.g_varchar2)
983: = nvl(p_measure_name, hr_api.g_varchar2))
984: THEN
985: RETURN;
986: END IF;
987:

Line 999: hr_api.mandatory_arg_error

995: if p_measurement_style_code <> 'N_M'
996: then
997: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
998:
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc
1001: ,p_argument => 'p_measure_name'
1002: ,p_argument_value => p_measure_name
1003: );

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

1072: ,p_object_version_number => p_object_version_number);
1073: --
1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1080: RETURN;

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

1074: IF (l_api_updating
1075: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1076: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1077: AND nvl(per_pml_shd.g_old_rec.target_value, hr_api.g_number)
1078: = nvl(p_target_value, hr_api.g_number))
1079: THEN
1080: RETURN;
1081: END IF;
1082:

Line 1094: hr_api.mandatory_arg_error

1090: if p_measurement_style_code = 'QUANT_M'
1091: then
1092: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1093:
1094: hr_api.mandatory_arg_error
1095: (p_api_name => l_proc
1096: ,p_argument => 'p_target_value'
1097: ,p_argument_value => p_target_value
1098: );

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

1166: ,p_object_version_number => p_object_version_number);
1167: --
1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1174: RETURN;

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

1168: IF (l_api_updating
1169: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1170: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1171: AND nvl(per_pml_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1172: = nvl(p_uom_code, hr_api.g_varchar2))
1173: THEN
1174: RETURN;
1175: END IF;
1176:

Line 1188: hr_api.mandatory_arg_error

1184: if p_measurement_style_code = 'QUANT_M'
1185: then
1186: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1187:
1188: hr_api.mandatory_arg_error
1189: (p_api_name => l_proc
1190: ,p_argument => 'p_uom_code'
1191: ,p_argument_value => p_uom_code
1192: );

Line 1203: if hr_api.not_exists_in_hrstanlookups

1199: --
1200: -- Checks that the UOM code is valid
1201: --
1202: if p_uom_code is not null then
1203: if hr_api.not_exists_in_hrstanlookups
1204: (p_effective_date => p_effective_date
1205: ,p_lookup_type => 'HR_WPM_MEASURE_UOM'
1206: ,p_lookup_code => p_uom_code
1207: ) then

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

1277: ,p_object_version_number => p_object_version_number);
1278: --
1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1285: RETURN;

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

1279: IF (l_api_updating
1280: AND nvl(per_pml_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1281: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1282: AND nvl(per_pml_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1283: = nvl(p_measure_type_code, hr_api.g_varchar2))
1284: THEN
1285: RETURN;
1286: END IF;
1287:

Line 1299: hr_api.mandatory_arg_error

1295: if p_measurement_style_code = 'QUANT_M'
1296: then
1297: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1298:
1299: hr_api.mandatory_arg_error
1300: (p_api_name => l_proc
1301: ,p_argument => 'p_measure_type_code'
1302: ,p_argument_value => p_measure_type_code
1303: );

Line 1314: if hr_api.not_exists_in_hrstanlookups

1310: --
1311: -- Checks that the measure type code is valid
1312: --
1313: if p_measure_type_code is not null then
1314: if hr_api.not_exists_in_hrstanlookups
1315: (p_effective_date => p_effective_date
1316: ,p_lookup_type => 'HR_WPM_MEASURE_TYPE'
1317: ,p_lookup_code => p_measure_type_code
1318: ) then

Line 1381: hr_api.mandatory_arg_error

1377:
1378: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1379:
1380: --
1381: hr_api.mandatory_arg_error
1382: (p_api_name => l_proc
1383: ,p_argument => 'p_eligibility_type_code'
1384: ,p_argument_value => p_eligibility_type_code
1385: );

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

1394: ,p_object_version_number => p_object_version_number);
1395: --
1396: IF (l_api_updating
1397: AND nvl(per_pml_shd.g_old_rec.eligibility_type_code, hr_api.g_varchar2)
1398: = nvl(p_eligibility_type_code, hr_api.g_varchar2))
1399: THEN
1400: RETURN;
1401: END IF;
1402:

Line 1408: if hr_api.not_exists_in_hrstanlookups

1404:
1405: --
1406: -- Checks that the eligibility type code is valid
1407: --
1408: if hr_api.not_exists_in_hrstanlookups
1409: (p_effective_date => p_effective_date
1410: ,p_lookup_type => 'HR_WPM_ELIGIBILITY'
1411: ,p_lookup_code => p_eligibility_type_code
1412: ) then