APPS.PAY_TDF_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'time_definition_id'
50: ,p_argument_value => p_time_definition_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'time_definition_id'
119: ,p_argument_value => p_time_definition_id
120: );

Line 122: if ( nvl(pay_tdf_bus.g_time_definition_id, hr_api.g_number)

118: ,p_argument => 'time_definition_id'
119: ,p_argument_value => p_time_definition_id
120: );
121: --
122: if ( nvl(pay_tdf_bus.g_time_definition_id, hr_api.g_number)
123: = p_time_definition_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 212: if nvl(p_rec.business_group_id, hr_api.g_number) <>

208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
214: hr_api.argument_changed_error
215: (p_api_name => l_proc
216: ,p_argument => 'BUSINESS_GROUP_ID'

Line 213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then

209: fnd_message.raise_error;
210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
214: hr_api.argument_changed_error
215: (p_api_name => l_proc
216: ,p_argument => 'BUSINESS_GROUP_ID'
217: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 214: hr_api.argument_changed_error

210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
214: hr_api.argument_changed_error
215: (p_api_name => l_proc
216: ,p_argument => 'BUSINESS_GROUP_ID'
217: ,p_base_table => pay_tdf_shd.g_tab_nam
218: );

Line 221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

217: ,p_base_table => pay_tdf_shd.g_tab_nam
218: );
219: end if;
220: --
221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
223: hr_api.argument_changed_error
224: (p_api_name => l_proc
225: ,p_argument => 'LEGISLATION_CODE'

Line 222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

218: );
219: end if;
220: --
221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
223: hr_api.argument_changed_error
224: (p_api_name => l_proc
225: ,p_argument => 'LEGISLATION_CODE'
226: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 223: hr_api.argument_changed_error

219: end if;
220: --
221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
223: hr_api.argument_changed_error
224: (p_api_name => l_proc
225: ,p_argument => 'LEGISLATION_CODE'
226: ,p_base_table => pay_tdf_shd.g_tab_nam
227: );

Line 230: if nvl(p_rec.short_name, hr_api.g_varchar2) <>

226: ,p_base_table => pay_tdf_shd.g_tab_nam
227: );
228: end if;
229: --
230: if nvl(p_rec.short_name, hr_api.g_varchar2) <>
231: pay_tdf_shd.g_old_rec.short_name then
232: hr_api.argument_changed_error
233: (p_api_name => l_proc
234: ,p_argument => 'SHORT_NAME'

Line 232: hr_api.argument_changed_error

228: end if;
229: --
230: if nvl(p_rec.short_name, hr_api.g_varchar2) <>
231: pay_tdf_shd.g_old_rec.short_name then
232: hr_api.argument_changed_error
233: (p_api_name => l_proc
234: ,p_argument => 'SHORT_NAME'
235: ,p_base_table => pay_tdf_shd.g_tab_nam
236: );

Line 239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>

235: ,p_base_table => pay_tdf_shd.g_tab_nam
236: );
237: end if;
238: --
239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>
240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then
241: hr_api.argument_changed_error
242: (p_api_name => l_proc
243: ,p_argument => 'DEFINITION_TYPE'

Line 240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then

236: );
237: end if;
238: --
239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>
240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then
241: hr_api.argument_changed_error
242: (p_api_name => l_proc
243: ,p_argument => 'DEFINITION_TYPE'
244: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 241: hr_api.argument_changed_error

237: end if;
238: --
239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>
240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then
241: hr_api.argument_changed_error
242: (p_api_name => l_proc
243: ,p_argument => 'DEFINITION_TYPE'
244: ,p_base_table => pay_tdf_shd.g_tab_nam
245: );

Line 248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>

244: ,p_base_table => pay_tdf_shd.g_tab_nam
245: );
246: end if;
247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>

Line 249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR

245: );
246: end if;
247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR

Line 250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>

246: end if;
247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>

Line 251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR

247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR

Line 252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>

248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>

Line 253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR

249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR

Line 254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>

250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>

Line 255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR

251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then

Line 256: nvl(p_rec.start_date, hr_api.g_date) <>

252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:

Line 257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR

253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:
261: if p_time_def_used then

Line 258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>

254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:
261: if p_time_def_used then
262:

Line 259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then

255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:
261: if p_time_def_used then
262:
263: p_regenerate_periods := false;

Line 276: elsif nvl(p_rec.number_of_years, hr_api.g_number) <>

272: p_delete_periods := true;
273:
274: end if;
275:
276: elsif nvl(p_rec.number_of_years, hr_api.g_number) <>
277: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) then
278:
279: p_regenerate_periods := true;
280: p_delete_periods := false;

Line 277: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) then

273:
274: end if;
275:
276: elsif nvl(p_rec.number_of_years, hr_api.g_number) <>
277: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) then
278:
279: p_regenerate_periods := true;
280: p_delete_periods := false;
281:

Line 547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>

543: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'
545: ) and (
546: not l_api_updating or
547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>
548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )
549: ) then
550:
551: if p_definition_type in ('P','E','C')

Line 548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )

544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'
545: ) and (
546: not l_api_updating or
547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>
548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )
549: ) then
550:
551: if p_definition_type in ('P','E','C')
552: and p_number_of_years is not null then

Line 792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>

788: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'
790: ) and (
791: not l_api_updating or
792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>
793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )
794: ) then
795:
796: if p_definition_type in ('E','C')

Line 793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )

789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'
790: ) and (
791: not l_api_updating or
792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>
793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )
794: ) then
795:
796: if p_definition_type in ('E','C')
797: and p_period_type is not null then

Line 899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>

895: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'
897: ) and (
898: not l_api_updating or
899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>
900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )
901: ) then
902:
903: if p_definition_type in ('S','E','C')

Line 900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )

896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'
897: ) and (
898: not l_api_updating or
899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>
900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )
901: ) then
902:
903: if p_definition_type in ('S','E','C')
904: and p_period_unit is not null then

Line 979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>

975: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'
977: ) and (
978: not l_api_updating or
979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>
980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )
981: ) then
982:
983: if p_definition_type in ('S','E','C')

Line 980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )

976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'
977: ) and (
978: not l_api_updating or
979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>
980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )
981: ) then
982:
983: if p_definition_type in ('S','E','C')
984: and p_day_adjustment is not null then

Line 1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>

1054: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'
1056: ) and (
1057: not l_api_updating or
1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>
1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )
1060: ) then
1061:
1062: if p_definition_type in ('P','E','C')

Line 1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )

1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'
1056: ) and (
1057: not l_api_updating or
1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>
1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )
1060: ) then
1061:
1062: if p_definition_type in ('P','E','C')
1063: and p_start_date is not null then

Line 1159: OR (ptd.business_group_id is null and ptd.legislation_code = hr_api.return_legislation_code(p_business_group_id))

1155: (
1156: p_business_group_id is not null and
1157: p_legislation_code is null and
1158: ( ( ptd.business_group_id is null and ptd.legislation_code is null)
1159: OR (ptd.business_group_id is null and ptd.legislation_code = hr_api.return_legislation_code(p_business_group_id))
1160: OR (ptd.business_group_id = p_business_group_id and ptd.legislation_code is null) )
1161: )
1162: );
1163:

Line 1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>

1173: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'
1175: ) and (
1176: not l_api_updating or
1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>
1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )
1179: ) then
1180:
1181: if p_definition_type in ('P','E','C')

Line 1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )

1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'
1175: ) and (
1176: not l_api_updating or
1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>
1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )
1179: ) then
1180:
1181: if p_definition_type in ('P','E','C')
1182: and p_period_time_definition_id is not null then

Line 1288: OR (ptd.business_group_id is null and ptd.legislation_code = hr_api.return_legislation_code(p_business_group_id))

1284: (
1285: p_business_group_id is not null and
1286: p_legislation_code is null and
1287: ( ( ptd.business_group_id is null and ptd.legislation_code is null)
1288: OR (ptd.business_group_id is null and ptd.legislation_code = hr_api.return_legislation_code(p_business_group_id))
1289: OR (ptd.business_group_id = p_business_group_id and ptd.legislation_code is null) )
1290: )
1291: );
1292:

Line 1302: ( l_api_updating and nvl(p_definition_name, hr_api.g_varchar2) <>

1298: (p_time_definition_id => p_time_definition_id
1299: ,p_object_version_number => p_object_version_number);
1300:
1301: if not l_api_updating or
1302: ( l_api_updating and nvl(p_definition_name, hr_api.g_varchar2) <>
1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )
1304: ) then
1305:
1306: hr_api.mandatory_arg_error

Line 1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )

1299: ,p_object_version_number => p_object_version_number);
1300:
1301: if not l_api_updating or
1302: ( l_api_updating and nvl(p_definition_name, hr_api.g_varchar2) <>
1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )
1304: ) then
1305:
1306: hr_api.mandatory_arg_error
1307: (p_api_name => l_proc

Line 1306: hr_api.mandatory_arg_error

1302: ( l_api_updating and nvl(p_definition_name, hr_api.g_varchar2) <>
1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )
1304: ) then
1305:
1306: hr_api.mandatory_arg_error
1307: (p_api_name => l_proc
1308: ,p_argument => 'DEFINITION_NAME'
1309: ,p_argument_value => p_definition_name
1310: );

Line 1393: hr_api.mandatory_arg_error

1389: --
1390: Begin
1391: hr_utility.set_location('Entering:'||l_proc, 5);
1392: --
1393: hr_api.mandatory_arg_error
1394: (p_api_name => l_proc
1395: ,p_argument => 'SHORT_NAME'
1396: ,p_argument_value => p_short_name
1397: );

Line 1480: hr_api.mandatory_arg_error

1476: --
1477: Begin
1478: hr_utility.set_location('Entering:'||l_proc, 5);
1479: --
1480: hr_api.mandatory_arg_error
1481: (p_api_name => l_proc
1482: ,p_argument => 'DEFINITION_TYPE'
1483: ,p_argument_value => p_definition_type
1484: );

Line 1613: hr_api.validate_bus_grp_id

1609: NOT IN ('GENERIC','STARTUP') THEN
1610: --
1611: -- Validate Important Attributes
1612: --
1613: hr_api.validate_bus_grp_id
1614: (p_business_group_id => p_rec.business_group_id
1615: ,p_associated_column1 => pay_tdf_shd.g_tab_nam
1616: || '.BUSINESS_GROUP_ID');
1617: --

Line 1746: hr_api.validate_bus_grp_id

1742: NOT IN ('GENERIC','STARTUP') THEN
1743: --
1744: -- Validate Important Attributes
1745: --
1746: hr_api.validate_bus_grp_id
1747: (p_business_group_id => p_rec.business_group_id
1748: ,p_associated_column1 => pay_tdf_shd.g_tab_nam
1749: || '.BUSINESS_GROUP_ID');
1750: --