DBA Data[Home] [Help]

APPS.JTF_UM_USER_ADMIN_PVT dependencies on JTF_UM_WF_APPROVAL

Line 232: JTF_UM_WF_APPROVAL.abort_process (l_itemtype, l_itemkey);

228: OPEN getUTWFInfo;
229: FETCH getUTWFInfo INTO l_itemtype, l_itemkey;
230: -- abort WF only if we can find the itemtype and itemkey.
231: IF (getUTWFInfo%found) THEN
232: JTF_UM_WF_APPROVAL.abort_process (l_itemtype, l_itemkey);
233: END IF;
234: CLOSE getUTWFInfo;
235:
236: -- 2. Set the usertype_reg table status to REJECTED

Line 330: jtf_um_wf_approval.abort_process (enrollRegRow.wf_item_type, to_char(enrollRegRow.subscription_reg_id));

326: ELSIF (l_status_code = 'APPROVED') OR (l_status_code = 'UPGRADE') THEN
327: -- 1. abort Enrollment WF Process
328: -- query all itemtype and itemkey before aborting WF
329: FOR enrollRegRow in getEnrollWFInfo LOOP
330: jtf_um_wf_approval.abort_process (enrollRegRow.wf_item_type, to_char(enrollRegRow.subscription_reg_id));
331: END LOOP;
332:
333: -- 2. Find all the PENDING enrollments and set USER_REJECTED.
334: UPDATE JTF_UM_SUBSCRIPTION_REG

Line 499: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'involing jtf_um_wf_approval.CreateProcess usertype_id ' || p_usertype_id||' p_user_id ' || p_user_id || ' reg id '|| x_user_reg_id || ' approval id ' || x_approval_id);

495: if (x_approval_id is null or x_approval_id = -1) then
496: JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_USERTYPE_CREDENTIALS(p_username, p_user_id, p_usertype_id);
497: else
498: if l_is_debug_parameter_on then
499: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'involing jtf_um_wf_approval.CreateProcess usertype_id ' || p_usertype_id||' p_user_id ' || p_user_id || ' reg id '|| x_user_reg_id || ' approval id ' || x_approval_id);
500: end if;
501: JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_DEFAULT_RESPONSIBILITY(p_user_id,l_respKey,l_application_id);
502: jtf_um_wf_approval.CreateProcess (requestType => 'USERTYPE',
503: requestID => p_usertype_id,

Line 502: jtf_um_wf_approval.CreateProcess (requestType => 'USERTYPE',

498: if l_is_debug_parameter_on then
499: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'involing jtf_um_wf_approval.CreateProcess usertype_id ' || p_usertype_id||' p_user_id ' || p_user_id || ' reg id '|| x_user_reg_id || ' approval id ' || x_approval_id);
500: end if;
501: JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_DEFAULT_RESPONSIBILITY(p_user_id,l_respKey,l_application_id);
502: jtf_um_wf_approval.CreateProcess (requestType => 'USERTYPE',
503: requestID => p_usertype_id,
504: requesterUserID => p_user_id,
505: requestRegID => x_user_reg_id);
506: end if;