DBA Data[Home] [Help]

APPS.AME_GCF_BUS dependencies on AME_APPROVAL_GROUP_CONFIG

Line 107: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'

103: hr_utility.set_location(' Leaving:'||l_proc,30);
104: exception
105: when app_exception.application_exception then
106: if hr_multi_message.exception_add
107: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'
108: ) then
109: hr_utility.set_location(' Leaving:'||l_proc, 40);
110: raise;
111: end if;

Line 184: from ame_approval_group_config

180: actu.start_date < nvl(actu.end_date,actu.start_date + ame_util.oneSecond)));
181:
182: cursor c_sel2 is
183: select null
184: from ame_approval_group_config
185: where ame_utility_pkg.check_seeddb = 'N'
186: and approval_group_id = p_approval_group_id
187: and application_id = p_application_id
188: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById

Line 208: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'

204: hr_utility.set_location(' Leaving:'||l_proc,30);
205: exception
206: when app_exception.application_exception then
207: if hr_multi_message.exception_add
208: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'
209: ) then
210: hr_utility.set_location(' Leaving:'||l_proc, 40);
211: raise;
212: end if;

Line 276: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'

272: hr_utility.set_location(' Leaving:'||l_proc,30);
273: exception
274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'
277: ) then
278: hr_utility.set_location(' Leaving:'||l_proc, 40);
279: raise;
280: end if;

Line 344: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPROVAL_GROUP_ID'

340: hr_utility.set_location(' Leaving:'||l_proc,30);
341: exception
342: when app_exception.application_exception then
343: if hr_multi_message.exception_add
344: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPROVAL_GROUP_ID'
345: ) then
346: hr_utility.set_location(' Leaving:'||l_proc, 40);
347: raise;
348: end if;

Line 399: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.VOTING_REGIME'

395: hr_utility.set_location(' Leaving:'||l_proc,30);
396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add
399: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.VOTING_REGIME'
400: ) then
401: hr_utility.set_location(' Leaving:'||l_proc, 40);
402: raise;
403: end if;

Line 453: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.ORDER_NUMBER'

449: hr_utility.set_location(' Leaving:'||l_proc,30);
450: exception
451: when app_exception.application_exception then
452: if hr_multi_message.exception_add
453: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.ORDER_NUMBER'
454: ) then
455: hr_utility.set_location(' Leaving:'||l_proc, 40);
456: raise;
457: end if;

Line 495: from ame_approval_group_config

491: l_count number;
492: --
493: cursor CSel1 is
494: select count(*)
495: from ame_approval_group_config
496: where approval_group_id = p_approval_group_id
497: and application_id = p_application_id
498: and sysdate between start_date and end_date;
499:

Line 514: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'

510: hr_utility.set_location(' Leaving:'||l_proc,30);
511: exception
512: when app_exception.application_exception then
513: if hr_multi_message.exception_add
514: (p_associated_column1 => 'AME_APPROVAL_GROUP_CONFIG.APPLICATION_ID'
515: ) then
516: hr_utility.set_location(' Leaving:'||l_proc, 40);
517: raise;
518: end if;