[Home] [Help]
295: p_init_msg_list => fnd_api.g_false,
296: --p_commit => p_commit,
297: --p_validate_only => p_validate_only,
298: p_person_id => l_person_id,
299: p_individual => 'Y',
300: p_resource_type => 'EMPLOYEE',
301: p_check_resource => 'Y',
302: x_return_status => l_return_status,
303: x_msg_count => x_msg_count,
357: -- the profile
358: IF p_status_code is null THEN
359: SELECT fnd_profile.value('PA_DEF_START_CAND_STATUS')
360: INTO l_status_code
361: FROM dual;
362: ELSE
363: l_status_code := p_status_code;
364: END IF;
365:
1877:
1878: -- Create the unique item key to launch WF with
1879: SELECT pa_prm_wf_item_key_s.nextval
1880: INTO l_itemkey
1881: FROM dual;
1882:
1883: -- Now start fetching the details
1884: OPEN l_assignments_csr;
1885: FETCH l_assignments_csr INTO l_assignments_rec;
2985:
2986: /*-------------------------------------------------------------------------
2987: PROCEDURE: Get_NF_Recipient
2988: PURPOSE: Called from PA Candidate Notification Process workflow (PARCANDD.wft).
2989: This procedure is called in loop to send individual notifications to
2990: all people involved while candidate nomination process.
2991: ( Resource + Res Mgr + Primary Cont + Staffing Owner )
2992: -------------------------------------------------------------------------*/
2993: PROCEDURE Get_NF_Recipient (itemtype IN VARCHAR2
3009: then do NF_LOOP_COUNTER := NF_LOOP_COUNTER + 1;
3010: If NF_LOOP_COUNTER > NUMBER_OF_RECIPIENTS , resultout = 'F'
3011: and return
3012: Else
3013: Get individual PER role, set role attributes for notification,
3014: Resultout = 'S'
3015: end
3016: */
3017: