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

Line 2477: new_references.expected_completion_yr := igs_ge_number.to_num(column_value);

2473: NULL;
2474: ELSIF upper(column_name) = 'EXPECTED_COMPLETION_PERD' THEN
2475: new_references.expected_completion_perd := column_value;
2476: ELSIF upper(column_name) = 'EXPECTED_COMPLETION_YR' THEN
2477: new_references.expected_completion_yr := igs_ge_number.to_num(column_value);
2478: ELSIF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' THEN
2479: new_references.intrntnl_acceptance_advice_num := igs_ge_number.to_num(column_value);
2480: ELSIF upper(column_name) = 'SECONDARY_ASS_RANK' THEN
2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);

Line 2479: new_references.intrntnl_acceptance_advice_num := igs_ge_number.to_num(column_value);

2475: new_references.expected_completion_perd := column_value;
2476: ELSIF upper(column_name) = 'EXPECTED_COMPLETION_YR' THEN
2477: new_references.expected_completion_yr := igs_ge_number.to_num(column_value);
2478: ELSIF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' THEN
2479: new_references.intrntnl_acceptance_advice_num := igs_ge_number.to_num(column_value);
2480: ELSIF upper(column_name) = 'SECONDARY_ASS_RANK' THEN
2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);
2482: ELSIF upper(column_name) = 'ASS_RANK' THEN
2483: new_references.ass_rank := igs_ge_number.to_num(column_value);

Line 2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);

2477: new_references.expected_completion_yr := igs_ge_number.to_num(column_value);
2478: ELSIF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' THEN
2479: new_references.intrntnl_acceptance_advice_num := igs_ge_number.to_num(column_value);
2480: ELSIF upper(column_name) = 'SECONDARY_ASS_RANK' THEN
2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);
2482: ELSIF upper(column_name) = 'ASS_RANK' THEN
2483: new_references.ass_rank := igs_ge_number.to_num(column_value);
2484: ELSIF upper(column_name) = 'DEFERRED_ADM_CI_SEQUENCE_NUM' THEN
2485: new_references.deferred_adm_ci_sequence_num := igs_ge_number.to_num(column_value);

Line 2483: new_references.ass_rank := igs_ge_number.to_num(column_value);

2479: new_references.intrntnl_acceptance_advice_num := igs_ge_number.to_num(column_value);
2480: ELSIF upper(column_name) = 'SECONDARY_ASS_RANK' THEN
2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);
2482: ELSIF upper(column_name) = 'ASS_RANK' THEN
2483: new_references.ass_rank := igs_ge_number.to_num(column_value);
2484: ELSIF upper(column_name) = 'DEFERRED_ADM_CI_SEQUENCE_NUM' THEN
2485: new_references.deferred_adm_ci_sequence_num := igs_ge_number.to_num(column_value);
2486: ELSIF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' THEN
2487: new_references.cndtnl_offer_must_be_stsfd_ind := column_value;

Line 2485: new_references.deferred_adm_ci_sequence_num := igs_ge_number.to_num(column_value);

2481: new_references.secondary_ass_rank := igs_ge_number.to_num(column_value);
2482: ELSIF upper(column_name) = 'ASS_RANK' THEN
2483: new_references.ass_rank := igs_ge_number.to_num(column_value);
2484: ELSIF upper(column_name) = 'DEFERRED_ADM_CI_SEQUENCE_NUM' THEN
2485: new_references.deferred_adm_ci_sequence_num := igs_ge_number.to_num(column_value);
2486: ELSIF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' THEN
2487: new_references.cndtnl_offer_must_be_stsfd_ind := column_value;
2488: ELSIF upper(column_name) = 'PREFERENCE_NUMBER' THEN
2489: new_references.preference_number := igs_ge_number.to_num(column_value);

Line 2489: new_references.preference_number := igs_ge_number.to_num(column_value);

2485: new_references.deferred_adm_ci_sequence_num := igs_ge_number.to_num(column_value);
2486: ELSIF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' THEN
2487: new_references.cndtnl_offer_must_be_stsfd_ind := column_value;
2488: ELSIF upper(column_name) = 'PREFERENCE_NUMBER' THEN
2489: new_references.preference_number := igs_ge_number.to_num(column_value);
2490: ELSIF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' THEN
2491: new_references.adm_ci_sequence_number := igs_ge_number.to_num(column_value);
2492: ELSIF upper(column_name) = 'SEQUENCE_NUMBER' THEN
2493: new_references.sequence_number := igs_ge_number.to_num(column_value);

Line 2491: new_references.adm_ci_sequence_number := igs_ge_number.to_num(column_value);

2487: new_references.cndtnl_offer_must_be_stsfd_ind := column_value;
2488: ELSIF upper(column_name) = 'PREFERENCE_NUMBER' THEN
2489: new_references.preference_number := igs_ge_number.to_num(column_value);
2490: ELSIF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' THEN
2491: new_references.adm_ci_sequence_number := igs_ge_number.to_num(column_value);
2492: ELSIF upper(column_name) = 'SEQUENCE_NUMBER' THEN
2493: new_references.sequence_number := igs_ge_number.to_num(column_value);
2494: ELSIF upper(column_name) = 'ADM_CAL_TYPE' THEN
2495: new_references.adm_cal_type := column_value;

Line 2493: new_references.sequence_number := igs_ge_number.to_num(column_value);

2489: new_references.preference_number := igs_ge_number.to_num(column_value);
2490: ELSIF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' THEN
2491: new_references.adm_ci_sequence_number := igs_ge_number.to_num(column_value);
2492: ELSIF upper(column_name) = 'SEQUENCE_NUMBER' THEN
2493: new_references.sequence_number := igs_ge_number.to_num(column_value);
2494: ELSIF upper(column_name) = 'ADM_CAL_TYPE' THEN
2495: new_references.adm_cal_type := column_value;
2496: ELSIF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' THEN
2497: new_references.adm_cndtnl_offer_status := column_value;

Line 7109: IGS_GE_NUMBER.TO_CANN(NULL), -- made obsolete, earlier passed rec_c_igs_pe_ucas.api_person_id,

7105: P_CONDITION_CATEGORY => :10,
7106: P_CONDITION_NAME => :11,
7107: P_UC_TRAN_ID => :12); END;'
7108: USING
7109: IGS_GE_NUMBER.TO_CANN(NULL), -- made obsolete, earlier passed rec_c_igs_pe_ucas.api_person_id,
7110: rec_c_igs_ad_appl.choice_number,
7111: rec_c_igs_pe_person.person_number,
7112: p_admission_appl_number,
7113: p_nominated_course_cd,