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 410: from ame_approval_group_items

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

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

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

Line 596: from ame_approval_group_items

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

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

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

Line 1339: from ame_approval_group_items

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

Line 1483: from ame_approval_group_items

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