APPS.AME_APG_BUS dependencies on AME_APPROVAL_GROUPS

Line 52: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'

48: hr_utility.set_location(' Leaving:'||l_proc,30);
49: exception
50: when app_exception.application_exception then
51: if hr_multi_message.exception_add
52: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'
53: ) then
54: hr_utility.set_location(' Leaving:'||l_proc, 40);
55: raise;
56: end if;

Line 66: from ame_approval_groups

62: l_proc varchar2(72) := g_package || 'CHK_DELETE';
63: l_count number;
64: cursor c_sel1 is
65: select null
66: from ame_approval_groups
67: where ame_utility_pkg.check_seeddb = 'N'
68: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
69: and approval_group_id = p_approval_group_id
70: and p_effective_date between start_date and

Line 79: (p_associated_column1 => 'AME_APPROVAL_GROUPS.DELETE'

75: hr_utility.set_location(' Leaving:'||l_proc,30);
76: exception
77: when app_exception.application_exception then
78: if hr_multi_message.exception_add
79: (p_associated_column1 => 'AME_APPROVAL_GROUPS.DELETE'
80: ) then
81: hr_utility.set_location(' Leaving:'||l_proc, 40);
82: raise;
83: end if;

Line 123: from ame_approval_groups t

119: -- Cursor to find number of groups with name=p_name
120: --
121: Cursor C_Sel1 Is
122: select count(name)
123: from ame_approval_groups t
124: where t.name = p_name
125: and p_effective_date between t.start_date and t.end_date;
126:
127: Begin

Line 141: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'

137: hr_utility.set_location(' Leaving:'||l_proc,30);
138: exception
139: when app_exception.application_exception then
140: if hr_multi_message.exception_add
141: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'
142: ) then
143: hr_utility.set_location(' Leaving:'||l_proc, 40);
144: raise;
145: end if;

Line 194: (p_associated_column1 => 'AME_APPROVAL_GROUPS.IS_STATIC'

190: hr_utility.set_location(' Leaving:'||l_proc,30);
191: exception
192: when app_exception.application_exception then
193: if hr_multi_message.exception_add
194: (p_associated_column1 => 'AME_APPROVAL_GROUPS.IS_STATIC'
195: ) then
196: hr_utility.set_location(' Leaving:'||l_proc, 40);
197: raise;
198: end if;

Line 239: querystring ame_approval_groups.query_string%type;

235: tempInt integer;
236: transIdPlaceholderPosition integer;
237: transIdPlaceholderPosition2 integer;
238: upperTransIdPlaceholder varchar2(100);
239: querystring ame_approval_groups.query_string%type;
240: l_valid varchar2(1000);
241: --
242:
243: Begin

Line 278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',

274: fnd_message.raise_error;
275: end if;
276: tempInt := tempInt + 1;
277: end loop;
278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',
279: columnNameIn => 'query_string',
280: argumentIn => p_query_string)) then
281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
282: fnd_message.raise_error;

Line 298: (p_associated_column1 => 'AME_APPROVAL_GROUPS.QUERY_STRING'

294: hr_utility.set_location(' Leaving:'||l_proc,30);
295: exception
296: when app_exception.application_exception then
297: if hr_multi_message.exception_add
298: (p_associated_column1 => 'AME_APPROVAL_GROUPS.QUERY_STRING'
299: ) then
300: hr_utility.set_location(' Leaving:'||l_proc, 40);
301: raise;
302: end if;

Line 340: l_created_by ame_approval_groups.created_by%TYPE;

336: ,p_rec in ame_apg_shd.g_rec_type
337: ) IS
338: --
339: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
340: l_created_by ame_approval_groups.created_by%TYPE;
341: --
342: --
343: -- Cursor to find created_by value for the row
344: --

Line 347: -- from ame_approval_groups t

343: -- Cursor to find created_by value for the row
344: --
345: -- Cursor C_Sel1 Is
346: -- select t.created_by
347: -- from ame_approval_groups t
348: -- where t.approval_group_id = p_rec.approval_group_id
349: -- and p_effective_date between t.start_date and t.end_date;
350: Begin
351: --