eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_SUARC_LGCY_PUB dependencies on IGS_AS_SUA_REF_CDS

Line 219: IF igs_as_sua_ref_cds_pkg.get_uk_for_validation(

215: FETCH get_ref_code_id INTO l_number;
216: CLOSE get_ref_code_id;
217:
218: -- Check for UK validation.
219: IF igs_as_sua_ref_cds_pkg.get_uk_for_validation(
220: X_PERSON_ID => p_person_id,
221: X_COURSE_CD => p_suarc_dtls_rec.program_cd,
222: X_UOO_ID => p_uoo_id,
223: X_REFERENCE_CODE_ID => l_number,

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 303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;

299: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
300: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;
305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;
306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;
307: l_return_status VARCHAR2(30);

Line 304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;

300: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;
305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;
306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;
307: l_return_status VARCHAR2(30);
308: l_msg_count NUMBER ;

Line 305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;

301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;
305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;
306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;
307: l_return_status VARCHAR2(30);
308: l_msg_count NUMBER ;
309: l_msg_data VARCHAR2(2000);

Line 306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;

302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;
305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;
306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;
307: l_return_status VARCHAR2(30);
308: l_msg_count NUMBER ;
309: l_msg_data VARCHAR2(2000);
310: l_org_unit_cd igs_or_unit.org_unit_cd%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,

Line 464: INSERT INTO IGS_AS_SUA_REF_CDS (

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,
466: person_id,
467: course_cd,
468: uoo_id,