[Home] [Help]
254: cst_stst_originator CONSTANT
255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';
256: cst_stst_chair CONSTANT
257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';
258: cst_active CONSTANT IGS_TR_STATUS.s_tracking_status%TYPE := 'ACTIVE';
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;
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;
291: FROM IGS_RE_THS_PNL_TYPE tpt
292: WHERE tpt.thesis_panel_type = cp_thesis_panel_type;
293: CURSOR c_ts IS
294: SELECT ts.tracking_status
295: FROM IGS_TR_STATUS ts
296: WHERE ts.s_tracking_status = cst_active AND
297: ts.closed_ind = 'N'
298: ORDER BY ts.tracking_status ASC;
299: CURSOR c_tri (
887: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
888: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
889: v_target_days NUMBER;
890: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
912: FROM IGS_RE_THS_PNL_MR_TP tmpt
913: WHERE tmpt.panel_member_type = cp_panel_member_type;
914: CURSOR c_ts IS
915: SELECT ts.tracking_status
916: FROM IGS_TR_STATUS ts
917: WHERE ts.s_tracking_status = 'ACTIVE' AND
918: ts.closed_ind = 'N'
919: ORDER BY ts.tracking_status ASC;
920: CURSOR c_tri (