DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on WF_ITEMS

Line 44: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE

40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
45: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
46: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
47: ,p_message_name out nocopy varchar2
48: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE

Line 48: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE

44: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
45: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
46: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
47: ,p_message_name out nocopy varchar2
48: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
49: ,p_tdb_information_category in varchar2
50: ,p_tdb_information1 in varchar2
51: ,p_tdb_information2 in varchar2
52: ,p_tdb_information3 in varchar2

Line 168: l_item_key wf_items.item_key%type;

164: l_maximum_internal_attendees NUMBER;
165: l_existing_internal NUMBER;
166: l_maximum_internal_allowed NUMBER;
167:
168: l_item_key wf_items.item_key%type;
169: l_called_from varchar2(80);
170: l_business_group_id_to hr_all_organization_units.organization_id%type;
171: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
172: l_event_currency_code ota_events.currency_code%type;

Line 1197: p_itemtype in wf_items.item_type%type,

1193: -- {End Of Comments}
1194: -- ----------------------------------------------------------------------------
1195: Procedure create_enroll_wf_process
1196: (p_process in wf_process_activities.process_name%type,
1197: p_itemtype in wf_items.item_type%type,
1198: p_person_id in number ,
1199: p_called_from in varchar2 ,
1200: p_itemkey out nocopy wf_items.item_key%type
1201: )

Line 1200: p_itemkey out nocopy wf_items.item_key%type

1196: (p_process in wf_process_activities.process_name%type,
1197: p_itemtype in wf_items.item_type%type,
1198: p_person_id in number ,
1199: p_called_from in varchar2 ,
1200: p_itemkey out nocopy wf_items.item_key%type
1201: )
1202: IS
1203:
1204: l_proc varchar2(72) := g_package||'create_enroll_wf_process';

Line 1206: l_item_type wf_items.item_type%type := upper(p_itemtype);

1202: IS
1203:
1204: l_proc varchar2(72) := g_package||'create_enroll_wf_process';
1205: l_process wf_activities.name%type := upper(p_process);
1206: l_item_type wf_items.item_type%type := upper(p_itemtype);
1207: l_item_key wf_items.item_key%type;
1208:
1209:
1210: l_user_name varchar2(80);

Line 1207: l_item_key wf_items.item_key%type;

1203:
1204: l_proc varchar2(72) := g_package||'create_enroll_wf_process';
1205: l_process wf_activities.name%type := upper(p_process);
1206: l_item_type wf_items.item_type%type := upper(p_itemtype);
1207: l_item_key wf_items.item_key%type;
1208:
1209:
1210: l_user_name varchar2(80);
1211: l_current_username varchar2(80):= fnd_profile.value('USERNAME');

Line 1709: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE

1705: END CHK_DELEGATE_OK_FOR_EVENT;
1706:
1707:
1708: FUNCTION Get_Current_Person_ID
1709: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
1710: ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)
1711: RETURN NUMBER
1712:
1713: IS

Line 1710: ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)

1706:
1707:
1708: FUNCTION Get_Current_Person_ID
1709: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
1710: ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)
1711: RETURN NUMBER
1712:
1713: IS
1714: l_current_person_id NUMBER;

Line 1896: PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

1892: -- -----------------------------------------------------------
1893: -- Cross Charges Notifications (Workflow Notifications)
1894: -- -----------------------------------------------------------
1895: --
1896: PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1897: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1898: actid IN NUMBER,
1899: funcmode IN VARCHAR2,
1900: resultout OUT NOCOPY VARCHAR2 )

Line 1897: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1893: -- Cross Charges Notifications (Workflow Notifications)
1894: -- -----------------------------------------------------------
1895: --
1896: PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1897: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1898: actid IN NUMBER,
1899: funcmode IN VARCHAR2,
1900: resultout OUT NOCOPY VARCHAR2 )
1901: IS

Line 2043: PROCEDURE Approved ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

2039: -- ------------------------------------------------------------------
2040: -- PROCEDURE Approved
2041: -- ------------------------------------------------------------------
2042: --
2043: PROCEDURE Approved ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
2044: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
2045: actid IN NUMBER,
2046: funcmode IN VARCHAR2,
2047: resultout OUT NOCOPY VARCHAR2 ) IS

Line 2044: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

2040: -- PROCEDURE Approved
2041: -- ------------------------------------------------------------------
2042: --
2043: PROCEDURE Approved ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
2044: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
2045: actid IN NUMBER,
2046: funcmode IN VARCHAR2,
2047: resultout OUT NOCOPY VARCHAR2 ) IS
2048: