APPS.WF_EVENT_HTML dependencies on WF_EVENT_GROUPS

Line 105: from wf_event_groups

101: -- Need to also check if the Event is part of an Event Group
102: if (x_type = 'EVENT') then
103: -- if it is part of a event group, it is not deletable
104: select count(1) into member_count
105: from wf_event_groups
106: where member_guid = x_guid;
107: end if;
108:
109: if (member_count > 0) then

Line 1558: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG

1554: -- deletable event cursor
1555: -- all events belong to the group
1556: cursor devcurs is
1557: select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
1558: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
1559: where EG.GROUP_GUID = h_guid
1560: and E.GUID = EG.MEMBER_GUID;
1561:
1562:

Line 1640: from WF_EVENT_GROUPS

1636:
1637: -- check if we can change a group type to an event type
1638: -- allow this only when a group does not has any child event.
1639: select count(1) into eventcount
1640: from WF_EVENT_GROUPS
1641: where GROUP_GUID = h_guid;
1642:
1643: if (eventcount > 0) then
1644: edittype := FALSE;

Line 2086: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG

2082: -- deletable event cursor
2083: -- all events belong to the group
2084: cursor devcurs is
2085: select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
2086: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
2087: where EG.GROUP_GUID = h_guid
2088: and E.GUID = EG.MEMBER_GUID;
2089:
2090:

Line 4693: from WF_EVENT_GROUPS

4689: l_type varchar2(8);
4690:
4691: cursor evtc(xguid in raw) is
4692: select MEMBER_GUID
4693: from WF_EVENT_GROUPS
4694: where GROUP_GUID = xguid;
4695:
4696: begin
4697: if (isDeletable(h_guid, 'EVENT')) then

Line 4707: Wf_Event_Groups_Pkg.Delete_Row(

4703: exception
4704: -- if it is a group, delete all the child events
4705: when NO_DATA_FOUND then
4706: for evtr in evtc(h_guid) loop
4707: Wf_Event_Groups_Pkg.Delete_Row(
4708: x_group_guid=>h_guid,
4709: x_member_guid=>evtr.MEMBER_GUID
4710: );
4711: end loop;

Line 5852: Wf_Event_Groups_Pkg.Insert_Row(

5848:
5849: -- add
5850: begin
5851: for i in 2..h_guids.LAST loop
5852: Wf_Event_Groups_Pkg.Insert_Row(
5853: x_rowid=>row_id,
5854: x_group_guid=>h_gguid,
5855: x_member_guid=>hextoraw(h_guids(i))
5856: );

Line 5888: Wf_Event_Groups_Pkg.Delete_Row(

5884: begin
5885: -- delete
5886: begin
5887: for i in 2..h_guids.LAST loop
5888: Wf_Event_Groups_Pkg.Delete_Row(
5889: x_group_guid=>h_gguid,
5890: x_member_guid=>hextoraw(h_guids(i))
5891: );
5892: end loop;