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_EXPUNGE_APP dependencies on IGS_UC_APP_CHOICES

Line 216: cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

212: AND ucap.app_no = cp_app_no;
213:
214: --To identify the OSS Admission Application instances, which are created FOR UCAS Application number to be expunged
215: CURSOR cur_oss_ad_appl_inst (cp_app_no igs_uc_wrong_app.app_no%TYPE,
216: cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
217: SELECT aap.person_id,
218: aap.admission_appl_number,
219: aap.alt_appl_id,
220: aap.choice_number,

Line 267: CURSOR cur_ucapcc (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

263: AND ucap.app_no = cp_app_no
264: AND api.person_id_type= DECODE(ucap.system_code, 'U', 'UCASID', 'G', 'GTTRID', 'S', 'SWASID', 'N', 'NMASID')
265: AND (api.end_dt IS NULL OR (api.end_dt > SYSDATE AND api.end_dt <> api.start_dt));
266:
267: CURSOR cur_ucapcc (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
268: SELECT ROWID
269: FROM igs_uc_app_cho_cnds
270: WHERE app_no = cp_app_no
271: AND choice_no = cp_choice_no;

Line 273: CURSOR cur_ucapch (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

269: FROM igs_uc_app_cho_cnds
270: WHERE app_no = cp_app_no
271: AND choice_no = cp_choice_no;
272:
273: CURSOR cur_ucapch (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
274: SELECT ROWID, choice_no
275: FROM igs_uc_app_choices
276: WHERE app_no = cp_app_no
277: AND choice_no = NVL(cp_choice_no, choice_no);

Line 275: FROM igs_uc_app_choices

271: AND choice_no = cp_choice_no;
272:
273: CURSOR cur_ucapch (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
274: SELECT ROWID, choice_no
275: FROM igs_uc_app_choices
276: WHERE app_no = cp_app_no
277: AND choice_no = NVL(cp_choice_no, choice_no);
278:
279: CURSOR cur_uctr (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

Line 279: CURSOR cur_uctr (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

275: FROM igs_uc_app_choices
276: WHERE app_no = cp_app_no
277: AND choice_no = NVL(cp_choice_no, choice_no);
278:
279: CURSOR cur_uctr (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
280: SELECT ROWID
281: FROM igs_uc_transactions
282: WHERE app_no = cp_app_no
283: AND choice_no = cp_choice_no;

Line 295: l_choice_no igs_uc_app_choices.choice_no%TYPE;

291: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE;
292: l_error_message fnd_new_messages.message_text%TYPE;
293: l_person_no igs_pe_person_base_v.person_number%TYPE;
294: l_dec_imp_err fnd_new_messages.message_text%TYPE;
295: l_choice_no igs_uc_app_choices.choice_no%TYPE;
296:
297: --Table Type to hold the batch_id created for diferrent system cycle calendars.
298: TYPE choice_det_table_type IS TABLE OF igs_uc_app_choices.choice_no%TYPE INDEX BY BINARY_INTEGER;
299:

Line 298: TYPE choice_det_table_type IS TABLE OF igs_uc_app_choices.choice_no%TYPE INDEX BY BINARY_INTEGER;

294: l_dec_imp_err fnd_new_messages.message_text%TYPE;
295: l_choice_no igs_uc_app_choices.choice_no%TYPE;
296:
297: --Table Type to hold the batch_id created for diferrent system cycle calendars.
298: TYPE choice_det_table_type IS TABLE OF igs_uc_app_choices.choice_no%TYPE INDEX BY BINARY_INTEGER;
299:
300: --Table/Collection variable to hold the records for batch ids created of diferrent system, cycle and calendars.
301: l_expunge_choice_det choice_det_table_type;
302: l_expunge_choice_loc NUMBER;

Line 532: igs_uc_app_choices_pkg.delete_row ( x_rowid => x.ROWID );

528: igs_uc_app_cho_cnds_pkg.delete_row ( x_rowid => x.ROWID );
529: END LOOP;
530:
531: FOR x IN cur_ucapch (l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc)) LOOP
532: igs_uc_app_choices_pkg.delete_row ( x_rowid => x.ROWID );
533: END LOOP;
534:
535: FOR x IN cur_uctr (l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc)) LOOP
536: igs_uc_transactions_pkg.delete_row ( x_rowid => x.ROWID );

Line 659: -- instances are suspended and there exists some Application Choices in IGS_UC_APP_CHOICES table

655: -- 1. All application choice details and related OSS application instances are expunged and
656: -- Alternate Person IDs are closed and Interface Records are also succussfully deleted
657: -- then mark the Wrong Applicant record as expunged.
658: -- 2. All application choice details maked as LOST are expunged and also the related OSS application
659: -- instances are suspended and there exists some Application Choices in IGS_UC_APP_CHOICES table
660: -- which are not marked as LOST then mark the Wrong Applicant as expunged.
661: IF ( l_ucas_app_expunged = 'Y' AND l_pe_alt_pers_id_closed = 'Y' AND l_ucas_app_recs_deleted = 'Y' ) OR
662: ( l_ucas_app_expunged = 'N' AND l_all_makred_app_inst_expunged = 'Y' ) THEN
663: BEGIN