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_006 dependencies on IGS_PE_UNT_REQUIRMNT

Line 2845: FROM igs_pe_unt_requirmnt pur

2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2844: SELECT pur.*, pur.ROWID
2845: FROM igs_pe_unt_requirmnt pur
2846: WHERE pur.person_id = p_person_id AND
2847: pur.encumbrance_type = cp_encumbrance_type AND
2848: pur.pen_start_dt = cp_pen_start_dt AND
2849: pur.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2856: TYPE t_pur_table IS TABLE OF igs_pe_unt_requirmnt.unit_cd%TYPE

2852: (pur.expiry_dt IS NULL OR
2853: pur.expiry_dt > gcst_sysdate)
2854: FOR UPDATE NOWAIT;
2855:
2856: TYPE t_pur_table IS TABLE OF igs_pe_unt_requirmnt.unit_cd%TYPE
2857: INDEX BY BINARY_INTEGER;
2858:
2859: v_pur_table t_pur_table;
2860: v_pur_index BINARY_INTEGER;

Line 2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,

2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS
2870: SELECT pur.*, pur.ROWID
2871: FROM igs_pe_unt_requirmnt pur
2872: WHERE pur.person_id = p_person_id AND

Line 2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS

2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS
2870: SELECT pur.*, pur.ROWID
2871: FROM igs_pe_unt_requirmnt pur
2872: WHERE pur.person_id = p_person_id AND
2873: pur.encumbrance_type = cp_encumbrance_type AND

Line 2871: FROM igs_pe_unt_requirmnt pur

2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS
2870: SELECT pur.*, pur.ROWID
2871: FROM igs_pe_unt_requirmnt pur
2872: WHERE pur.person_id = p_person_id AND
2873: pur.encumbrance_type = cp_encumbrance_type AND
2874: pur.pen_start_dt = cp_pen_start_dt AND
2875: pur.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3113: FROM igs_pe_unt_requirmnt pur

3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3112: SELECT pur.*, pur.ROWID
3113: FROM igs_pe_unt_requirmnt pur
3114: WHERE pur.person_id = p_person_id AND
3115: pur.encumbrance_type = cp_encumbrance_type AND
3116: pur.pen_start_dt = cp_pen_start_dt AND
3117: pur.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3246: igs_pe_unt_requirmnt_pkg.update_row(

3242: v_pen_rec.start_dt,
3243: v_pee_rec.s_encmb_effect_type,
3244: v_pee_rec.pee_start_dt,
3245: v_pee_rec.sequence_number) LOOP
3246: igs_pe_unt_requirmnt_pkg.update_row(
3247: X_ROWID => v_pur_rec.ROWID,
3248: X_PERSON_ID => v_pur_rec.PERSON_ID,
3249: X_ENCUMBRANCE_TYPE => v_pur_rec.ENCUMBRANCE_TYPE,
3250: X_PEN_START_DT => v_pur_rec.PEN_START_DT,

Line 3507: FROM igs_pe_unt_requirmnt pur

3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3506: SELECT pur.*, pur.ROWID
3507: FROM igs_pe_unt_requirmnt pur
3508: WHERE pur.person_id = p_person_id AND
3509: pur.encumbrance_type = cp_encumbrance_type AND
3510: pur.pen_start_dt = cp_pen_start_dt AND
3511: pur.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3659: UPDATE igs_pe_unt_requirmnt

3655: v_pee_rec.s_encmb_effect_type,
3656: v_pee_rec.pee_start_dt,
3657: v_pee_rec.sequence_number) LOOP
3658: /*
3659: UPDATE igs_pe_unt_requirmnt
3660: SET expiry_dt = gcst_sysdate
3661: WHERE CURRENT OF c_pur;
3662: */
3663: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(

Line 3663: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(

3659: UPDATE igs_pe_unt_requirmnt
3660: SET expiry_dt = gcst_sysdate
3661: WHERE CURRENT OF c_pur;
3662: */
3663: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(
3664: X_ROWID => v_pur_rec.ROWID,
3665: X_PERSON_ID => v_pur_rec.PERSON_ID,
3666: X_ENCUMBRANCE_TYPE => v_pur_rec.ENCUMBRANCE_TYPE,
3667: X_PEN_START_DT => v_pur_rec.PEN_START_DT,

Line 4386: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(

4382: EXIT;
4383: END IF;
4384: END LOOP;
4385: IF NOT v_unit_cd_found THEN
4386: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(
4387: X_ROWID => v_pur_rec.ROWID,
4388: X_PERSON_ID => v_pur_rec.PERSON_ID,
4389: X_ENCUMBRANCE_TYPE => v_pur_rec.ENCUMBRANCE_TYPE,
4390: X_PEN_START_DT => v_pur_rec.PEN_START_DT,

Line 4422: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(

4418: v_spu_table(v_index1),
4419: gcst_sysdate);
4420: FETCH c_pur_dup INTO v_pur_dup_rec;
4421: IF c_pur_dup%FOUND THEN
4422: igs_pe_unt_requirmnt_pkg.UPDATE_ROW(
4423: X_ROWID => v_pur_dup_rec.ROWID,
4424: X_PERSON_ID => v_pur_dup_rec.PERSON_ID,
4425: X_ENCUMBRANCE_TYPE => v_pur_dup_rec.ENCUMBRANCE_TYPE,
4426: X_PEN_START_DT => v_pur_dup_rec.PEN_START_DT,

Line 4441: igs_pe_unt_requirmnt_pkg.INSERT_ROW (

4437: CLOSE c_pur_dup;
4438: DECLARE
4439: lv_rowid VARCHAR2(25);
4440: BEGIN
4441: igs_pe_unt_requirmnt_pkg.INSERT_ROW (
4442: X_ROWID =>lv_rowid,
4443: X_PERSON_ID =>p_person_id,
4444: X_ENCUMBRANCE_TYPE=> v_pee_rec.encumbrance_type,
4445: X_PEN_START_DT=> v_pee_rec.pen_start_dt,

Line 4783: igs_pe_unt_requirmnt_pkg.INSERT_ROW (

4779: FOR v_spu_rec IN c_spu (cst_required) LOOP
4780: DECLARE
4781: lv_rowid VARCHAR2(25);
4782: BEGIN
4783: igs_pe_unt_requirmnt_pkg.INSERT_ROW (
4784: X_ROWID =>lv_rowid,
4785: X_PERSON_ID =>p_person_id,
4786: X_ENCUMBRANCE_TYPE=> v_spo_rec.encumbrance_type,
4787: X_PEN_START_DT=> gcst_sysdatetime, --gjha Changed it from gcst_sysdatetime --Modified by Prajeesh