eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_GEN_003 dependencies on IGS_TR_TYPE_STEP

Line 262: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;

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;
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;

Line 317: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,

313: trs.s_tracking_step_type
314: FROM IGS_TR_STEP trs
315: WHERE trs.tracking_id = cp_tracking_id;
316: CURSOR c_tts (
317: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
318: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
319: SELECT tts.recipient_id
320: FROM IGS_TR_TYPE_STEP tts
321: WHERE tracking_type = cp_tracking_type AND

Line 318: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS

314: FROM IGS_TR_STEP trs
315: WHERE trs.tracking_id = cp_tracking_id;
316: CURSOR c_tts (
317: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
318: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
319: SELECT tts.recipient_id
320: FROM IGS_TR_TYPE_STEP tts
321: WHERE tracking_type = cp_tracking_type AND
322: tracking_type_step_id = cp_tracking_type_step_id;

Line 320: FROM IGS_TR_TYPE_STEP tts

316: CURSOR c_tts (
317: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
318: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
319: SELECT tts.recipient_id
320: FROM IGS_TR_TYPE_STEP tts
321: WHERE tracking_type = cp_tracking_type AND
322: tracking_type_step_id = cp_tracking_type_step_id;
323: CURSOR c_tpm (
324: cp_person_id IGS_RE_THS_PNL_MBR.ca_person_id%TYPE,

Line 887: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;

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;
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;

Line 938: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,

934: trs.s_tracking_step_type
935: FROM IGS_TR_STEP trs
936: WHERE trs.tracking_id = cp_tracking_id;
937: CURSOR c_tts (
938: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
939: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
940: SELECT tts.recipient_id
941: FROM IGS_TR_TYPE_STEP tts
942: WHERE tracking_type = cp_tracking_type AND

Line 939: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS

935: FROM IGS_TR_STEP trs
936: WHERE trs.tracking_id = cp_tracking_id;
937: CURSOR c_tts (
938: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
939: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
940: SELECT tts.recipient_id
941: FROM IGS_TR_TYPE_STEP tts
942: WHERE tracking_type = cp_tracking_type AND
943: tracking_type_step_id = cp_tracking_type_step_id;

Line 941: FROM IGS_TR_TYPE_STEP tts

937: CURSOR c_tts (
938: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
939: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS
940: SELECT tts.recipient_id
941: FROM IGS_TR_TYPE_STEP tts
942: WHERE tracking_type = cp_tracking_type AND
943: tracking_type_step_id = cp_tracking_type_step_id;
944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_id%TYPE) IS