APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_NSUS_RTN_DTL_S

Line 10504: UPDATE igs_ps_nsus_rtn_dtl SET

10500: p_n_offset_value => l_c_rec.offset_value
10501: );
10502:
10503:
10504: UPDATE igs_ps_nsus_rtn_dtl SET
10505: offset_date = l_offset_date,
10506: last_updated_by = g_n_user_id ,
10507: last_update_date = sysdate ,
10508: last_update_login = g_n_login_id

Line 11228: igs_ps_nsus_rtn_dtl_s.NEXTVAL,

11224: last_updated_by,
11225: last_update_date,
11226: last_update_login )
11227: VALUES (
11228: igs_ps_nsus_rtn_dtl_s.NEXTVAL,
11229: l_n_non_std_usec_rtn_id,
11230: p_usec_ret_dtl_tbl(I).offset_value,
11231: p_usec_ret_dtl_tbl(I).retention_percent,
11232: p_usec_ret_dtl_tbl(I).retention_amount,

Line 11250: UPDATE IGS_PS_NSUS_RTN_DTL SET

11246: ||p_usec_ret_dtl_tbl(I).definition_level||' '||'Offset Value:'||p_usec_ret_dtl_tbl(I).offset_value);
11247: END IF;
11248:
11249: ELSE
11250: UPDATE IGS_PS_NSUS_RTN_DTL SET
11251: retention_percent = p_usec_ret_dtl_tbl(I).retention_percent,
11252: retention_amount = p_usec_ret_dtl_tbl(I).retention_amount,
11253: offset_date = l_d_offset_date,
11254: override_date_flag = p_usec_ret_dtl_tbl(I).override_date_flag,