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.

[Home] [Help]

APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_INTERFACE_ALL

Line 106: CURSOR cur_ad_interface_id ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,

102: WHERE ucap.app_no = cp_app_no;
103: cur_uc_app_dtls_rec cur_uc_app_dtls%ROWTYPE;
104:
105: -- Fetch the Interface ID for the passed Batch ID and Person ID
106: CURSOR cur_ad_interface_id ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
107: cp_person_id IGS_AD_INTERFACE_ALL.person_id%TYPE) IS
108: SELECT interface_id
109: FROM IGS_AD_INTERFACE_ALL
110: WHERE batch_id = cp_batch_id

Line 107: cp_person_id IGS_AD_INTERFACE_ALL.person_id%TYPE) IS

103: cur_uc_app_dtls_rec cur_uc_app_dtls%ROWTYPE;
104:
105: -- Fetch the Interface ID for the passed Batch ID and Person ID
106: CURSOR cur_ad_interface_id ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
107: cp_person_id IGS_AD_INTERFACE_ALL.person_id%TYPE) IS
108: SELECT interface_id
109: FROM IGS_AD_INTERFACE_ALL
110: WHERE batch_id = cp_batch_id
111: AND person_id = cp_person_id;

Line 109: FROM IGS_AD_INTERFACE_ALL

105: -- Fetch the Interface ID for the passed Batch ID and Person ID
106: CURSOR cur_ad_interface_id ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
107: cp_person_id IGS_AD_INTERFACE_ALL.person_id%TYPE) IS
108: SELECT interface_id
109: FROM IGS_AD_INTERFACE_ALL
110: WHERE batch_id = cp_batch_id
111: AND person_id = cp_person_id;
112:
113: /* Cursors used in the Export Applicant Details Logic */

Line 153: CURSOR cur_proc_applicants(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS

149: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
150:
151: /* Cursors used to Process the Admission Interface Tables data */
152:
153: CURSOR cur_proc_applicants(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
154: SELECT ucap.rowid,ucap.*
155: FROM IGS_UC_APPLICANTS ucap
156: WHERE ucap.ad_batch_id = cp_batch_id;
157:

Line 158: CURSOR cur_proc_app_address(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS

154: SELECT ucap.rowid,ucap.*
155: FROM IGS_UC_APPLICANTS ucap
156: WHERE ucap.ad_batch_id = cp_batch_id;
157:
158: CURSOR cur_proc_app_address(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
159: SELECT ucad.rowid,ucad.*
160: FROM IGS_UC_APP_ADDRESES ucad
161: WHERE ucad.ad_batch_id = cp_batch_id;
162:

Line 163: CURSOR cur_ad_interface_exist (cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,

159: SELECT ucad.rowid,ucad.*
160: FROM IGS_UC_APP_ADDRESES ucad
161: WHERE ucad.ad_batch_id = cp_batch_id;
162:
163: CURSOR cur_ad_interface_exist (cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
164: cp_interface_id IGS_AD_INTERFACE_ALL.INTERFACE_ID%TYPE) IS
165: SELECT 'X'
166: FROM IGS_AD_INTERFACE_ALL
167: WHERE batch_id = cp_batch_id

Line 164: cp_interface_id IGS_AD_INTERFACE_ALL.INTERFACE_ID%TYPE) IS

160: FROM IGS_UC_APP_ADDRESES ucad
161: WHERE ucad.ad_batch_id = cp_batch_id;
162:
163: CURSOR cur_ad_interface_exist (cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
164: cp_interface_id IGS_AD_INTERFACE_ALL.INTERFACE_ID%TYPE) IS
165: SELECT 'X'
166: FROM IGS_AD_INTERFACE_ALL
167: WHERE batch_id = cp_batch_id
168: AND interface_id = cp_interface_id;

Line 166: FROM IGS_AD_INTERFACE_ALL

162:
163: CURSOR cur_ad_interface_exist (cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
164: cp_interface_id IGS_AD_INTERFACE_ALL.INTERFACE_ID%TYPE) IS
165: SELECT 'X'
166: FROM IGS_AD_INTERFACE_ALL
167: WHERE batch_id = cp_batch_id
168: AND interface_id = cp_interface_id;
169:
170: -- anwest Bug# 3642740 New cursor to store UCAS applicants in error

Line 279: l_ad_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;

275: l_rep_request_id NUMBER;
276: l_sent_to_oss_flag IGS_UC_APP_NAMES.sent_to_oss_flag%TYPE;
277: l_dom_text_value IGS_UC_REF_APR.dom_text%TYPE;
278: l_ad_batch_id IGS_AD_IMP_BATCH_DET.batch_id%TYPE;
279: l_ad_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;
280:
281:
282: -- Bug No. 2980137. Variable to obtain the return code.
283: l_retcode NUMBER;

Line 649: /* Populate the IGS_AD_INTERFACE_ALL table with Interface ID, Batch ID, Source Type ID,Person ID,

645:
646: -- Initialize the Applicant valid status to TRUE
647: l_app_valid_status := TRUE;
648:
649: /* Populate the IGS_AD_INTERFACE_ALL table with Interface ID, Batch ID, Source Type ID,Person ID,
650: match_ind as "15" and person details */
651:
652: -- Check if a record exists in IGS_AD_INTERFACE_ALL for the Admissions Batch ID and Person ID
653: -- If exists use the same ID( that is If same person was processed earlier for some other

Line 652: -- Check if a record exists in IGS_AD_INTERFACE_ALL for the Admissions Batch ID and Person ID

648:
649: /* Populate the IGS_AD_INTERFACE_ALL table with Interface ID, Batch ID, Source Type ID,Person ID,
650: match_ind as "15" and person details */
651:
652: -- Check if a record exists in IGS_AD_INTERFACE_ALL for the Admissions Batch ID and Person ID
653: -- If exists use the same ID( that is If same person was processed earlier for some other
654: -- UCAS system Application), otherwise create a new Interface ID
655: l_ad_interface_id := NULL;
656:

Line 675: INSERT INTO igs_ad_interface_all (

671: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
672: fnd_file.put_line(fnd_file.log, fnd_message.get);
673: END IF;
674:
675: INSERT INTO igs_ad_interface_all (
676: interface_id,
677: batch_id,
678: source_type_id,
679: person_id,

Line 1095: -- Check if a record exists in IGS_AD_INTERFACE_ALL for the Admissions Batch ID and Person ID

1091:
1092: -- Initialize the Applicant valid status to TRUE
1093: l_app_valid_status := TRUE;
1094:
1095: -- Check if a record exists in IGS_AD_INTERFACE_ALL for the Admissions Batch ID and Person ID
1096: -- If exists use the same ID, otherwise create a new Interface ID
1097: l_ad_interface_id := NULL;
1098:
1099: OPEN cur_ad_interface_id(l_ad_batch_id, cur_uc_app_dtls_rec.oss_person_id);

Line 1117: INSERT INTO igs_ad_interface_all (

1113: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
1114: fnd_file.put_line(fnd_file.log, fnd_message.get);
1115: END IF;
1116:
1117: INSERT INTO igs_ad_interface_all (
1118: interface_id,
1119: batch_id,
1120: source_type_id,
1121: person_id,

Line 3156: CURSOR cur_ad_interface ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS

3152: WHERE source_type_id = cp_source_type_id;
3153: l_match_set_id IGS_PE_MATCH_SETS.match_set_id%TYPE;
3154:
3155: -- Fetch the Interface ID for the passed Batch ID
3156: CURSOR cur_ad_interface ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
3157: SELECT interface_id
3158: FROM IGS_AD_INTERFACE_ALL
3159: WHERE batch_id = cp_batch_id;
3160: l_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;

Line 3158: FROM IGS_AD_INTERFACE_ALL

3154:
3155: -- Fetch the Interface ID for the passed Batch ID
3156: CURSOR cur_ad_interface ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
3157: SELECT interface_id
3158: FROM IGS_AD_INTERFACE_ALL
3159: WHERE batch_id = cp_batch_id;
3160: l_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;
3161:
3162: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;

Line 3160: l_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;

3156: CURSOR cur_ad_interface ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
3157: SELECT interface_id
3158: FROM IGS_AD_INTERFACE_ALL
3159: WHERE batch_id = cp_batch_id;
3160: l_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;
3161:
3162: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
3163: l_errbuff VARCHAR2(100) ;
3164: l_retcode NUMBER ;