APPS.IGS_AS_SUARC_LGCY_PUB dependencies on IGS_AS_SUA_REF_CDS_S

Line 295: l_suar_id igs_as_sua_ref_cds.suar_id%TYPE;

291: x_msg_data OUT NOCOPY VARCHAR2) AS
292: l_api_name CONSTANT VARCHAR2(30) := 'create_suarc';
293: l_api_version CONSTANT NUMBER := 1.0;
294: l_insert_flag BOOLEAN := TRUE;
295: l_suar_id igs_as_sua_ref_cds.suar_id%TYPE;
296: l_person_id igs_pe_person.person_id%TYPE;
297: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
298: l_cal_type igs_en_su_attempt.cal_type%TYPE;
299: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;

Line 461: SELECT IGS_AS_SUA_REF_CDS_S.nextval INTO l_suar_id from dual;

457: p_suarc_dtls_rec => p_suarc_dtls_rec ) ;
458:
459: END IF ;
460: --swaghmar Bug #4327987
461: SELECT IGS_AS_SUA_REF_CDS_S.nextval INTO l_suar_id from dual;
462:
463: IF g_suarc_status = 'VALID' THEN
464: INSERT INTO IGS_AS_SUA_REF_CDS (
465: SUAR_ID,