[Home] [Help]
316: p_init_msg_list => fnd_api.g_false,
317: --p_commit => p_commit,
318: --p_validate_only => p_validate_only,
319: p_person_id => l_person_id,
320: p_individual => 'Y',
321: p_resource_type => 'EMPLOYEE',
322: p_check_resource => 'Y',
323: x_return_status => l_return_status,
324: x_msg_count => x_msg_count,
378: -- the profile
379: IF p_status_code is null THEN
380: SELECT fnd_profile.value('PA_DEF_START_CAND_STATUS')
381: INTO l_status_code
382: FROM dual;
383: ELSE
384: l_status_code := p_status_code;
385: END IF;
386:
2131:
2132: -- Create the unique item key to launch WF with
2133: SELECT pa_prm_wf_item_key_s.nextval
2134: INTO l_itemkey
2135: FROM dual;
2136:
2137: -- Now start fetching the details
2138: OPEN l_assignments_csr;
2139: FETCH l_assignments_csr INTO l_assignments_rec;
3248:
3249: /*-------------------------------------------------------------------------
3250: PROCEDURE: Get_NF_Recipient
3251: PURPOSE: Called from PA Candidate Notification Process workflow (PARCANDD.wft).
3252: This procedure is called in loop to send individual notifications to
3253: all people involved while candidate nomination process.
3254: ( Resource + Res Mgr + Primary Cont + Staffing Owner )
3255: -------------------------------------------------------------------------*/
3256: PROCEDURE Get_NF_Recipient (itemtype IN VARCHAR2
3272: then do NF_LOOP_COUNTER := NF_LOOP_COUNTER + 1;
3273: If NF_LOOP_COUNTER > NUMBER_OF_RECIPIENTS , resultout = 'F'
3274: and return
3275: Else
3276: Get individual PER role, set role attributes for notification,
3277: Resultout = 'S'
3278: end
3279: */
3280: