APPS.AME_APPROVER_GROUP_API dependencies on AME_APPROVAL_GROUP_ITEMS

Line 24: from ame_approval_group_items

20: --
21:
22: cursor c_parent_grps(p_grp_id number) is
23: select distinct approval_group_id
24: from ame_approval_group_items
25: where parameter_name = 'OAM_group_id'
26: and sysdate >= start_date and sysdate < end_date
27: start with parameter = to_char(p_grp_id)
28: connect by prior to_char(approval_group_id) = parameter

Line 45: from ame_approval_group_items

41: ,parameter_name param_name
42: ,parameter param
43: ,order_number ord_no
44: from (select *
45: from ame_approval_group_items
46: where sysdate between start_date
47: and nvl(end_date - (1/86400), sysdate)
48: )
49: start with approval_group_id = p_grp_id

Line 91: from ame_approval_group_items

87: end loop;
88:
89: if p_delete_group = true then
90: delete
91: from ame_approval_group_items
92: where parameter = to_char(p_approval_group_id)
93: and parameter_name = 'OAM_group_id'
94: and sysdate >= start_date and sysdate < end_date;
95: end if;

Line 412: from ame_approval_group_items

408: --cursor to find the group's members.
409: cursor CSel3 is
410: select approval_group_item_id
411: ,object_version_number
412: from ame_approval_group_items
413: where approval_group_id = p_approval_group_id
414: and sysdate >= start_date and sysdate < end_date;
415:
416: --

Line 474: -- delete all static members of the group from ame_approval_group_items

470: );
471:
472: --
473: -- When is_static is changed from 'Y' to 'N',
474: -- delete all static members of the group from ame_approval_group_items
475: --
476: if l_old_is_static ='Y' and p_is_static = 'N' and instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_APPROVER_GROUP_SWI') = 0 then
477: for rec in CSel3
478: loop

Line 598: from ame_approval_group_items

594: --cursor to find all members for this approval group.
595: cursor CSel3 is
596: select approval_group_item_id
597: ,object_version_number
598: from ame_approval_group_items
599: where approval_group_id = p_approval_group_id
600: and sysdate >= start_date and sysdate < end_date;
601: --cursor to find the number of rules using the group(01-03-2005)
602: cursor CSel4 is

Line 696: --delete items from ame_approval_group_items if this group is static.

692: ,p_end_date => l_end_date
693: );
694: end loop;
695: --
696: --delete items from ame_approval_group_items if this group is static.
697: --
698: for rec in CSel3
699: loop
700: l_object_version_number_conf :=rec.object_version_number;

Line 1341: from ame_approval_group_items

1337: l_approval_group_id number;
1338:
1339: cursor Csel1 is
1340: select approval_group_id
1341: from ame_approval_group_items
1342: where approval_group_item_id = p_approval_group_item_id
1343: and sysdate >= start_date and sysdate < end_date;
1344: --
1345: begin

Line 1485: from ame_approval_group_items

1481: l_end_date date;
1482:
1483: cursor Csel1 is
1484: select approval_group_id
1485: from ame_approval_group_items
1486: where approval_group_item_id = p_approval_group_item_id
1487: and sysdate between start_date and end_date;
1488: --
1489: begin