[Home] [Help]
4463: 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
4464: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4465: l_number_of_assignments NUMBER;
4466: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4467: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4468:
4469: BEGIN
4470:
4471: -- Initialize the Error Stack
4891:
4892: l_prev_asgmt_info_rec l_prev_asgmt_info_csr%ROWTYPE;
4893: l_assignments_rec l_assignments_csr%ROWTYPE;
4894: l_resource_rec l_resource_csr%ROWTYPE;
4895: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4896:
4897: BEGIN
4898:
4899: -- Initialize the Error Stack
5979: FROM pa_wf_ntf_performers
5980: WHERE wf_type_code = 'MASS_APPROVAL_FYI'
5981: AND group_id = p_group_id;
5982: l_notified_id NUMBER;
5983: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
5984:
5985: BEGIN
5986:
5987: -- Initialize the Error Stack
6461: l_update_info_doc VARCHAR2(2000);
6462: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6463: l_note_to_approvers VARCHAR2(2000);
6464: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6465: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6466:
6467: BEGIN
6468: log_message('Inside mass_process_approval_result_wf');
6469:
7345:
7346: NO_ASSIGNMENT_ERRORS EXCEPTION;
7347:
7348: l_override_basis_name VARCHAR2(80) := NULL;
7349: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
7350:
7351:
7352: BEGIN
7353: