APPS.IGS_PS_USEC_REF_CD_PKG dependencies on IGS_PS_USEC_REF_CD_S

Line 536: SELECT igs_ps_usec_ref_cd_s.nextval

532: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536: SELECT igs_ps_usec_ref_cd_s.nextval
537: INTO x_unit_section_reference_cd_id
538: FROM dual;
539: before_dml(
540: p_action=>'INSERT',

Line 700: UPDATE igs_ps_usec_ref_cd SET

696: x_reference_code_type=>x_reference_code_type,
697: x_reference_code=>x_reference_code,
698: x_reference_code_desc=>x_reference_code_desc
699: );
700: UPDATE igs_ps_usec_ref_cd SET
701: unit_section_reference_id = new_references.unit_section_reference_id,
702: last_update_date = x_last_update_date,
703: last_updated_by = x_last_updated_by,
704: last_update_login = x_last_update_login,