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

Line 853: FROM IGS_SS_APP_PGM_STG

849:
850: -- Cursor to check if another Program Instance for this Instance's Parent Application exists or not.
851: CURSOR c_prog_inst(p_ss_adm_appl_id NUMBER) IS
852: SELECT SS_ADMAPPL_PGM_ID
853: FROM IGS_SS_APP_PGM_STG
854: WHERE SS_ADM_APPL_ID = p_ss_adm_appl_id;
855:
856: /* ******************* Put additional parameters here ******************************************** */
857: l_admappl_rec c_admappl%ROWTYPE := NULL;

Line 864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;

860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;
861: l_att_mode_rec IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE := NULL;
862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;

Line 866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;

862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;

Line 867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;

863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;

Line 868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;

864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;

Line 869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;

865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;

Line 870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;

866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;

Line 871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;

867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;
868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;

Line 872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;

868: l_person_id IGS_SS_APP_PGM_STG.person_id%TYPE;
869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;

Line 873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;

869: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;

Line 874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;

870: l_location_cd IGS_SS_APP_PGM_STG.location_cd%TYPE;
871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;

Line 875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;

871: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;

Line 876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;

872: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;

Line 877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;

873: l_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;

Line 878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;

874: l_attribute1 IGS_SS_APP_PGM_STG.ATTRIBUTE1%TYPE;
875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;

Line 879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;

875: l_attribute2 IGS_SS_APP_PGM_STG.ATTRIBUTE2%TYPE;
876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;

Line 880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;

876: l_attribute3 IGS_SS_APP_PGM_STG.ATTRIBUTE3%TYPE;
877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;

Line 881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;

877: l_attribute4 IGS_SS_APP_PGM_STG.ATTRIBUTE4%TYPE;
878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;

Line 882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;

878: l_attribute5 IGS_SS_APP_PGM_STG.ATTRIBUTE5%TYPE;
879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;

Line 883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;

879: l_attribute6 IGS_SS_APP_PGM_STG.ATTRIBUTE6%TYPE;
880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;

Line 884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;

880: l_attribute7 IGS_SS_APP_PGM_STG.ATTRIBUTE7%TYPE;
881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;

Line 885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;

881: l_attribute8 IGS_SS_APP_PGM_STG.ATTRIBUTE8%TYPE;
882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;

Line 886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;

882: l_attribute9 IGS_SS_APP_PGM_STG.ATTRIBUTE9%TYPE;
883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;

Line 887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;

883: l_attribute10 IGS_SS_APP_PGM_STG.ATTRIBUTE10%TYPE;
884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;

Line 888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;

884: l_attribute11 IGS_SS_APP_PGM_STG.ATTRIBUTE11%TYPE;
885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;

Line 889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;

885: l_attribute12 IGS_SS_APP_PGM_STG.ATTRIBUTE12%TYPE;
886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;

Line 890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;

886: l_attribute13 IGS_SS_APP_PGM_STG.ATTRIBUTE13%TYPE;
887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;

Line 891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;

887: l_attribute14 IGS_SS_APP_PGM_STG.ATTRIBUTE14%TYPE;
888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;

Line 892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;

888: l_attribute15 IGS_SS_APP_PGM_STG.ATTRIBUTE15%TYPE;
889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;

Line 893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;

889: l_attribute16 IGS_SS_APP_PGM_STG.ATTRIBUTE16%TYPE;
890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;

Line 894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;

890: l_attribute17 IGS_SS_APP_PGM_STG.ATTRIBUTE17%TYPE;
891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;

Line 895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;

891: l_attribute18 IGS_SS_APP_PGM_STG.ATTRIBUTE18%TYPE;
892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;

Line 896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;

892: l_attribute19 IGS_SS_APP_PGM_STG.ATTRIBUTE19%TYPE;
893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;

Line 897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;

893: l_attribute20 IGS_SS_APP_PGM_STG.ATTRIBUTE20%TYPE;
894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;

Line 898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;

894: l_attribute21 IGS_SS_APP_PGM_STG.ATTRIBUTE21%TYPE;
895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;

Line 899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;

895: l_attribute22 IGS_SS_APP_PGM_STG.ATTRIBUTE22%TYPE;
896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;

Line 900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;

896: l_attribute23 IGS_SS_APP_PGM_STG.ATTRIBUTE23%TYPE;
897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;

Line 901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;

897: l_attribute24 IGS_SS_APP_PGM_STG.ATTRIBUTE24%TYPE;
898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;

Line 902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;

898: l_attribute25 IGS_SS_APP_PGM_STG.ATTRIBUTE25%TYPE;
899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;

Line 903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;

899: l_attribute26 IGS_SS_APP_PGM_STG.ATTRIBUTE26%TYPE;
900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;

Line 904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;

900: l_attribute27 IGS_SS_APP_PGM_STG.ATTRIBUTE27%TYPE;
901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;

Line 905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;

901: l_attribute28 IGS_SS_APP_PGM_STG.ATTRIBUTE28%TYPE;
902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;

Line 906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;

902: l_attribute29 IGS_SS_APP_PGM_STG.ATTRIBUTE29%TYPE;
903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;

Line 907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;

903: l_attribute30 IGS_SS_APP_PGM_STG.ATTRIBUTE30%TYPE;
904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;

Line 908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;

904: l_attribute31 IGS_SS_APP_PGM_STG.ATTRIBUTE31%TYPE;
905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;

Line 909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;

905: l_attribute32 IGS_SS_APP_PGM_STG.ATTRIBUTE32%TYPE;
906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;

Line 910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;

906: l_attribute33 IGS_SS_APP_PGM_STG.ATTRIBUTE33%TYPE;
907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;
914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;

Line 911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;

907: l_attribute34 IGS_SS_APP_PGM_STG.ATTRIBUTE34%TYPE;
908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;
914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;
915:

Line 912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;

908: l_attribute35 IGS_SS_APP_PGM_STG.ATTRIBUTE35%TYPE;
909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;
914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;
915:
916: BEGIN

Line 913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;

909: l_attribute36 IGS_SS_APP_PGM_STG.ATTRIBUTE36%TYPE;
910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;
914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;
915:
916: BEGIN
917: SAVEPOINT PRE_CREATE_APPL_INST_pub;

Line 914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;

910: l_attribute37 IGS_SS_APP_PGM_STG.ATTRIBUTE37%TYPE;
911: l_attribute38 IGS_SS_APP_PGM_STG.ATTRIBUTE38%TYPE;
912: l_attribute39 IGS_SS_APP_PGM_STG.ATTRIBUTE39%TYPE;
913: l_attribute40 IGS_SS_APP_PGM_STG.ATTRIBUTE40%TYPE;
914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;
915:
916: BEGIN
917: SAVEPOINT PRE_CREATE_APPL_INST_pub;
918: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 936: check_length('PERSON_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_ss_adm_appl_id)));

932: -----------------------
933: -- Validate all the parameters for their length
934: -----------------------
935: --p_ss_adm_appl_id
936: check_length('PERSON_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_ss_adm_appl_id)));
937:
938: --p_sch_apl_to_id
939: check_length('SCH_APL_TO_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_sch_apl_to_id)));
940:

Line 939: check_length('SCH_APL_TO_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_sch_apl_to_id)));

935: --p_ss_adm_appl_id
936: check_length('PERSON_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_ss_adm_appl_id)));
937:
938: --p_sch_apl_to_id
939: check_length('SCH_APL_TO_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_sch_apl_to_id)));
940:
941: --p_location_cd
942: check_length('LOCATION_CD', 'IGS_SS_APP_PGM_STG', length(p_location_cd));
943:

Line 942: check_length('LOCATION_CD', 'IGS_SS_APP_PGM_STG', length(p_location_cd));

938: --p_sch_apl_to_id
939: check_length('SCH_APL_TO_ID', 'IGS_SS_APP_PGM_STG', length(TRUNC(p_sch_apl_to_id)));
940:
941: --p_location_cd
942: check_length('LOCATION_CD', 'IGS_SS_APP_PGM_STG', length(p_location_cd));
943:
944: --p_attendance_type
945: check_length('ATTENDANCE_TYPE', 'IGS_SS_APP_PGM_STG', length(p_attendance_type));
946:

Line 945: check_length('ATTENDANCE_TYPE', 'IGS_SS_APP_PGM_STG', length(p_attendance_type));

941: --p_location_cd
942: check_length('LOCATION_CD', 'IGS_SS_APP_PGM_STG', length(p_location_cd));
943:
944: --p_attendance_type
945: check_length('ATTENDANCE_TYPE', 'IGS_SS_APP_PGM_STG', length(p_attendance_type));
946:
947: --p_attendance_mode
948: check_length('ATTENDANCE_MODE', 'IGS_SS_APP_PGM_STG', length(p_attendance_mode));
949:

Line 948: check_length('ATTENDANCE_MODE', 'IGS_SS_APP_PGM_STG', length(p_attendance_mode));

944: --p_attendance_type
945: check_length('ATTENDANCE_TYPE', 'IGS_SS_APP_PGM_STG', length(p_attendance_type));
946:
947: --p_attendance_mode
948: check_length('ATTENDANCE_MODE', 'IGS_SS_APP_PGM_STG', length(p_attendance_mode));
949:
950: --p_attribute_category
951: check_length('ATTRIBUTE_CATEGORY', 'IGS_SS_APP_PGM_STG', length(p_attribute_category));
952:

Line 951: check_length('ATTRIBUTE_CATEGORY', 'IGS_SS_APP_PGM_STG', length(p_attribute_category));

947: --p_attendance_mode
948: check_length('ATTENDANCE_MODE', 'IGS_SS_APP_PGM_STG', length(p_attendance_mode));
949:
950: --p_attribute_category
951: check_length('ATTRIBUTE_CATEGORY', 'IGS_SS_APP_PGM_STG', length(p_attribute_category));
952:
953: --p_attribute1
954: check_length('ATTRIBUTE1', 'IGS_SS_APP_PGM_STG', length(p_attribute1));
955:

Line 954: check_length('ATTRIBUTE1', 'IGS_SS_APP_PGM_STG', length(p_attribute1));

950: --p_attribute_category
951: check_length('ATTRIBUTE_CATEGORY', 'IGS_SS_APP_PGM_STG', length(p_attribute_category));
952:
953: --p_attribute1
954: check_length('ATTRIBUTE1', 'IGS_SS_APP_PGM_STG', length(p_attribute1));
955:
956: --p_attribute2
957: check_length('ATTRIBUTE2', 'IGS_SS_APP_PGM_STG', length(p_attribute2));
958:

Line 957: check_length('ATTRIBUTE2', 'IGS_SS_APP_PGM_STG', length(p_attribute2));

953: --p_attribute1
954: check_length('ATTRIBUTE1', 'IGS_SS_APP_PGM_STG', length(p_attribute1));
955:
956: --p_attribute2
957: check_length('ATTRIBUTE2', 'IGS_SS_APP_PGM_STG', length(p_attribute2));
958:
959: --p_attribute3
960: check_length('ATTRIBUTE3', 'IGS_SS_APP_PGM_STG', length(p_attribute3));
961:

Line 960: check_length('ATTRIBUTE3', 'IGS_SS_APP_PGM_STG', length(p_attribute3));

956: --p_attribute2
957: check_length('ATTRIBUTE2', 'IGS_SS_APP_PGM_STG', length(p_attribute2));
958:
959: --p_attribute3
960: check_length('ATTRIBUTE3', 'IGS_SS_APP_PGM_STG', length(p_attribute3));
961:
962: --p_attribute4
963: check_length('ATTRIBUTE4', 'IGS_SS_APP_PGM_STG', length(p_attribute4));
964:

Line 963: check_length('ATTRIBUTE4', 'IGS_SS_APP_PGM_STG', length(p_attribute4));

959: --p_attribute3
960: check_length('ATTRIBUTE3', 'IGS_SS_APP_PGM_STG', length(p_attribute3));
961:
962: --p_attribute4
963: check_length('ATTRIBUTE4', 'IGS_SS_APP_PGM_STG', length(p_attribute4));
964:
965: --p_attribute5
966: check_length('ATTRIBUTE5', 'IGS_SS_APP_PGM_STG', length(p_attribute5));
967:

Line 966: check_length('ATTRIBUTE5', 'IGS_SS_APP_PGM_STG', length(p_attribute5));

962: --p_attribute4
963: check_length('ATTRIBUTE4', 'IGS_SS_APP_PGM_STG', length(p_attribute4));
964:
965: --p_attribute5
966: check_length('ATTRIBUTE5', 'IGS_SS_APP_PGM_STG', length(p_attribute5));
967:
968: --p_attribute6
969: check_length('ATTRIBUTE6', 'IGS_SS_APP_PGM_STG', length(p_attribute6));
970:

Line 969: check_length('ATTRIBUTE6', 'IGS_SS_APP_PGM_STG', length(p_attribute6));

965: --p_attribute5
966: check_length('ATTRIBUTE5', 'IGS_SS_APP_PGM_STG', length(p_attribute5));
967:
968: --p_attribute6
969: check_length('ATTRIBUTE6', 'IGS_SS_APP_PGM_STG', length(p_attribute6));
970:
971: --p_attribute7
972: check_length('ATTRIBUTE7', 'IGS_SS_APP_PGM_STG', length(p_attribute7));
973:

Line 972: check_length('ATTRIBUTE7', 'IGS_SS_APP_PGM_STG', length(p_attribute7));

968: --p_attribute6
969: check_length('ATTRIBUTE6', 'IGS_SS_APP_PGM_STG', length(p_attribute6));
970:
971: --p_attribute7
972: check_length('ATTRIBUTE7', 'IGS_SS_APP_PGM_STG', length(p_attribute7));
973:
974: --p_attribute8
975: check_length('ATTRIBUTE8', 'IGS_SS_APP_PGM_STG', length(p_attribute8));
976:

Line 975: check_length('ATTRIBUTE8', 'IGS_SS_APP_PGM_STG', length(p_attribute8));

971: --p_attribute7
972: check_length('ATTRIBUTE7', 'IGS_SS_APP_PGM_STG', length(p_attribute7));
973:
974: --p_attribute8
975: check_length('ATTRIBUTE8', 'IGS_SS_APP_PGM_STG', length(p_attribute8));
976:
977: --p_attribute9
978: check_length('ATTRIBUTE9', 'IGS_SS_APP_PGM_STG', length(p_attribute9));
979:

Line 978: check_length('ATTRIBUTE9', 'IGS_SS_APP_PGM_STG', length(p_attribute9));

974: --p_attribute8
975: check_length('ATTRIBUTE8', 'IGS_SS_APP_PGM_STG', length(p_attribute8));
976:
977: --p_attribute9
978: check_length('ATTRIBUTE9', 'IGS_SS_APP_PGM_STG', length(p_attribute9));
979:
980: --p_attribute10
981: check_length('ATTRIBUTE10', 'IGS_SS_APP_PGM_STG', length(p_attribute10));
982:

Line 981: check_length('ATTRIBUTE10', 'IGS_SS_APP_PGM_STG', length(p_attribute10));

977: --p_attribute9
978: check_length('ATTRIBUTE9', 'IGS_SS_APP_PGM_STG', length(p_attribute9));
979:
980: --p_attribute10
981: check_length('ATTRIBUTE10', 'IGS_SS_APP_PGM_STG', length(p_attribute10));
982:
983: --p_attribute11
984: check_length('ATTRIBUTE11', 'IGS_SS_APP_PGM_STG', length(p_attribute11));
985:

Line 984: check_length('ATTRIBUTE11', 'IGS_SS_APP_PGM_STG', length(p_attribute11));

980: --p_attribute10
981: check_length('ATTRIBUTE10', 'IGS_SS_APP_PGM_STG', length(p_attribute10));
982:
983: --p_attribute11
984: check_length('ATTRIBUTE11', 'IGS_SS_APP_PGM_STG', length(p_attribute11));
985:
986: --p_attribute12
987: check_length('ATTRIBUTE12', 'IGS_SS_APP_PGM_STG', length(p_attribute12));
988:

Line 987: check_length('ATTRIBUTE12', 'IGS_SS_APP_PGM_STG', length(p_attribute12));

983: --p_attribute11
984: check_length('ATTRIBUTE11', 'IGS_SS_APP_PGM_STG', length(p_attribute11));
985:
986: --p_attribute12
987: check_length('ATTRIBUTE12', 'IGS_SS_APP_PGM_STG', length(p_attribute12));
988:
989: --p_attribute13
990: check_length('ATTRIBUTE13', 'IGS_SS_APP_PGM_STG', length(p_attribute13));
991:

Line 990: check_length('ATTRIBUTE13', 'IGS_SS_APP_PGM_STG', length(p_attribute13));

986: --p_attribute12
987: check_length('ATTRIBUTE12', 'IGS_SS_APP_PGM_STG', length(p_attribute12));
988:
989: --p_attribute13
990: check_length('ATTRIBUTE13', 'IGS_SS_APP_PGM_STG', length(p_attribute13));
991:
992: --p_attribute14
993: check_length('ATTRIBUTE14', 'IGS_SS_APP_PGM_STG', length(p_attribute14));
994:

Line 993: check_length('ATTRIBUTE14', 'IGS_SS_APP_PGM_STG', length(p_attribute14));

989: --p_attribute13
990: check_length('ATTRIBUTE13', 'IGS_SS_APP_PGM_STG', length(p_attribute13));
991:
992: --p_attribute14
993: check_length('ATTRIBUTE14', 'IGS_SS_APP_PGM_STG', length(p_attribute14));
994:
995: --p_attribute15
996: check_length('ATTRIBUTE15', 'IGS_SS_APP_PGM_STG', length(p_attribute15));
997:

Line 996: check_length('ATTRIBUTE15', 'IGS_SS_APP_PGM_STG', length(p_attribute15));

992: --p_attribute14
993: check_length('ATTRIBUTE14', 'IGS_SS_APP_PGM_STG', length(p_attribute14));
994:
995: --p_attribute15
996: check_length('ATTRIBUTE15', 'IGS_SS_APP_PGM_STG', length(p_attribute15));
997:
998: --p_attribute16
999: check_length('ATTRIBUTE16', 'IGS_SS_APP_PGM_STG', length(p_attribute16));
1000:

Line 999: check_length('ATTRIBUTE16', 'IGS_SS_APP_PGM_STG', length(p_attribute16));

995: --p_attribute15
996: check_length('ATTRIBUTE15', 'IGS_SS_APP_PGM_STG', length(p_attribute15));
997:
998: --p_attribute16
999: check_length('ATTRIBUTE16', 'IGS_SS_APP_PGM_STG', length(p_attribute16));
1000:
1001: --p_attribute17
1002: check_length('ATTRIBUTE17', 'IGS_SS_APP_PGM_STG', length(p_attribute17));
1003:

Line 1002: check_length('ATTRIBUTE17', 'IGS_SS_APP_PGM_STG', length(p_attribute17));

998: --p_attribute16
999: check_length('ATTRIBUTE16', 'IGS_SS_APP_PGM_STG', length(p_attribute16));
1000:
1001: --p_attribute17
1002: check_length('ATTRIBUTE17', 'IGS_SS_APP_PGM_STG', length(p_attribute17));
1003:
1004: --p_attribute18
1005: check_length('ATTRIBUTE18', 'IGS_SS_APP_PGM_STG', length(p_attribute18));
1006:

Line 1005: check_length('ATTRIBUTE18', 'IGS_SS_APP_PGM_STG', length(p_attribute18));

1001: --p_attribute17
1002: check_length('ATTRIBUTE17', 'IGS_SS_APP_PGM_STG', length(p_attribute17));
1003:
1004: --p_attribute18
1005: check_length('ATTRIBUTE18', 'IGS_SS_APP_PGM_STG', length(p_attribute18));
1006:
1007: --p_attribute19
1008: check_length('ATTRIBUTE19', 'IGS_SS_APP_PGM_STG', length(p_attribute19));
1009:

Line 1008: check_length('ATTRIBUTE19', 'IGS_SS_APP_PGM_STG', length(p_attribute19));

1004: --p_attribute18
1005: check_length('ATTRIBUTE18', 'IGS_SS_APP_PGM_STG', length(p_attribute18));
1006:
1007: --p_attribute19
1008: check_length('ATTRIBUTE19', 'IGS_SS_APP_PGM_STG', length(p_attribute19));
1009:
1010: --p_attribute20
1011: check_length('ATTRIBUTE20', 'IGS_SS_APP_PGM_STG', length(p_attribute20));
1012:

Line 1011: check_length('ATTRIBUTE20', 'IGS_SS_APP_PGM_STG', length(p_attribute20));

1007: --p_attribute19
1008: check_length('ATTRIBUTE19', 'IGS_SS_APP_PGM_STG', length(p_attribute19));
1009:
1010: --p_attribute20
1011: check_length('ATTRIBUTE20', 'IGS_SS_APP_PGM_STG', length(p_attribute20));
1012:
1013: --p_attribute21
1014: check_length('ATTRIBUTE21', 'IGS_SS_APP_PGM_STG', length(p_attribute21));
1015:

Line 1014: check_length('ATTRIBUTE21', 'IGS_SS_APP_PGM_STG', length(p_attribute21));

1010: --p_attribute20
1011: check_length('ATTRIBUTE20', 'IGS_SS_APP_PGM_STG', length(p_attribute20));
1012:
1013: --p_attribute21
1014: check_length('ATTRIBUTE21', 'IGS_SS_APP_PGM_STG', length(p_attribute21));
1015:
1016: --p_attribute22
1017: check_length('ATTRIBUTE22', 'IGS_SS_APP_PGM_STG', length(p_attribute22));
1018:

Line 1017: check_length('ATTRIBUTE22', 'IGS_SS_APP_PGM_STG', length(p_attribute22));

1013: --p_attribute21
1014: check_length('ATTRIBUTE21', 'IGS_SS_APP_PGM_STG', length(p_attribute21));
1015:
1016: --p_attribute22
1017: check_length('ATTRIBUTE22', 'IGS_SS_APP_PGM_STG', length(p_attribute22));
1018:
1019: --p_attribute23
1020: check_length('ATTRIBUTE23', 'IGS_SS_APP_PGM_STG', length(p_attribute23));
1021:

Line 1020: check_length('ATTRIBUTE23', 'IGS_SS_APP_PGM_STG', length(p_attribute23));

1016: --p_attribute22
1017: check_length('ATTRIBUTE22', 'IGS_SS_APP_PGM_STG', length(p_attribute22));
1018:
1019: --p_attribute23
1020: check_length('ATTRIBUTE23', 'IGS_SS_APP_PGM_STG', length(p_attribute23));
1021:
1022: --p_attribute24
1023: check_length('ATTRIBUTE24', 'IGS_SS_APP_PGM_STG', length(p_attribute24));
1024:

Line 1023: check_length('ATTRIBUTE24', 'IGS_SS_APP_PGM_STG', length(p_attribute24));

1019: --p_attribute23
1020: check_length('ATTRIBUTE23', 'IGS_SS_APP_PGM_STG', length(p_attribute23));
1021:
1022: --p_attribute24
1023: check_length('ATTRIBUTE24', 'IGS_SS_APP_PGM_STG', length(p_attribute24));
1024:
1025: --p_attribute25
1026: check_length('ATTRIBUTE25', 'IGS_SS_APP_PGM_STG', length(p_attribute25));
1027:

Line 1026: check_length('ATTRIBUTE25', 'IGS_SS_APP_PGM_STG', length(p_attribute25));

1022: --p_attribute24
1023: check_length('ATTRIBUTE24', 'IGS_SS_APP_PGM_STG', length(p_attribute24));
1024:
1025: --p_attribute25
1026: check_length('ATTRIBUTE25', 'IGS_SS_APP_PGM_STG', length(p_attribute25));
1027:
1028: --p_attribute26
1029: check_length('ATTRIBUTE26', 'IGS_SS_APP_PGM_STG', length(p_attribute26));
1030:

Line 1029: check_length('ATTRIBUTE26', 'IGS_SS_APP_PGM_STG', length(p_attribute26));

1025: --p_attribute25
1026: check_length('ATTRIBUTE25', 'IGS_SS_APP_PGM_STG', length(p_attribute25));
1027:
1028: --p_attribute26
1029: check_length('ATTRIBUTE26', 'IGS_SS_APP_PGM_STG', length(p_attribute26));
1030:
1031: --p_attribute27
1032: check_length('ATTRIBUTE27', 'IGS_SS_APP_PGM_STG', length(p_attribute27));
1033:

Line 1032: check_length('ATTRIBUTE27', 'IGS_SS_APP_PGM_STG', length(p_attribute27));

1028: --p_attribute26
1029: check_length('ATTRIBUTE26', 'IGS_SS_APP_PGM_STG', length(p_attribute26));
1030:
1031: --p_attribute27
1032: check_length('ATTRIBUTE27', 'IGS_SS_APP_PGM_STG', length(p_attribute27));
1033:
1034: --p_attribute28
1035: check_length('ATTRIBUTE28', 'IGS_SS_APP_PGM_STG', length(p_attribute28));
1036:

Line 1035: check_length('ATTRIBUTE28', 'IGS_SS_APP_PGM_STG', length(p_attribute28));

1031: --p_attribute27
1032: check_length('ATTRIBUTE27', 'IGS_SS_APP_PGM_STG', length(p_attribute27));
1033:
1034: --p_attribute28
1035: check_length('ATTRIBUTE28', 'IGS_SS_APP_PGM_STG', length(p_attribute28));
1036:
1037: --p_attribute29
1038: check_length('ATTRIBUTE29', 'IGS_SS_APP_PGM_STG', length(p_attribute29));
1039:

Line 1038: check_length('ATTRIBUTE29', 'IGS_SS_APP_PGM_STG', length(p_attribute29));

1034: --p_attribute28
1035: check_length('ATTRIBUTE28', 'IGS_SS_APP_PGM_STG', length(p_attribute28));
1036:
1037: --p_attribute29
1038: check_length('ATTRIBUTE29', 'IGS_SS_APP_PGM_STG', length(p_attribute29));
1039:
1040: --p_attribute30
1041: check_length('ATTRIBUTE30', 'IGS_SS_APP_PGM_STG', length(p_attribute30));
1042:

Line 1041: check_length('ATTRIBUTE30', 'IGS_SS_APP_PGM_STG', length(p_attribute30));

1037: --p_attribute29
1038: check_length('ATTRIBUTE29', 'IGS_SS_APP_PGM_STG', length(p_attribute29));
1039:
1040: --p_attribute30
1041: check_length('ATTRIBUTE30', 'IGS_SS_APP_PGM_STG', length(p_attribute30));
1042:
1043: --p_attribute31
1044: check_length('ATTRIBUTE31', 'IGS_SS_APP_PGM_STG', length(p_attribute31));
1045:

Line 1044: check_length('ATTRIBUTE31', 'IGS_SS_APP_PGM_STG', length(p_attribute31));

1040: --p_attribute30
1041: check_length('ATTRIBUTE30', 'IGS_SS_APP_PGM_STG', length(p_attribute30));
1042:
1043: --p_attribute31
1044: check_length('ATTRIBUTE31', 'IGS_SS_APP_PGM_STG', length(p_attribute31));
1045:
1046: --p_attribute32
1047: check_length('ATTRIBUTE32', 'IGS_SS_APP_PGM_STG', length(p_attribute32));
1048:

Line 1047: check_length('ATTRIBUTE32', 'IGS_SS_APP_PGM_STG', length(p_attribute32));

1043: --p_attribute31
1044: check_length('ATTRIBUTE31', 'IGS_SS_APP_PGM_STG', length(p_attribute31));
1045:
1046: --p_attribute32
1047: check_length('ATTRIBUTE32', 'IGS_SS_APP_PGM_STG', length(p_attribute32));
1048:
1049: --p_attribute33
1050: check_length('ATTRIBUTE33', 'IGS_SS_APP_PGM_STG', length(p_attribute33));
1051:

Line 1050: check_length('ATTRIBUTE33', 'IGS_SS_APP_PGM_STG', length(p_attribute33));

1046: --p_attribute32
1047: check_length('ATTRIBUTE32', 'IGS_SS_APP_PGM_STG', length(p_attribute32));
1048:
1049: --p_attribute33
1050: check_length('ATTRIBUTE33', 'IGS_SS_APP_PGM_STG', length(p_attribute33));
1051:
1052: --p_attribute34
1053: check_length('ATTRIBUTE34', 'IGS_SS_APP_PGM_STG', length(p_attribute34));
1054:

Line 1053: check_length('ATTRIBUTE34', 'IGS_SS_APP_PGM_STG', length(p_attribute34));

1049: --p_attribute33
1050: check_length('ATTRIBUTE33', 'IGS_SS_APP_PGM_STG', length(p_attribute33));
1051:
1052: --p_attribute34
1053: check_length('ATTRIBUTE34', 'IGS_SS_APP_PGM_STG', length(p_attribute34));
1054:
1055: --p_attribute35
1056: check_length('ATTRIBUTE35', 'IGS_SS_APP_PGM_STG', length(p_attribute35));
1057:

Line 1056: check_length('ATTRIBUTE35', 'IGS_SS_APP_PGM_STG', length(p_attribute35));

1052: --p_attribute34
1053: check_length('ATTRIBUTE34', 'IGS_SS_APP_PGM_STG', length(p_attribute34));
1054:
1055: --p_attribute35
1056: check_length('ATTRIBUTE35', 'IGS_SS_APP_PGM_STG', length(p_attribute35));
1057:
1058: --p_attribute36
1059: check_length('ATTRIBUTE36', 'IGS_SS_APP_PGM_STG', length(p_attribute36));
1060:

Line 1059: check_length('ATTRIBUTE36', 'IGS_SS_APP_PGM_STG', length(p_attribute36));

1055: --p_attribute35
1056: check_length('ATTRIBUTE35', 'IGS_SS_APP_PGM_STG', length(p_attribute35));
1057:
1058: --p_attribute36
1059: check_length('ATTRIBUTE36', 'IGS_SS_APP_PGM_STG', length(p_attribute36));
1060:
1061: --p_attribute37
1062: check_length('ATTRIBUTE37', 'IGS_SS_APP_PGM_STG', length(p_attribute37));
1063:

Line 1062: check_length('ATTRIBUTE37', 'IGS_SS_APP_PGM_STG', length(p_attribute37));

1058: --p_attribute36
1059: check_length('ATTRIBUTE36', 'IGS_SS_APP_PGM_STG', length(p_attribute36));
1060:
1061: --p_attribute37
1062: check_length('ATTRIBUTE37', 'IGS_SS_APP_PGM_STG', length(p_attribute37));
1063:
1064: --p_attribute38
1065: check_length('ATTRIBUTE38', 'IGS_SS_APP_PGM_STG', length(p_attribute38));
1066:

Line 1065: check_length('ATTRIBUTE38', 'IGS_SS_APP_PGM_STG', length(p_attribute38));

1061: --p_attribute37
1062: check_length('ATTRIBUTE37', 'IGS_SS_APP_PGM_STG', length(p_attribute37));
1063:
1064: --p_attribute38
1065: check_length('ATTRIBUTE38', 'IGS_SS_APP_PGM_STG', length(p_attribute38));
1066:
1067: --p_attribute39
1068: check_length('ATTRIBUTE39', 'IGS_SS_APP_PGM_STG', length(p_attribute39));
1069:

Line 1068: check_length('ATTRIBUTE39', 'IGS_SS_APP_PGM_STG', length(p_attribute39));

1064: --p_attribute38
1065: check_length('ATTRIBUTE38', 'IGS_SS_APP_PGM_STG', length(p_attribute38));
1066:
1067: --p_attribute39
1068: check_length('ATTRIBUTE39', 'IGS_SS_APP_PGM_STG', length(p_attribute39));
1069:
1070: --p_attribute40
1071: check_length('ATTRIBUTE40', 'IGS_SS_APP_PGM_STG', length(p_attribute40));
1072:

Line 1071: check_length('ATTRIBUTE40', 'IGS_SS_APP_PGM_STG', length(p_attribute40));

1067: --p_attribute39
1068: check_length('ATTRIBUTE39', 'IGS_SS_APP_PGM_STG', length(p_attribute39));
1069:
1070: --p_attribute40
1071: check_length('ATTRIBUTE40', 'IGS_SS_APP_PGM_STG', length(p_attribute40));
1072:
1073: ---------------------
1074: --Intialization of variables to handle G_MISS_CHAR/NUM/DATE
1075: ---------------------

Line 1577: INSERT INTO IGS_SS_APP_PGM_STG (SS_ADMAPPL_PGM_ID,

1573: ---------------------
1574: -- Insert the Application Instance Record.
1575: ---------------------
1576:
1577: INSERT INTO IGS_SS_APP_PGM_STG (SS_ADMAPPL_PGM_ID,
1578: SS_ADM_APPL_ID,
1579: PERSON_ID,
1580: PREFERENCE_NUMBER,
1581: SCH_APL_TO_ID,