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_AD_GEN_011 dependencies on IGS_GE_NUMBER

Line 896: || IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number)

892: -- Join all the parameters into one long string for the comments field
893: --
894: v_comments := 'Admission Calendar-'
895: || p_adm_cal_type || ' '
896: || IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number)
897: || ', Academic Calendar-'
898: || p_acad_cal_type || ' '
899: || IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number)
900: || ', Admission Category-'

Line 899: || IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number)

895: || p_adm_cal_type || ' '
896: || IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number)
897: || ', Academic Calendar-'
898: || p_acad_cal_type || ' '
899: || IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number)
900: || ', Admission Category-'
901: || p_admission_cat
902: || ', System Admission Process Type-'
903: || p_s_admission_process_type

Line 907: || IGS_GE_NUMBER.TO_CANN (p_person_id)

903: || p_s_admission_process_type
904: || ', Correspondence Type-'
905: || p_correspondence_type
906: || ', Person ID-'
907: || IGS_GE_NUMBER.TO_CANN (p_person_id)
908: || ', Admission Application Number-'
909: || IGS_GE_NUMBER.TO_CANN (p_admission_appl_number)
910: || ', Admission Outcome Status-'
911: || p_adm_outcome_status

Line 909: || IGS_GE_NUMBER.TO_CANN (p_admission_appl_number)

905: || p_correspondence_type
906: || ', Person ID-'
907: || IGS_GE_NUMBER.TO_CANN (p_person_id)
908: || ', Admission Application Number-'
909: || IGS_GE_NUMBER.TO_CANN (p_admission_appl_number)
910: || ', Admission Outcome Status-'
911: || p_adm_outcome_status
912: || ', Program of Study-'
913: || p_pgmofstudy

Line 921: || IGS_GE_NUMBER.TO_CANN (p_persid_grp)

917: || p_resd_class
918: || ', Residency Status-'
919: || p_resd_stat
920: || ', Person ID Group-'
921: || IGS_GE_NUMBER.TO_CANN (p_persid_grp)
922: || ', Organization Unit-'
923: || p_org_unit
924: || ', Sort By-'
925: || p_sortby;

Line 1352: USING NVL (p_acad_cal_type, '%'), NVL (IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number), '%'), NVL (p_adm_cal_type, '%'),

1348: AND prdv.residency_class (+) LIKE :12
1349: AND prdv.residency_status (+) LIKE :13
1350: AND NVL (acaiv.offer_dt, SYSDATE) <= SYSDATE
1351: ORDER BY padv.' || p_sortby
1352: USING NVL (p_acad_cal_type, '%'), NVL (IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number), '%'), NVL (p_adm_cal_type, '%'),
1353: NVL (IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number), '%'), p_admission_cat, p_s_admission_process_type, p_correspondence_type,
1354: NVL (p_org_unit, '%'), p_adm_outcome_status, p_pgmofstudy, p_response_stat, p_resd_stat, p_resd_class
1355: ;
1356: LOOP

Line 1353: NVL (IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number), '%'), p_admission_cat, p_s_admission_process_type, p_correspondence_type,

1349: AND prdv.residency_status (+) LIKE :13
1350: AND NVL (acaiv.offer_dt, SYSDATE) <= SYSDATE
1351: ORDER BY padv.' || p_sortby
1352: USING NVL (p_acad_cal_type, '%'), NVL (IGS_GE_NUMBER.TO_CANN (p_acad_ci_sequence_number), '%'), NVL (p_adm_cal_type, '%'),
1353: NVL (IGS_GE_NUMBER.TO_CANN (p_adm_ci_sequence_number), '%'), p_admission_cat, p_s_admission_process_type, p_correspondence_type,
1354: NVL (p_org_unit, '%'), p_adm_outcome_status, p_pgmofstudy, p_response_stat, p_resd_stat, p_resd_class
1355: ;
1356: LOOP
1357: FETCH c_aal_refcur INTO v_aa_aal_acaiv_rec;

Line 1455: igs_ge_gen_003.set_org_id (IGS_GE_NUMBER.TO_CANN (p_org_id));

1451: p_person_id_group := p_persid_grp;
1452: --
1453: -- Set Organization context for populating Multi-Org tables.
1454: --
1455: igs_ge_gen_003.set_org_id (IGS_GE_NUMBER.TO_CANN (p_org_id));
1456: retcode := 0;
1457: --
1458: -- Handle NULL parameter values.
1459: --

Line 1517: p_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (RTRIM (SUBSTR (p_acad_perd, 112, 6)));

1513: --
1514: -- Extract Academic Calendar
1515: --
1516: p_acad_cal_type := RTRIM (SUBSTR (p_acad_perd, 101, 10));
1517: p_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (RTRIM (SUBSTR (p_acad_perd, 112, 6)));
1518: --
1519: -- Extract Admission Calendar
1520: --
1521: p_adm_cal_type := RTRIM (SUBSTR (p_adm_perd, 101, 10));

Line 1522: p_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (RTRIM (SUBSTR (p_adm_perd, 112, 6)));

1518: --
1519: -- Extract Admission Calendar
1520: --
1521: p_adm_cal_type := RTRIM (SUBSTR (p_adm_perd, 101, 10));
1522: p_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (RTRIM (SUBSTR (p_adm_perd, 112, 6)));
1523: --
1524: -- Validate if the Academic and Admission Calendar are within Calendar Instance.
1525: --
1526: IF (igs_en_gen_014.enrs_get_within_ci (