APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on WF_ACTIVITIES

Line 2049: p_process in wf_activities.name%type)

2045: p_object_type in VARCHAR2,
2046: p_object_id in NUMBER,
2047: p_error_learners in NUMBER,
2048: p_success_learners in NUMBER,
2049: p_process in wf_activities.name%type)
2050: IS
2051: l_proc varchar2(72) := g_package||'notify_mandatory_request';
2052: -- l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2053: l_item_type wf_items.item_type%type := 'OTWF';

Line 2052: -- l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';

2048: p_success_learners in NUMBER,
2049: p_process in wf_activities.name%type)
2050: IS
2051: l_proc varchar2(72) := g_package||'notify_mandatory_request';
2052: -- l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2053: l_item_type wf_items.item_type%type := 'OTWF';
2054: l_item_key wf_items.item_key%type;
2055:
2056: l_user_name varchar2(80);

Line 2154: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';

2150: AND(reqm.create_enrollment = 'Y' and reqm.error_message IS NULL);
2151:
2152: l_error_learners NUMBER := 0;
2153: l_success_learners NUMBER := 0;
2154: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2155: l_proc varchar2(72) := g_package||'notify_class_owners';
2156:
2157: BEGIN
2158: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2200: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';

2196: AND(reqm.create_enrollment = 'Y' and reqm.error_message IS NULL);
2197:
2198: l_error_learners NUMBER := 0;
2199: l_success_learners NUMBER := 0;
2200: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2201: l_proc varchar2(72) := g_package||'notify_multi_class_owners';
2202:
2203: BEGIN
2204: hr_utility.set_location('Entering:'||l_proc, 5);