APPS.IGS_PR_GEN_006 dependencies on IGS_PE_UNT_REQUIRMNT_PKG

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 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