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_SET_EXCL

Line 2725: FROM igs_pe_unt_set_excl puse

2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2724: SELECT puse.*, puse.ROWID
2725: FROM igs_pe_unt_set_excl puse
2726: WHERE puse.person_id = p_person_id AND
2727: puse.encumbrance_type = cp_encumbrance_type AND
2728: puse.pen_start_dt = cp_pen_start_dt AND
2729: puse.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2737: unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,

2733: puse.expiry_dt > gcst_sysdate)
2734: FOR UPDATE NOWAIT;
2735:
2736: TYPE r_puse_record_type IS RECORD (
2737: unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2738: us_version_number igs_pe_unt_set_excl.us_version_number%TYPE);
2739:
2740: r_puse_record r_puse_record_type;
2741: TYPE t_puse_table IS TABLE OF r_puse_record%TYPE

Line 2738: us_version_number igs_pe_unt_set_excl.us_version_number%TYPE);

2734: FOR UPDATE NOWAIT;
2735:
2736: TYPE r_puse_record_type IS RECORD (
2737: unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2738: us_version_number igs_pe_unt_set_excl.us_version_number%TYPE);
2739:
2740: r_puse_record r_puse_record_type;
2741: TYPE t_puse_table IS TABLE OF r_puse_record%TYPE
2742: INDEX BY BINARY_INTEGER;

Line 2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,

2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS
2756: SELECT puse.*, puse.ROWID
2757: FROM igs_pe_unt_set_excl puse

Line 2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,

2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS
2756: SELECT puse.*, puse.ROWID
2757: FROM igs_pe_unt_set_excl puse
2758: WHERE puse.person_id = p_person_id AND

Line 2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS

2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS
2756: SELECT puse.*, puse.ROWID
2757: FROM igs_pe_unt_set_excl puse
2758: WHERE puse.person_id = p_person_id AND
2759: puse.encumbrance_type = cp_encumbrance_type AND

Line 2757: FROM igs_pe_unt_set_excl puse

2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS
2756: SELECT puse.*, puse.ROWID
2757: FROM igs_pe_unt_set_excl puse
2758: WHERE puse.person_id = p_person_id AND
2759: puse.encumbrance_type = cp_encumbrance_type AND
2760: puse.pen_start_dt = cp_pen_start_dt AND
2761: puse.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3077: FROM igs_pe_unt_set_excl puse

3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3076: SELECT puse.*,puse.ROWID
3077: FROM igs_pe_unt_set_excl puse
3078: WHERE puse.person_id = p_person_id AND
3079: puse.encumbrance_type = cp_encumbrance_type AND
3080: puse.pen_start_dt = cp_pen_start_dt AND
3081: puse.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3202: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

3198: v_pen_rec.start_dt,
3199: v_pee_rec.s_encmb_effect_type,
3200: v_pee_rec.pee_start_dt,
3201: v_pee_rec.sequence_number) LOOP
3202: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
3203: X_ROWID => v_puse_rec.ROWID,
3204: X_PERSON_ID => v_puse_rec.PERSON_ID,
3205: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
3206: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 3475: FROM igs_pe_unt_set_excl puse

3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3474: SELECT puse.*, puse.ROWID
3475: FROM igs_pe_unt_set_excl puse
3476: WHERE puse.person_id = p_person_id AND
3477: puse.encumbrance_type = cp_encumbrance_type AND
3478: puse.pen_start_dt = cp_pen_start_dt AND
3479: puse.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3589: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

3585: v_pee_rec.pen_start_dt,
3586: v_pee_rec.s_encmb_effect_type,
3587: v_pee_rec.pee_start_dt,
3588: v_pee_rec.sequence_number) LOOP
3589: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
3590: X_ROWID => v_puse_rec.ROWID,
3591: X_PERSON_ID => v_puse_rec.PERSON_ID,
3592: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
3593: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 4180: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

4176: END IF;
4177: END LOOP;
4178:
4179: IF NOT v_unit_set_found THEN
4180: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
4181: X_ROWID => v_puse_rec.ROWID,
4182: X_PERSON_ID => v_puse_rec.PERSON_ID,
4183: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
4184: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 4222: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

4218: v_spus_table(v_index1).version_number,
4219: gcst_sysdate);
4220: FETCH c_puse_dup INTO v_puse_dup_rec;
4221: IF c_puse_dup%FOUND THEN
4222: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
4223: X_ROWID => v_puse_dup_rec.ROWID,
4224: X_PERSON_ID => v_puse_dup_rec.PERSON_ID,
4225: X_ENCUMBRANCE_TYPE => v_puse_dup_rec.ENCUMBRANCE_TYPE,
4226: X_PEN_START_DT => v_puse_dup_rec.PEN_START_DT,

Line 4243: igs_pe_unt_set_excl_pkg.INSERT_ROW (

4239: CLOSE c_puse_dup;
4240: DECLARE
4241: lv_rowid VARCHAR2(25);
4242: BEGIN
4243: igs_pe_unt_set_excl_pkg.INSERT_ROW (
4244: X_ROWID =>lv_rowid,
4245: X_PERSON_ID =>p_person_id,
4246: X_ENCUMBRANCE_TYPE=> v_pee_rec.encumbrance_type,
4247: X_PEN_START_DT=> v_pee_rec.pen_start_dt,

Line 4742: igs_pe_unt_set_excl_pkg.INSERT_ROW (

4738: FOR v_spus_rec IN c_spus LOOP
4739: DECLARE
4740: lv_rowid VARCHAR2(25);
4741: BEGIN
4742: igs_pe_unt_set_excl_pkg.INSERT_ROW (
4743: X_ROWID =>lv_rowid,
4744: X_PERSON_ID =>p_person_id,
4745: X_ENCUMBRANCE_TYPE=> v_spo_rec.encumbrance_type,
4746: X_PEN_START_DT=> gcst_sysdatetime, --gjha Changed it from sysdatetime --modified by Prajeesh