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_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_ADMDE_INT_ALL

Line 249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,

245: cur_dp_app_choice_rec cur_dp_app_choice%ROWTYPE ;
246:
247: -- Cursor to check for the errorin the import decision process
248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,
250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS
253: SELECT error_code, status

Line 250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,

246:
247: -- Cursor to check for the errorin the import decision process
248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,
250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS
253: SELECT error_code, status
254: FROM igs_ad_admde_int_all

Line 251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,

247: -- Cursor to check for the errorin the import decision process
248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,
250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS
253: SELECT error_code, status
254: FROM igs_ad_admde_int_all
255: WHERE batch_id = p_batch_id

Line 252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS

248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,
250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS
253: SELECT error_code, status
254: FROM igs_ad_admde_int_all
255: WHERE batch_id = p_batch_id
256: AND person_id = p_person_id

Line 254: FROM igs_ad_admde_int_all

250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS
253: SELECT error_code, status
254: FROM igs_ad_admde_int_all
255: WHERE batch_id = p_batch_id
256: AND person_id = p_person_id
257: AND admission_appl_number = p_admission_appl_number
258: AND nominated_course_cd = p_nominated_course_cd

Line 264: CURSOR cur_admde_interface ( p_interface_mkdes_id IGS_AD_ADMDE_INT_ALL.interface_mkdes_id%TYPE ) IS

260: AND ( status IN ('3','2') OR error_code IS NOT NULL ) ;
261: cur_dec_import_error_rec cur_dec_import_error%ROWTYPE ;
262:
263: -- Cursor to fetch the record Admission Decision import Interface table
264: CURSOR cur_admde_interface ( p_interface_mkdes_id IGS_AD_ADMDE_INT_ALL.interface_mkdes_id%TYPE ) IS
265: SELECT *
266: FROM igs_ad_admde_int_all
267: WHERE interface_mkdes_id = p_interface_mkdes_id ;
268: cur_admde_interface_rec cur_admde_interface%ROWTYPE;

Line 266: FROM igs_ad_admde_int_all

262:
263: -- Cursor to fetch the record Admission Decision import Interface table
264: CURSOR cur_admde_interface ( p_interface_mkdes_id IGS_AD_ADMDE_INT_ALL.interface_mkdes_id%TYPE ) IS
265: SELECT *
266: FROM igs_ad_admde_int_all
267: WHERE interface_mkdes_id = p_interface_mkdes_id ;
268: cur_admde_interface_rec cur_admde_interface%ROWTYPE;
269:
270: --Cursor to fetch the record from Admission Decision import Interface batch table

Line 342: l_interface_mkdes_id igs_ad_admde_int_all.interface_mkdes_id%TYPE ;

338: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
339: l_app_choice_error_code igs_uc_app_choices.error_code%TYPE ;
340:
341: l_rowid VARCHAR2(25);
342: l_interface_mkdes_id igs_ad_admde_int_all.interface_mkdes_id%TYPE ;
343: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE ;
344: l_return_status VARCHAR2(10) ;
345: l_error_message fnd_new_messages.message_text%TYPE ;
346: l_description VARCHAR2(2000);

Line 343: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE ;

339: l_app_choice_error_code igs_uc_app_choices.error_code%TYPE ;
340:
341: l_rowid VARCHAR2(25);
342: l_interface_mkdes_id igs_ad_admde_int_all.interface_mkdes_id%TYPE ;
343: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE ;
344: l_return_status VARCHAR2(10) ;
345: l_error_message fnd_new_messages.message_text%TYPE ;
346: l_description VARCHAR2(2000);
347:

Line 678: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL as,

674:
675: /* Populate the Admission Decision Import Interface tables with the default OSS user outcome status
676: corresponding to UCAS latest decision setting Transaction Decision */
677:
678: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL as,
679:
680: /*Populate the Admission Decision Import Interface tables with default OSS user outcome status
681: mapped to the UCAS Transaction Decision.
682:

Line 701: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.

697: FETCH cur_interface_ctl_s INTO l_interface_run_id;
698: CLOSE cur_interface_ctl_s;
699:
700: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
701: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
702: l_reconsideration_flag := NULL;
703: IF igs_ad_gen_008.admp_get_saos(cur_ou_mapping_rec.adm_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
704: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
705: l_reconsideration_flag := 'Y';

Line 808: --1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

804:
805: /* Populate the Admission Decision Import Interface tables with the default OSS user outcome status
806: with system outcome status type of 'REJECTED' from the UCAS setup */
807:
808: --1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
809:
810: /* Get the Interface Run ID value from Sequence */
811: OPEN cur_interface_ctl_s ;
812: FETCH cur_interface_ctl_s INTO l_interface_run_id;

Line 816: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.

812: FETCH cur_interface_ctl_s INTO l_interface_run_id;
813: CLOSE cur_interface_ctl_s;
814:
815: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
816: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
817: l_reconsideration_flag := NULL;
818: IF igs_ad_gen_008.admp_get_saos(cur_ucas_setup_rec.rejected_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
819: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
820: l_reconsideration_flag := 'Y';

Line 826: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

822: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
823: l_reconsideration_flag := 'N';
824: END IF;
825:
826: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
827: igs_ad_admde_int_pkg.insert_row (
828: x_rowid => l_rowid,
829: x_interface_mkdes_id => l_interface_mkdes_id,
830: x_interface_run_id => l_interface_run_id,

Line 884: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

880:
881: /* Populate the Admission Decision Import Interface tables with the default OSS user outcome status
882: with system outcome status type of 'PENDING' */
883:
884: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
885:
886: /* Get the Pending Reason ID */
887: OPEN cur_pending_reason;
888: FETCH cur_pending_reason INTO cur_pending_reason_rec;

Line 897: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.

893: FETCH cur_interface_ctl_s INTO l_interface_run_id ;
894: CLOSE cur_interface_ctl_s ;
895:
896: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
897: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
898: l_reconsideration_flag := NULL;
899: IF igs_ad_gen_008.admp_get_saos(cur_ucas_setup_rec.pending_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
900: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
901: l_reconsideration_flag := 'Y';

Line 907: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

903: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
904: l_reconsideration_flag := 'N';
905: END IF;
906:
907: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
908: igs_ad_admde_int_pkg.insert_row (
909: x_rowid => l_rowid,
910: x_interface_mkdes_id => l_interface_mkdes_id,
911: x_interface_run_id => l_interface_run_id,

Line 980: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

976: IF l_oss_ou_status_of_app_choice IS NOT NULL THEN
977: /* Populate the Admission Decision Import Interface tables with the default OSS user outcome status
978: corresponding to Application Choice Decision */
979:
980: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
981: /* Get the Interface Run ID value from Sequence */
982: OPEN cur_interface_ctl_s ;
983: FETCH cur_interface_ctl_s INTO l_interface_run_id;
984: CLOSE cur_interface_ctl_s;

Line 987: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.

983: FETCH cur_interface_ctl_s INTO l_interface_run_id;
984: CLOSE cur_interface_ctl_s;
985:
986: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
987: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
988: l_reconsideration_flag := NULL;
989: IF igs_ad_gen_008.admp_get_saos(l_oss_ou_status_of_app_choice) IN ('REJECTED','NO-QUOTA') THEN
990: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
991: l_reconsideration_flag := 'Y';

Line 997: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

993: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
994: l_reconsideration_flag := 'N';
995: END IF;
996:
997: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
998: igs_ad_admde_int_pkg.insert_row (
999: x_rowid => l_rowid,
1000: x_interface_mkdes_id => l_interface_mkdes_id,
1001: x_interface_run_id => l_interface_run_id,

Line 1046: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

1042: -- If the mapping of Transaction Decision to Default OSS User Outcome Status is defined
1043: IF cur_ou_mapping%FOUND THEN
1044: /* Populate the Admission Decision Import Interface tables with the default OSS user outcome status
1045: corresponding to UCAS Transaction Decision */
1046: -- 1. Insert a record into Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
1047:
1048: /* Get the Interface Run ID value from Sequence */
1049: OPEN cur_interface_ctl_s ;
1050: FETCH cur_interface_ctl_s INTO l_interface_run_id;

Line 1054: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.

1050: FETCH cur_interface_ctl_s INTO l_interface_run_id;
1051: CLOSE cur_interface_ctl_s;
1052:
1053: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
1054: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
1055: l_reconsideration_flag := NULL;
1056: IF igs_ad_gen_008.admp_get_saos(cur_ou_mapping_rec.adm_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
1057: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
1058: l_reconsideration_flag := 'Y';

Line 1064: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

1060: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
1061: l_reconsideration_flag := 'N';
1062: END IF;
1063:
1064: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
1065: igs_ad_admde_int_pkg.insert_row (
1066: x_rowid => l_rowid,
1067: x_interface_mkdes_id => l_interface_mkdes_id,
1068: x_interface_run_id => l_interface_run_id,