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_PERS_UNT_EXCL

Line 2797: FROM igs_pe_pers_unt_excl pue

2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2796: SELECT pue.*, pue.ROWID
2797: FROM igs_pe_pers_unt_excl pue
2798: WHERE pue.person_id = p_person_id AND
2799: pue.encumbrance_type = cp_encumbrance_type AND
2800: pue.pen_start_dt = cp_pen_start_dt AND
2801: pue.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2809: TYPE t_pue_table IS TABLE OF igs_pe_pers_unt_excl.unit_cd%TYPE

2805: pue.expiry_dt > gcst_sysdate)
2806: FOR UPDATE NOWAIT;
2807:
2808:
2809: TYPE t_pue_table IS TABLE OF igs_pe_pers_unt_excl.unit_cd%TYPE
2810: INDEX BY BINARY_INTEGER;
2811:
2812: v_pue_table t_pue_table;
2813: v_pue_index BINARY_INTEGER;

Line 2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,

2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS
2823:
2824: SELECT pue.*, pue.ROWID
2825: FROM igs_pe_pers_unt_excl pue

Line 2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS

2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS
2823:
2824: SELECT pue.*, pue.ROWID
2825: FROM igs_pe_pers_unt_excl pue
2826: WHERE pue.person_id = p_person_id AND

Line 2825: FROM igs_pe_pers_unt_excl pue

2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS
2823:
2824: SELECT pue.*, pue.ROWID
2825: FROM igs_pe_pers_unt_excl pue
2826: WHERE pue.person_id = p_person_id AND
2827: pue.encumbrance_type = cp_encumbrance_type AND
2828: pue.pen_start_dt = cp_pen_start_dt AND
2829: pue.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3095: FROM igs_pe_pers_unt_excl pue

3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3094: SELECT pue.*, pue.ROWID
3095: FROM igs_pe_pers_unt_excl pue
3096: WHERE pue.person_id = p_person_id AND
3097: pue.encumbrance_type = cp_encumbrance_type AND
3098: pue.pen_start_dt = cp_pen_start_dt AND
3099: pue.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3225: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

3221: v_pen_rec.start_dt,
3222: v_pee_rec.s_encmb_effect_type,
3223: v_pee_rec.pee_start_dt,
3224: v_pee_rec.sequence_number) LOOP
3225: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
3226: X_ROWID => v_pue_rec.ROWID,
3227: X_PERSON_ID => v_pue_rec.PERSON_ID,
3228: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
3229: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 3491: FROM igs_pe_pers_unt_excl pue

3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3490: SELECT pue.*, pue.ROWID
3491: FROM igs_pe_pers_unt_excl pue
3492: WHERE pue.person_id = p_person_id AND
3493: pue.encumbrance_type = cp_encumbrance_type AND
3494: pue.pen_start_dt = cp_pen_start_dt AND
3495: pue.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3611: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

3607: v_pee_rec.pen_start_dt,
3608: v_pee_rec.s_encmb_effect_type,
3609: v_pee_rec.pee_start_dt,
3610: v_pee_rec.sequence_number) LOOP
3611: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
3612: X_ROWID => v_pue_rec.ROWID,
3613: X_PERSON_ID => v_pue_rec.PERSON_ID,
3614: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
3615: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 4287: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

4283: EXIT;
4284: END IF;
4285: END LOOP;
4286: IF NOT v_unit_cd_found THEN
4287: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
4288: X_ROWID => v_pue_rec.ROWID,
4289: X_PERSON_ID => v_pue_rec.PERSON_ID,
4290: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
4291: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 4324: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

4320: v_spu_table(v_index1),
4321: gcst_sysdate);
4322: FETCH c_pue_dup INTO v_pue_dup_rec;
4323: IF c_pue_dup%FOUND THEN
4324: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
4325: X_ROWID => v_pue_dup_rec.ROWID,
4326: X_PERSON_ID => v_pue_dup_rec.PERSON_ID,
4327: X_ENCUMBRANCE_TYPE => v_pue_dup_rec.ENCUMBRANCE_TYPE,
4328: X_PEN_START_DT => v_pue_dup_rec.PEN_START_DT,

Line 4343: igs_pe_pers_unt_excl_PKG.INSERT_ROW (

4339: CLOSE c_pue_dup;
4340: DECLARE
4341: LV_ROWID VARCHAR2(25);
4342: BEGIN
4343: igs_pe_pers_unt_excl_PKG.INSERT_ROW (
4344: X_ROWID =>LV_ROWID,
4345: X_PERSON_ID =>p_person_id,
4346: X_ENCUMBRANCE_TYPE =>v_pee_rec.encumbrance_type,
4347: X_PEN_START_DT =>v_pee_rec.pen_start_dt,

Line 4763: igs_pe_pers_unt_excl_PKG.INSERT_ROW (

4759: FOR v_spu_rec IN c_spu (cst_excluded) LOOP
4760: DECLARE
4761: LV_ROWID VARCHAR2(25);
4762: BEGIN
4763: igs_pe_pers_unt_excl_PKG.INSERT_ROW (
4764: X_ROWID =>LV_ROWID,
4765: X_PERSON_ID =>p_person_id,
4766: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4767: X_PEN_START_DT =>gcst_sysdatetime, --gjha Changed it from sysdatetime --Modified by Prajeesh