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_VAL_MIL dependencies on IGS_PR_MS_STAT

Line 75: v_s_milestone_status IGS_PR_MS_STAT.s_milestone_status%TYPE;

71: DECLARE
72: cst_planned CONSTANT IGS_PR_MILESTONE.milestone_status%TYPE := 'PLANNED';
73: cst_replanned CONSTANT IGS_PR_MILESTONE.milestone_status%TYPE := 'RE-PLANNED';
74: cst_achieved CONSTANT IGS_PR_MILESTONE.milestone_status%TYPE := 'ACHIEVED';
75: v_s_milestone_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
76: v_milh_mst_exists VARCHAR2(1);
77: CURSOR c_mst IS
78: SELECT mst.s_milestone_status
79: FROM IGS_PR_MS_STAT mst

Line 79: FROM IGS_PR_MS_STAT mst

75: v_s_milestone_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
76: v_milh_mst_exists VARCHAR2(1);
77: CURSOR c_mst IS
78: SELECT mst.s_milestone_status
79: FROM IGS_PR_MS_STAT mst
80: WHERE mst.milestone_status = p_milestone_status;
81: CURSOR c_milh_mst IS
82: SELECT 'x'
83: FROM IGS_PR_MILESTONE_HST milh,

Line 84: IGS_PR_MS_STAT mst

80: WHERE mst.milestone_status = p_milestone_status;
81: CURSOR c_milh_mst IS
82: SELECT 'x'
83: FROM IGS_PR_MILESTONE_HST milh,
84: IGS_PR_MS_STAT mst
85: WHERE milh.person_id = p_person_id AND
86: milh.ca_sequence_number = p_ca_sequence_number AND
87: milh.sequence_number = p_sequence_number AND
88: milh.milestone_status IS NOT NULL AND

Line 152: FROM IGS_PR_MS_STAT mst

148: -- - Must be set when IGS_PR_MILESTONE status is ACHIEVED or FAILED
149: DECLARE
150: CURSOR c_mst IS
151: SELECT mst.s_milestone_status
152: FROM IGS_PR_MS_STAT mst
153: WHERE mst.milestone_status = p_milestone_status;
154: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
155: cst_achieved CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'ACHIEVED';
156: cst_failed CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'FAILED';

Line 154: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;

150: CURSOR c_mst IS
151: SELECT mst.s_milestone_status
152: FROM IGS_PR_MS_STAT mst
153: WHERE mst.milestone_status = p_milestone_status;
154: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
155: cst_achieved CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'ACHIEVED';
156: cst_failed CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'FAILED';
157: BEGIN
158: -- Set the default message number

Line 155: cst_achieved CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'ACHIEVED';

151: SELECT mst.s_milestone_status
152: FROM IGS_PR_MS_STAT mst
153: WHERE mst.milestone_status = p_milestone_status;
154: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
155: cst_achieved CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'ACHIEVED';
156: cst_failed CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'FAILED';
157: BEGIN
158: -- Set the default message number
159: p_message_name := null;

Line 156: cst_failed CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'FAILED';

152: FROM IGS_PR_MS_STAT mst
153: WHERE mst.milestone_status = p_milestone_status;
154: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
155: cst_achieved CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'ACHIEVED';
156: cst_failed CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'FAILED';
157: BEGIN
158: -- Set the default message number
159: p_message_name := null;
160: -- Cursor handling

Line 225: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';

221: -- The imminent_days cannot be changed to bring the notification days
222: -- prior to the current date.
223: -- The re_reminder_days can only be set if the reminder_days are set.
224: DECLARE
225: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';
226: cst_replanned CONSTANT
227: IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
228: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
229: CURSOR c_mst IS

Line 227: IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';

223: -- The re_reminder_days can only be set if the reminder_days are set.
224: DECLARE
225: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';
226: cst_replanned CONSTANT
227: IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
228: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
229: CURSOR c_mst IS
230: SELECT mst.s_milestone_status
231: FROM IGS_PR_MS_STAT mst

Line 228: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;

224: DECLARE
225: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';
226: cst_replanned CONSTANT
227: IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
228: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
229: CURSOR c_mst IS
230: SELECT mst.s_milestone_status
231: FROM IGS_PR_MS_STAT mst
232: WHERE mst.milestone_status = p_milestone_status;

Line 231: FROM IGS_PR_MS_STAT mst

227: IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
228: v_mst_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
229: CURSOR c_mst IS
230: SELECT mst.s_milestone_status
231: FROM IGS_PR_MS_STAT mst
232: WHERE mst.milestone_status = p_milestone_status;
233: v_mty_nrd IGS_PR_MILESTONE.ovrd_ntfctn_reminder_days%TYPE;
234: v_mty_nrrd IGS_PR_MILESTONE.ovrd_ntfctn_re_reminder_days%TYPE;
235: CURSOR c_mty IS

Line 314: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';

310: -- Validate IGS_PR_MILESTONE.due_dt checking for,
311: -- If the IGS_PR_MILESTONE status has been changed to RE-PLANNED then
312: -- the due_dt must have been changed.
313: DECLARE
314: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';
315: cst_replanned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
316: CURSOR c_mil IS
317: SELECT mil.due_dt
318: FROM IGS_PR_MILESTONE mil

Line 315: cst_replanned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';

311: -- If the IGS_PR_MILESTONE status has been changed to RE-PLANNED then
312: -- the due_dt must have been changed.
313: DECLARE
314: cst_planned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'PLANNED';
315: cst_replanned CONSTANT IGS_PR_MS_STAT.s_milestone_status%TYPE := 'RE-PLANNED';
316: CURSOR c_mil IS
317: SELECT mil.due_dt
318: FROM IGS_PR_MILESTONE mil
319: WHERE mil.person_id = p_person_id AND

Line 358: -- Validate IGS_PR_MILESTONE.IGS_PR_MS_STAT, checking for :

354: p_validation_level IN VARCHAR2 ,
355: p_message_name OUT NOCOPY VARCHAR2 )
356: RETURN BOOLEAN AS
357: BEGIN -- resp_val_mil_mst
358: -- Validate IGS_PR_MILESTONE.IGS_PR_MS_STAT, checking for :
359: -- Closed IGS_PR_MILESTONE status.
360: DECLARE
361: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
362: cst_replanned CONSTANT VARCHAR2(10) := 'RE-PLANNED';

Line 369: FROM IGS_PR_MS_STAT mst

365: CURSOR c_mst (
366: cp_milestone_status IGS_PR_MILESTONE.milestone_status%TYPE) IS
367: SELECT s_milestone_status,
368: closed_ind
369: FROM IGS_PR_MS_STAT mst
370: WHERE mst.milestone_status = cp_milestone_status;
371: CURSOR c_mil IS
372: SELECT mst.s_milestone_status
373: FROM IGS_PR_MILESTONE mil,

Line 374: IGS_PR_MS_STAT mst

370: WHERE mst.milestone_status = cp_milestone_status;
371: CURSOR c_mil IS
372: SELECT mst.s_milestone_status
373: FROM IGS_PR_MILESTONE mil,
374: IGS_PR_MS_STAT mst
375: WHERE mil.person_id = p_person_id AND
376: mil.ca_sequence_number = p_ca_sequence_number AND
377: mil.sequence_number = p_preced_sequence_number AND
378: mst.milestone_status = mil.milestone_status;

Line 381: v_s_milestone_status IGS_PR_MS_STAT.s_milestone_status%TYPE;

377: mil.sequence_number = p_preced_sequence_number AND
378: mst.milestone_status = mil.milestone_status;
379: v_old_mst_rec c_mst%ROWTYPE;
380: v_new_mst_rec c_mst%ROWTYPE;
381: v_s_milestone_status IGS_PR_MS_STAT.s_milestone_status%TYPE;
382: BEGIN
383: -- Set the default message number
384: p_message_name := null;
385: OPEN c_mst (p_new_milestone_status);