DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_SP_FEES_S

Line 7934: igs_ps_usec_sp_fees_s.NEXTVAL,

7930: LAST_UPDATED_BY,
7931: LAST_UPDATE_DATE,
7932: LAST_UPDATE_LOGIN )
7933: VALUES (
7934: igs_ps_usec_sp_fees_s.NEXTVAL,
7935: l_n_uoo_id,
7936: p_usec_sp_fee_tbl(I).fee_type,
7937: p_usec_sp_fee_tbl(I).sp_fee_amt,
7938: p_usec_sp_fee_tbl(I).closed_flag,

Line 7953: UPDATE IGS_PS_USEC_SP_FEES SET

7949: p_usec_sp_fee_tbl(I).unit_class||' '||'Fee type:'||p_usec_sp_fee_tbl(I).fee_type);
7950: END IF;
7951:
7952: ELSE
7953: UPDATE IGS_PS_USEC_SP_FEES SET
7954: SP_FEE_AMT = p_usec_sp_fee_tbl(I).sp_fee_amt,
7955: CLOSED_FLAG = p_usec_sp_fee_tbl(I).closed_flag,
7956: last_updated_by = g_n_user_id ,
7957: last_update_date = sysdate ,