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_EXP_APPLICANT_DTLS dependencies on IGS_UC_APP_NAMES

Line 136: CURSOR cur_upd_app_name ( cp_app_no IGS_UC_APP_NAMES.app_no%TYPE) IS

132:
133: /* Cursors used in displaying Applicant Name Details to be changed manually */
134:
135: -- Cursor to fetch the Applicant Name Details for Update
136: CURSOR cur_upd_app_name ( cp_app_no IGS_UC_APP_NAMES.app_no%TYPE) IS
137: SELECT ucn.rowid,ucn.*
138: FROM IGS_UC_APP_NAMES ucn
139: WHERE ucn.app_no = cp_app_no;
140: cur_app_name_rec cur_upd_app_name%ROWTYPE;

Line 138: FROM IGS_UC_APP_NAMES ucn

134:
135: -- Cursor to fetch the Applicant Name Details for Update
136: CURSOR cur_upd_app_name ( cp_app_no IGS_UC_APP_NAMES.app_no%TYPE) IS
137: SELECT ucn.rowid,ucn.*
138: FROM IGS_UC_APP_NAMES ucn
139: WHERE ucn.app_no = cp_app_no;
140: cur_app_name_rec cur_upd_app_name%ROWTYPE;
141:
142: -- Fetch the HESA Mapping value

Line 255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,

251: cur_app_address_dtls_rec IGS_UC_APP_ADDRESES%ROWTYPE;
252:
253: --jchakrab added for 3691220
254: TYPE app_name_record IS RECORD (
255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,
256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,

Line 256: title IGS_UC_APP_NAMES.TITLE%TYPE,

252:
253: --jchakrab added for 3691220
254: TYPE app_name_record IS RECORD (
255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,
256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,
260: sex IGS_UC_APP_NAMES.SEX%TYPE );

Line 257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,

253: --jchakrab added for 3691220
254: TYPE app_name_record IS RECORD (
255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,
256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,
260: sex IGS_UC_APP_NAMES.SEX%TYPE );
261:

Line 258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,

254: TYPE app_name_record IS RECORD (
255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,
256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,
260: sex IGS_UC_APP_NAMES.SEX%TYPE );
261:
262: TYPE t_cur_app_name_dtls IS REF CURSOR RETURN app_name_record;

Line 259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,

255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,
256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,
260: sex IGS_UC_APP_NAMES.SEX%TYPE );
261:
262: TYPE t_cur_app_name_dtls IS REF CURSOR RETURN app_name_record;
263: cur_app_name_dtls t_cur_app_name_dtls;

Line 260: sex IGS_UC_APP_NAMES.SEX%TYPE );

256: title IGS_UC_APP_NAMES.TITLE%TYPE,
257: fore_names IGS_UC_APP_NAMES.FORE_NAMES%TYPE,
258: surname IGS_UC_APP_NAMES.SURNAME%TYPE,
259: birth_date IGS_UC_APP_NAMES.BIRTH_DATE%TYPE,
260: sex IGS_UC_APP_NAMES.SEX%TYPE );
261:
262: TYPE t_cur_app_name_dtls IS REF CURSOR RETURN app_name_record;
263: cur_app_name_dtls t_cur_app_name_dtls;
264:

Line 276: l_sent_to_oss_flag IGS_UC_APP_NAMES.sent_to_oss_flag%TYPE;

272: l_dummy VARCHAR2(1);
273: l_oss_country_code igs_he_code_map_val.map2%TYPE;
274:
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:

Line 1282: FROM IGS_UC_APP_NAMES

1278: --jchakrab added for 3691220
1279: IF p_app_no IS NULL THEN
1280: OPEN cur_app_name_dtls FOR
1281: SELECT APP_NO,TITLE, FORE_NAMES, SURNAME, BIRTH_DATE, SEX
1282: FROM IGS_UC_APP_NAMES
1283: WHERE SENT_TO_OSS_FLAG = 'N'
1284: ORDER BY APP_NO;
1285:
1286: ELSE

Line 1289: FROM IGS_UC_APP_NAMES

1285:
1286: ELSE
1287: OPEN cur_app_name_dtls FOR
1288: SELECT APP_NO,TITLE, FORE_NAMES, SURNAME, BIRTH_DATE, SEX
1289: FROM IGS_UC_APP_NAMES
1290: WHERE APP_NO = p_app_no AND
1291: SENT_TO_OSS_FLAG = 'N'
1292: ORDER BY APP_NO;
1293: END IF;

Line 1295: -- Loop through all the records in IGS_UC_APP_NAMES table satisfying the criteria,

1291: SENT_TO_OSS_FLAG = 'N'
1292: ORDER BY APP_NO;
1293: END IF;
1294:
1295: -- Loop through all the records in IGS_UC_APP_NAMES table satisfying the criteria,
1296: -- SENT_TO_OSS_FLAG is N and passed parameter,P_APP_NO
1297: LOOP
1298: FETCH cur_app_name_dtls INTO cur_app_name_dtls_rec;
1299: EXIT WHEN cur_app_name_dtls%NOTFOUND;

Line 1361: /* Update the IGS_UC_APP_NAMES Table with sent_to_oss_flag to 'Y' */

1357: fnd_file.put_line(fnd_file.log, fnd_message.get);
1358:
1359: END IF;
1360:
1361: /* Update the IGS_UC_APP_NAMES Table with sent_to_oss_flag to 'Y' */
1362: cur_app_name_rec := NULL;
1363: OPEN cur_upd_app_name (cur_app_name_dtls_rec.app_no);
1364: FETCH cur_upd_app_name INTO cur_app_name_rec;
1365: CLOSE cur_upd_app_name;

Line 1367: igs_uc_app_names_pkg.update_row(

1363: OPEN cur_upd_app_name (cur_app_name_dtls_rec.app_no);
1364: FETCH cur_upd_app_name INTO cur_app_name_rec;
1365: CLOSE cur_upd_app_name;
1366:
1367: igs_uc_app_names_pkg.update_row(
1368: x_rowid => cur_app_name_rec.rowid
1369: ,x_app_no => cur_app_name_rec.app_no
1370: ,x_check_digit => cur_app_name_rec.check_digit
1371: ,x_name_change_date => cur_app_name_rec.name_change_date