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_SS_GEN_001 dependencies on IGS_SS_APP_PGM_STG

Line 58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);

54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);
61: --added by nshee during build for Applicant-BOSS SS Bug 2622488
62: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,

Line 77: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,

73: p_adm_appl_number IN igs_ad_spl_interests.admission_appl_number%TYPE);
74: --added by nshee during build for Applicant-BOSS SS Bug 2622488
75: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
76: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
77: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,

Line 372: FROM igs_ss_adm_appl_stg m, IGS_SS_APP_PGM_STG d

368: l_error_code VARCHAR2(30);
369:
370: CURSOR c_admappl_pgm IS
371: SELECT d.*, m.app_source_id
372: FROM igs_ss_adm_appl_stg m, IGS_SS_APP_PGM_STG d
373: WHERE m.ss_adm_appl_id = d.ss_adm_appl_id
374: AND m.ss_adm_appl_id = p_appl_rec.ss_adm_appl_id
375: AND m.person_id = p_appl_rec.person_id;
376: --Autoadmit

Line 456: p_desc_flex_name => 'IGS_SS_APP_PGM_STG_FLEX'

452: p_attribute37 => c_admappl_pgm_rec.attribute37,
453: p_attribute38 => c_admappl_pgm_rec.attribute38,
454: p_attribute39 => c_admappl_pgm_rec.attribute39,
455: p_attribute40 => c_admappl_pgm_rec.attribute40,
456: p_desc_flex_name => 'IGS_SS_APP_PGM_STG_FLEX'
457: ) THEN
458: ROLLBACK TO sp_save_point1;
459: p_message_name := 'IGS_AD_INVALID_DESC_FLEX';
460: p_return_status := 'E';

Line 734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS

730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS
737: /*****************************************************************************************
738: Created By: [email protected]

Line 766: FROM igs_ss_app_pgm_stg

762: SELECT unit_set_cd, version_number, rank
763: FROM igs_ss_ad_unitse_stg
764: WHERE ss_admappl_pgm_id =
765: (SELECT ss_admappl_pgm_id
766: FROM igs_ss_app_pgm_stg
767: WHERE ss_adm_appl_id = p_ss_adm_appl_id --p_adm_appl_number
768: AND nominated_course_cd = p_nominated_course_cd
769: AND person_id = p_person_id);
770: BEGIN

Line 1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,

1134: END insert_othinst;
1135: --dhan
1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS
1141: /*****************************************************************************************
1142: Created By: [email protected]

Line 1159: FROM igs_ss_app_pgm_stg

1155: SELECT edu_goal_id
1156: FROM igs_ss_ad_edugoa_stg
1157: WHERE ss_admappl_pgm_id =
1158: (SELECT ss_admappl_pgm_id
1159: FROM igs_ss_app_pgm_stg
1160: WHERE ss_adm_appl_id = p_ss_adm_appl_id -- p_adm_appl_number
1161: AND nominated_course_cd = p_nominated_course_cd
1162: AND person_id = p_person_id);
1163: BEGIN

Line 1405: FROM igs_ss_app_pgm_stg

1401: --added by nshee during build for Applicant-BOSS SS Bug 2622488
1402: DELETE FROM igs_ss_ad_unitse_stg
1403: WHERE ss_admappl_pgm_id IN
1404: (SELECT ss_admappl_pgm_id
1405: FROM igs_ss_app_pgm_stg
1406: WHERE ss_adm_appl_id = p_adm_appl_number
1407: AND person_id = p_person_id);
1408:
1409: DELETE FROM igs_ss_ad_edugoa_stg

Line 1412: FROM igs_ss_app_pgm_stg

1408:
1409: DELETE FROM igs_ss_ad_edugoa_stg
1410: WHERE ss_admappl_pgm_id IN
1411: (SELECT ss_admappl_pgm_id
1412: FROM igs_ss_app_pgm_stg
1413: WHERE ss_adm_appl_id = p_adm_appl_number
1414: AND person_id = p_person_id);
1415:
1416: DELETE FROM igs_ss_ad_acadin_stg

Line 1433: DELETE FROM igs_ss_app_pgm_stg

1429: -- delete stg table records section
1430: DELETE FROM igs_ss_ad_othins_stg
1431: WHERE ss_adm_appl_id = p_adm_appl_number;
1432: --dhan
1433: DELETE FROM igs_ss_app_pgm_stg
1434: WHERE person_id = p_person_id
1435: AND ss_adm_appl_id = p_adm_appl_number;
1436:
1437: DELETE FROM igs_ss_adm_appl_stg

Line 3777: CURSOR c_prog_pref(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS

3773: -- Financial Verification- FIN_VER
3774: -- None
3775:
3776: -- Program Preferences- PROGRAM_PREF
3777: CURSOR c_prog_pref(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS
3778: SELECT SS_ADMAPPL_PGM_ID, ATTENDANCE_TYPE,
3779: ATTENDANCE_MODE,
3780: NOMINATED_COURSE_CD
3781: FROM IGS_SS_APP_PGM_STG

Line 3781: FROM IGS_SS_APP_PGM_STG

3777: CURSOR c_prog_pref(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS
3778: SELECT SS_ADMAPPL_PGM_ID, ATTENDANCE_TYPE,
3779: ATTENDANCE_MODE,
3780: NOMINATED_COURSE_CD
3781: FROM IGS_SS_APP_PGM_STG
3782: WHERE ss_adm_appl_id = cp_adm_appl_number;
3783:
3784: -- Program Preference Details- PROG_PREF_DTLS
3785: CURSOR c_prog_dtls(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS

Line 3785: CURSOR c_prog_dtls(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS

3781: FROM IGS_SS_APP_PGM_STG
3782: WHERE ss_adm_appl_id = cp_adm_appl_number;
3783:
3784: -- Program Preference Details- PROG_PREF_DTLS
3785: CURSOR c_prog_dtls(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS
3786: SELECT SS_ADMAPPL_PGM_ID,
3787: ENTRY_STATUS,
3788: ENTRY_LEVEL,
3789: FINAL_UNIT_SET_CD,

Line 3792: FROM IGS_SS_APP_PGM_STG

3788: ENTRY_LEVEL,
3789: FINAL_UNIT_SET_CD,
3790: NOMINATED_COURSE_CD,
3791: SCH_APL_TO_ID
3792: FROM IGS_SS_APP_PGM_STG
3793: WHERE ss_adm_appl_id = cp_adm_appl_number;
3794:
3795: -- Desired Majors/Minors- DESIRED_UNITS
3796: CURSOR c_dunits(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS

Line 3808: CURSOR c_fin_aid(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS

3804: FROM IGS_SS_AD_EDUGOA_STG
3805: WHERE ss_admappl_pgm_id = cp_ss_admappl_pgm;
3806:
3807: -- Financial Aid- FIN_AID
3808: CURSOR c_fin_aid(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS
3809: SELECT APPLY_FOR_FINAID, FINAID_APPLY_DATE
3810: FROM IGS_SS_APP_PGM_STG
3811: WHERE ss_adm_appl_id = cp_adm_appl_number;
3812:

Line 3810: FROM IGS_SS_APP_PGM_STG

3806:
3807: -- Financial Aid- FIN_AID
3808: CURSOR c_fin_aid(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS
3809: SELECT APPLY_FOR_FINAID, FINAID_APPLY_DATE
3810: FROM IGS_SS_APP_PGM_STG
3811: WHERE ss_adm_appl_id = cp_adm_appl_number;
3812:
3813: -- High School- SECONDARY
3814: CURSOR c_sec(cp_person_id igs_ad_appl.person_id%TYPE) IS

Line 3878: cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE,

3874:
3875: -- Personal Statements- PERSONAL_STMTS
3876: -- Cursors c_perstat and c_perstat_group added by abhiskum
3877: CURSOR c_perstat(cp_person_id igs_ad_appl.person_id%TYPE,
3878: cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE,
3879: cp_group_number IGS_AD_APTYP_PESTAT.group_number%TYPE) IS
3880: SELECT stg.persl_stat_type statement,
3881: DECODE(NVL(mandatory,'N'),'N','No','Yes') required,
3882: group_number,

Line 3894: cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE,

3890: AND stg.PERSON_ID = cp_person_id
3891: AND group_number = cp_group_number ;
3892:
3893: CURSOR c_perstat_group(cp_person_id igs_ad_appl.person_id%TYPE,
3894: cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE,
3895: cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS
3896: SELECT
3897: group_name statement,
3898: DECODE(NVL(group_required_flag,'N'),'N','No','Yes') required,