[Home] [Help]
259: v_message_name VARCHAR2(30);
260: v_originator_id IGS_RE_THS_PNL_MBR.person_id%TYPE;
261: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;
262: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
263: v_principal_id IGS_PE_PERSON.person_id%TYPE;
264: v_chair_id IGS_PE_PERSON.person_id%TYPE;
265: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
266: v_target_days NUMBER;
267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
260: v_originator_id IGS_RE_THS_PNL_MBR.person_id%TYPE;
261: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;
262: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
263: v_principal_id IGS_PE_PERSON.person_id%TYPE;
264: v_chair_id IGS_PE_PERSON.person_id%TYPE;
265: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
266: v_target_days NUMBER;
267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
273: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
274:
275: CURSOR c_pe IS
276: SELECT PERSON_PARTY_ID
277: FROM fnd_user
880: cst_s_tracking_type CONSTANT VARCHAR2(10) := 'RES_TPM';
881: cst_stst_person CONSTANT VARCHAR2(10) := 'RES_TPM_PE';
882: cst_stst_originator CONSTANT VARCHAR2(10) := 'RES_TPM_OR';
883: v_message_name VARCHAR2(30);
884: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
885: v_originator_id IGS_RE_THS_PNL_MBR.person_id%TYPE;
886: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;
887: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
888: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
956:
957: BEGIN
958: p_message_name := NULL;
959: SAVEPOINT s_before_update;
960: -- Get the originator IGS_PE_PERSON ID, being the principal supervisor with the
961: -- greatest supervising load. If multiple principal supervisors exist, then
962: -- use the first.
963:
964: OPEN c_pe;