APPS.AME_GPI_BUS dependencies on AME_APPROVAL_GROUP_ITEMS

Line 37: from ame_approval_group_items

33: select grp from
34: (
35: select distinct parameter grp
36: from (select *
37: from ame_approval_group_items
38: where sysdate >= start_date
39: and sysdate < (end_date - ame_util.oneSecond)
40: )
41: where parameter_name = 'OAM_group_id'

Line 50: from ame_approval_group_items

46: union
47:
48: select to_char(approval_group_id) grp
49: from (select *
50: from ame_approval_group_items
51: where sysdate >= start_date
52: and sysdate < (end_date - ame_util.oneSecond)
53: )
54: where parameter_name = 'OAM_group_id'

Line 88: from ame_approval_group_items

84: cursor groupMemberCursor(approvalGroupIdIn in number) is
85: select
86: parameter,
87: parameter_name
88: from ame_approval_group_items
89: where
90: approval_group_id = approvalGroupIdIn and
91: sysdate between start_date and (end_date - ame_util.oneSecond);
92: l_proc varchar2(72) := g_package||'group_is_in_group';

Line 270: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

266: hr_utility.set_location(' Leaving:'||l_proc,30);
267: exception
268: when app_exception.application_exception then
269: if hr_multi_message.exception_add
270: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
271: ) then
272: hr_utility.set_location(' Leaving:'||l_proc, 40);
273: raise;
274: end if;

Line 353: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

349: hr_utility.set_location(' Leaving:'||l_proc,30);
350: exception
351: when app_exception.application_exception then
352: if hr_multi_message.exception_add
353: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
354: ) then
355: hr_utility.set_location(' Leaving:'||l_proc, 40);
356: raise;
357: end if;

Line 408: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'

404: hr_utility.set_location(' Leaving:'||l_proc,30);
405: exception
406: when app_exception.application_exception then
407: if hr_multi_message.exception_add
408: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'
409: ) then
410: hr_utility.set_location(' Leaving:'||l_proc, 40);
411: raise;
412: end if;

Line 536: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

532: hr_utility.set_location(' Leaving:'||l_proc,30);
533: exception
534: when app_exception.application_exception then
535: if hr_multi_message.exception_add
536: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
537: ) then
538: hr_utility.set_location(' Leaving:'||l_proc, 40);
539: raise;
540: end if;

Line 589: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'

585: hr_utility.set_location(' Leaving:'||l_proc,30);
586: exception
587: when app_exception.application_exception then
588: if hr_multi_message.exception_add
589: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'
590: ) then
591: hr_utility.set_location(' Leaving:'||l_proc, 40);
592: raise;
593: end if;

Line 637: from ame_approval_group_items t

633: -- Cursor to find if the item is already existing in the group
634: --
635: Cursor C_Sel1 Is
636: select count(t.approval_group_item_id)
637: from ame_approval_group_items t
638: where t.approval_group_id = p_approval_group_id
639: and t.parameter_name = p_parameter_name
640: and t.parameter = p_parameter
641: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);

Line 668: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

664: hr_utility.set_location(' Leaving:'||l_proc,30);
665: exception
666: when app_exception.application_exception then
667: if hr_multi_message.exception_add
668: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
669: ) then
670: hr_utility.set_location(' Leaving:'||l_proc, 40);
671: raise;
672: end if;

Line 710: l_created_by ame_approval_group_items.created_by%TYPE;

706: ,p_rec in ame_gpi_shd.g_rec_type
707: ) IS
708: --
709: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
710: l_created_by ame_approval_group_items.created_by%TYPE;
711: --
712: -- Cursor to find created_by value for the row
713: --
714: Cursor C_Sel1 Is

Line 716: from ame_approval_group_items t

712: -- Cursor to find created_by value for the row
713: --
714: Cursor C_Sel1 Is
715: select t.created_by
716: from ame_approval_group_items t
717: where t.approval_group_item_id = p_rec.approval_group_item_id
718: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
719: Begin
720: --