APPS.IRC_RSE_BUS dependencies on IRC_RSE_SHD

Line 40: (p_rec in irc_rse_shd.g_rec_type

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

Line 49: nvl(irc_rse_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.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

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

105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then
112: --
113: hr_utility.set_location('Inside the ff stuff',20);

Line 219: ,p_rec in irc_rse_shd.g_rec_type

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

Line 229: IF NOT irc_rse_shd.api_updating

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

Line 277: l_api_updating := irc_rse_shd.api_updating

273: l_api_updating boolean;
274: --
275: begin
276: hr_utility.set_location('Entering:'||l_proc,10);
277: l_api_updating := irc_rse_shd.api_updating
278: (p_recruiting_site_id => p_recruiting_site_id
279: ,p_object_version_number => p_object_version_number
280: );
281: --

Line 285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)

281: --
282: hr_utility.set_location(l_proc,20);
283: if (l_api_updating and
284: p_internal <>
285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)
286: ) or (NOT l_api_updating) then
287: -- Check that internal has a valid value of either 'Y' or 'N'
288: hr_utility.set_location(l_proc,30);
289: if not p_internal in ('Y','N') then

Line 344: l_api_updating := irc_rse_shd.api_updating

340: l_api_updating boolean;
341: --
342: begin
343: hr_utility.set_location('Entering:'||l_proc,10);
344: l_api_updating := irc_rse_shd.api_updating
345: (p_recruiting_site_id => p_recruiting_site_id
346: ,p_object_version_number => p_object_version_number
347: );
348: --

Line 352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)

348: --
349: hr_utility.set_location(l_proc,20);
350: if (l_api_updating and
351: p_external <>
352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)
353: ) or (NOT l_api_updating) then
354: -- Check that external has a valid value of either 'Y' or 'N'
355: hr_utility.set_location(l_proc,30);
356: if not p_external in ('Y','N') then

Line 413: l_api_updating := irc_rse_shd.api_updating

409: l_api_updating boolean;
410: --
411: begin
412: hr_utility.set_location('Entering:'||l_proc,10);
413: l_api_updating := irc_rse_shd.api_updating
414: (p_recruiting_site_id => p_recruiting_site_id
415: ,p_object_version_number => p_object_version_number
416: );
417: --

Line 421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)

417: --
418: hr_utility.set_location(l_proc,20);
419: if (l_api_updating and
420: p_third_party <>
421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)
422: ) or (NOT l_api_updating) then
423: -- Check that third_party has a valid value of either 'Y' or 'N'
424: hr_utility.set_location(l_proc,30);
425: if not p_third_party in ('Y','N') then

Line 506: l_api_updating := irc_rse_shd.api_updating

502: -- a) The current g_old_rec is current
503: -- b) The value has changed.
504: -- c) A record is being inserted
505: --
506: l_api_updating := irc_rse_shd.api_updating
507: (p_recruiting_site_id => p_recruiting_site_id
508: ,p_object_version_number => p_object_version_number
509: );
510: --

Line 511: if ((l_api_updating and nvl(irc_rse_shd.g_old_rec.posting_cost_period,

507: (p_recruiting_site_id => p_recruiting_site_id
508: ,p_object_version_number => p_object_version_number
509: );
510: --
511: if ((l_api_updating and nvl(irc_rse_shd.g_old_rec.posting_cost_period,
512: hr_api.g_varchar2)
513: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
514: or p_posting_cost_period is not null)
515: or

Line 612: l_api_updating := irc_rse_shd.api_updating

608: -- a) The current g_old_rec is current
609: -- b) The value has changed.
610: -- c) A record is being inserted
611: --
612: l_api_updating := irc_rse_shd.api_updating
613: (p_recruiting_site_id => p_recruiting_site_id
614: ,p_object_version_number => p_object_version_number
615: );
616: --

Line 618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,

614: ,p_object_version_number => p_object_version_number
615: );
616: --
617: hr_utility.set_location(l_proc, 3);
618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)

Line 621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,

617: hr_utility.set_location(l_proc, 3);
618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)

Line 624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,

620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)
626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)
627: )
628: )

Line 643: l_posting_cost := irc_rse_shd.g_old_rec.posting_cost;

639: hr_utility.set_location(l_proc, 10);
640: l_posting_cost := p_posting_cost;
641: else
642: hr_utility.set_location(l_proc, 20);
643: l_posting_cost := irc_rse_shd.g_old_rec.posting_cost;
644: end if;
645: --
646: if ((l_api_updating and p_posting_cost_period <> hr_api.g_varchar2)
647: or p_posting_cost_period is null

Line 653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;

649: hr_utility.set_location(l_proc, 30);
650: l_posting_cost_period := p_posting_cost_period;
651: else
652: hr_utility.set_location(l_proc, 40);
653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;
654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);
657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);

Line 665: l_posting_cost_currency := irc_rse_shd.g_old_rec.posting_cost_currency;

661: hr_utility.set_location(l_proc, 50);
662: l_posting_cost_currency := p_posting_cost_currency;
663: else
664: hr_utility.set_location(l_proc, 60);
665: l_posting_cost_currency := irc_rse_shd.g_old_rec.posting_cost_currency;
666: end if;
667: --
668: if ( l_posting_cost_currency
669: || l_posting_cost

Line 746: l_api_updating := irc_rse_shd.api_updating

742: -- b) The date_from has changed.
743: -- c) The date_to has changed.
744: -- d) a record is being inserted.
745: --
746: l_api_updating := irc_rse_shd.api_updating
747: (p_recruiting_site_id => p_recruiting_site_id
748: ,p_object_version_number => p_object_version_number
749: );
750: --

Line 751: if (((l_api_updating and nvl(irc_rse_shd.g_old_rec.date_from,

747: (p_recruiting_site_id => p_recruiting_site_id
748: ,p_object_version_number => p_object_version_number
749: );
750: --
751: if (((l_api_updating and nvl(irc_rse_shd.g_old_rec.date_from,
752: hr_api.g_date)
753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,

Line 755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,

751: if (((l_api_updating and nvl(irc_rse_shd.g_old_rec.date_from,
752: hr_api.g_date)
753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,
756: hr_api.g_date)
757: <> nvl(p_date_to, hr_api.g_date))
758: )
759: or

Line 796: ,p_rec in irc_rse_shd.g_rec_type

792: -- |---------------------------< insert_validate >----------------------------|
793: -- ----------------------------------------------------------------------------
794: Procedure insert_validate
795: (p_effective_date in date
796: ,p_rec in irc_rse_shd.g_rec_type
797: ) is
798: --
799: l_proc varchar2(72) := g_package||'insert_validate';
800: --

Line 863: ,p_rec in irc_rse_shd.g_rec_type

859: -- |---------------------------< update_validate >----------------------------|
860: -- ----------------------------------------------------------------------------
861: Procedure update_validate
862: (p_effective_date in date
863: ,p_rec in irc_rse_shd.g_rec_type
864: ) is
865: --
866: l_proc varchar2(72) := g_package||'update_validate';
867: --

Line 934: (p_rec in irc_rse_shd.g_rec_type

930: -- ----------------------------------------------------------------------------
931: -- |---------------------------< delete_validate >----------------------------|
932: -- ----------------------------------------------------------------------------
933: Procedure delete_validate
934: (p_rec in irc_rse_shd.g_rec_type
935: ) is
936: --
937: l_proc varchar2(72) := g_package||'delete_validate';
938: --