APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_US_REQ_REF_CD_S

Line 8150: igs_ps_us_req_ref_cd_s.NEXTVAL,

8146: last_update_login,
8147: reference_code,
8148: reference_code_desc
8149: ) VALUES (
8150: igs_ps_us_req_ref_cd_s.NEXTVAL,
8151: l_n_usec_ref_id,
8152: p_tab_ref_cd(i).reference_cd_type,
8153: SYSDATE,
8154: g_n_user_id,

Line 8171: UPDATE igs_ps_us_req_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,

8167: ' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8168: END IF;
8169: ELSE
8170:
8171: UPDATE igs_ps_us_req_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8172: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8173: reference_cd_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8174:
8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN