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_PR_GEN_004 dependencies on IGS_GE_DATE

Line 373: spo.applied_dt = igs_ge_date.igsdate('0001/01/01')

369: (
370: (spo.decision_status = cst_approved AND
371: (
372: spo.applied_dt IS NULL OR
373: spo.applied_dt = igs_ge_date.igsdate('0001/01/01')
374: )
375: )
376: OR
377: ( spo.decision_status IN (

Line 1216: igs_ge_date.igschardt(p_ou_start_dt) || '|' ||

1212: p_prg_cal_type || '|' ||
1213: TO_CHAR(p_prg_sequence_number) || '|' ||
1214: p_course_type || '|' ||
1215: p_org_unit_cd || '|' ||
1216: igs_ge_date.igschardt(p_ou_start_dt) || '|' ||
1217: p_course_cd || '|' ||
1218: p_location_cd || '|' ||
1219: p_attendance_mode || '|' ||
1220: p_progression_status || '|' ||

Line 3459: p_course_type || '|' || p_org_unit_cd || '|' || igs_ge_date.igschardt (p_ou_start_dt) || '|' ||

3455: BEGIN
3456: -- Generate a log entry
3457: v_key :=
3458: p_prg_cal_type || '|' || TO_CHAR (p_prg_sequence_number) || '|' ||
3459: p_course_type || '|' || p_org_unit_cd || '|' || igs_ge_date.igschardt (p_ou_start_dt) || '|' ||
3460: p_course_cd || '|' || p_location_cd || '|' || p_attendance_mode || '|' ||
3461: p_progression_status || '|' || p_enrolment_cat || '|' || TO_CHAR (p_group_id) || '|' || p_processing_type;
3462: --
3463: igs_ge_gen_003.genp_ins_log (cst_prg_appl, v_key, v_log_creation_dt);

Line 4337: NVL(spo.expiry_dt,igs_ge_date.igsdate('9999/01/01')) > TRUNC(SYSDATE)

4333: spo.pra_sequence_number = p_pra_sequence_number AND
4334: spo.decision_status IN (
4335: cst_pending,
4336: cst_approved) AND
4337: NVL(spo.expiry_dt,igs_ge_date.igsdate('9999/01/01')) > TRUNC(SYSDATE)
4338: FOR UPDATE NOWAIT;
4339: CURSOR c_spc (
4340: cp_sequence_number IGS_PR_STDNT_PR_PS.spo_sequence_number%TYPE) IS
4341: SELECT spc.ROWID

Line 6216: cst_applied_dt CONSTANT DATE := igs_ge_date.igsdate('0001/01/01');

6212: DECLARE
6213: e_record_locked EXCEPTION;
6214: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
6215: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
6216: cst_applied_dt CONSTANT DATE := igs_ge_date.igsdate('0001/01/01');
6217: v_decision_status IGS_PR_STDNT_PR_OU.decision_status%TYPE;
6218: CURSOR c_spo_upd IS
6219: SELECT spo.*, spo.ROWID
6220: FROM IGS_PR_STDNT_PR_OU spo

Line 6512: applied_dt = igs_ge_date.igsdate('0001/01/01')

6508: FETCH c_spo_upd INTO v_spo_upd_rec;
6509: /*
6510: UPDATE IGS_PR_STDNT_PR_OU
6511: SET expiry_dt = v_expiry_dt,
6512: applied_dt = igs_ge_date.igsdate('0001/01/01')
6513: WHERE CURRENT OF c_spo_upd;
6514: */
6515: igs_pr_stdnt_pr_ou_pkg.update_row(
6516: x_rowid => v_spo_upd_rec.ROWID,

Line 6533: x_applied_dt => igs_ge_date.igsdate('0001/01/01'),

6529: x_decision_status => v_spo_upd_rec.decision_status,
6530: x_decision_dt => v_spo_upd_rec.decision_dt,
6531: x_decision_org_unit_cd => v_spo_upd_rec.decision_org_unit_cd,
6532: x_decision_ou_start_dt => v_spo_upd_rec.decision_ou_start_dt,
6533: x_applied_dt => igs_ge_date.igsdate('0001/01/01'),
6534: x_show_cause_expiry_dt => v_spo_upd_rec.show_cause_expiry_dt,
6535: x_show_cause_dt => v_spo_upd_rec.show_cause_dt,
6536: x_show_cause_outcome_dt => v_spo_upd_rec.show_cause_outcome_dt,
6537: x_show_cause_outcome_type => v_spo_upd_rec.show_cause_outcome_type,