[Home] [Help]
4478: l_ntfy_apprvl_recipient_name pa_wf_ntf_performers.user_name%TYPE; --- Commented for 3267790 fnd_user.user_name%TYPE; --used to set NTFY_APPRVL_RECIPIENT_NAME attribute
4479: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4480: l_number_of_assignments NUMBER;
4481: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4482: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4483:
4484: BEGIN
4485:
4486: -- Initialize the Error Stack
4907:
4908: l_prev_asgmt_info_rec l_prev_asgmt_info_csr%ROWTYPE;
4909: l_assignments_rec l_assignments_csr%ROWTYPE;
4910: l_resource_rec l_resource_csr%ROWTYPE;
4911: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4912:
4913: BEGIN
4914:
4915: -- Initialize the Error Stack
5995: FROM pa_wf_ntf_performers
5996: WHERE wf_type_code = 'MASS_APPROVAL_FYI'
5997: AND group_id = p_group_id;
5998: l_notified_id NUMBER;
5999: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6000:
6001: BEGIN
6002:
6003: -- Initialize the Error Stack
6477: l_update_info_doc VARCHAR2(2000);
6478: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6479: l_note_to_approvers VARCHAR2(2000);
6480: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6481: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6482:
6483: BEGIN
6484: log_message('Inside mass_process_approval_result_wf');
6485:
7361:
7362: NO_ASSIGNMENT_ERRORS EXCEPTION;
7363:
7364: l_override_basis_name VARCHAR2(80) := NULL;
7365: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
7366:
7367:
7368: BEGIN
7369: