DBA Data[Home] [Help]

APPS.OTA_ENROLL_IN_TRAINING_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 167: l_item_key wf_items.item_key%type;

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

Line 1190: p_itemtype in wf_items.item_type%type,

1186: -- {End Of Comments}
1187: -- ----------------------------------------------------------------------------
1188: Procedure create_enroll_wf_process
1189: (p_process in wf_process_activities.process_name%type,
1190: p_itemtype in wf_items.item_type%type,
1191: p_person_id in number ,
1192: p_called_from in varchar2 ,
1193: p_itemkey out nocopy wf_items.item_key%type
1194: )

Line 1193: p_itemkey out nocopy wf_items.item_key%type

1189: (p_process in wf_process_activities.process_name%type,
1190: p_itemtype in wf_items.item_type%type,
1191: p_person_id in number ,
1192: p_called_from in varchar2 ,
1193: p_itemkey out nocopy wf_items.item_key%type
1194: )
1195: IS
1196:
1197: l_proc varchar2(72) := g_package||'create_enroll_wf_process';

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

1195: IS
1196:
1197: l_proc varchar2(72) := g_package||'create_enroll_wf_process';
1198: l_process wf_activities.name%type := upper(p_process);
1199: l_item_type wf_items.item_type%type := upper(p_itemtype);
1200: l_item_key wf_items.item_key%type;
1201:
1202:
1203: l_user_name varchar2(80);

Line 1200: l_item_key wf_items.item_key%type;

1196:
1197: l_proc varchar2(72) := g_package||'create_enroll_wf_process';
1198: l_process wf_activities.name%type := upper(p_process);
1199: l_item_type wf_items.item_type%type := upper(p_itemtype);
1200: l_item_key wf_items.item_key%type;
1201:
1202:
1203: l_user_name varchar2(80);
1204: l_current_username varchar2(80):= fnd_profile.value('USERNAME');

Line 1726: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE

1722: RETURN l_return_value;
1723: END CHK_DELEGATE_OK_FOR_EVENT;
1724:
1725: FUNCTION Get_Current_Person_ID
1726: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
1727: ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)
1728: RETURN NUMBER
1729:
1730: IS

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

1723: END CHK_DELEGATE_OK_FOR_EVENT;
1724:
1725: FUNCTION Get_Current_Person_ID
1726: (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
1727: ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)
1728: RETURN NUMBER
1729:
1730: IS
1731: l_current_person_id NUMBER;

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

1909: -- -----------------------------------------------------------
1910: -- Cross Charges Notifications (Workflow Notifications)
1911: -- -----------------------------------------------------------
1912: --
1913: PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1914: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1915: actid IN NUMBER,
1916: funcmode IN VARCHAR2,
1917: resultout OUT nocopy VARCHAR2 )

Line 1914: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1910: -- Cross Charges Notifications (Workflow Notifications)
1911: -- -----------------------------------------------------------
1912: --
1913: PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1914: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1915: actid IN NUMBER,
1916: funcmode IN VARCHAR2,
1917: resultout OUT nocopy VARCHAR2 )
1918: IS

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

2056: -- ------------------------------------------------------------------
2057: -- PROCEDURE Approved
2058: -- ------------------------------------------------------------------
2059: --
2060: PROCEDURE Approved ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
2061: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
2062: actid IN NUMBER,
2063: funcmode IN VARCHAR2,
2064: resultout OUT nocopy VARCHAR2 ) IS

Line 2061: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

2057: -- PROCEDURE Approved
2058: -- ------------------------------------------------------------------
2059: --
2060: PROCEDURE Approved ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
2061: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
2062: actid IN NUMBER,
2063: funcmode IN VARCHAR2,
2064: resultout OUT nocopy VARCHAR2 ) IS
2065: