APPS.IGS_SV_UTIL dependencies on IGS_SV_PRGMS_INFO

Line 127: x_tbl_name := 'IGS_SV_PRGMS_INFO';

123: x_tbl_name := 'IGS_SV_OTH_INFO';
124: ELSIF ( p_key_code = 'SV_PRGMS'
125: OR p_key_code = 'SV_STATUS'
126: ) THEN
127: x_tbl_name := 'IGS_SV_PRGMS_INFO';
128: ELSIF (p_key_code = 'SV_SOA') THEN
129: x_tbl_name := 'IGS_SV_ADDRESSES';
130: x_extra_critra := ' and PARTY_SITE_ID = :p_extra_param';
131: ELSIF (p_key_code = 'SV_F_ADDR') THEN

Line 136: x_tbl_name := 'IGS_SV_PRGMS_INFO';

132: x_tbl_name := 'IGS_SV_ADDRESSES';
133: ELSIF (p_key_code = 'SV_US_ADDR') THEN
134: x_tbl_name := 'IGS_SV_ADDRESSES';
135: ELSIF (p_key_code = 'SV_AUTH_DROP') THEN
136: x_tbl_name := 'IGS_SV_PRGMS_INFO';
137: x_extra_critra := ' and SEVIS_AUTH_ID = :p_extra_param';
138: END IF;
139: END get_tbl_extra_params;
140:

Line 596: p_person_id igs_sv_prgms_info.person_id%TYPE,

592: END create_Person_Rec;
593:
594:
595: FUNCTION GET_BTCH_PROCESS_DT(
596: p_person_id igs_sv_prgms_info.person_id%TYPE,
597: p_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE
598: ) RETURN DATE IS
599: /******************************************************************
600: Created By : Manoj Kumar

Line 597: p_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE

593:
594:
595: FUNCTION GET_BTCH_PROCESS_DT(
596: p_person_id igs_sv_prgms_info.person_id%TYPE,
597: p_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE
598: ) RETURN DATE IS
599: /******************************************************************
600: Created By : Manoj Kumar
601:

Line 615: FROM igs_sv_prgms_info prgm, IGS_SV_BATCHES btch

611:
612: ******************************************************************/
613: CURSOR c_btch_date IS
614: SELECT MAX(prgm.BATCH_ID) , btch.creation_date
615: FROM igs_sv_prgms_info prgm, IGS_SV_BATCHES btch
616: WHERE prgm.batch_id = btch.batch_id AND
617: prgm.person_id = p_person_id AND
618: prgm.sevis_auth_id = p_sevis_auth_id AND
619: prgm.prgm_action_type = 'DB' AND