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_MV_DATA_UPLD dependencies on IGS_UC_ISTARN_INTS

Line 965: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS

961: l_regno igs_uc_istark_ints.regno%TYPE := NULL;
962: ln_appno igs_uc_istark_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
963:
964: -- Get matching record from starN int table for the passed hercules record
965: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS
966: SELECT a.rowid ,a.namechangedate , a.title , a.forenames, a.surname
967: FROM igs_uc_istarn_ints a
968: WHERE record_status = 'N'
969: AND appno = cp_appno ;

Line 967: FROM igs_uc_istarn_ints a

963:
964: -- Get matching record from starN int table for the passed hercules record
965: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS
966: SELECT a.rowid ,a.namechangedate , a.title , a.forenames, a.surname
967: FROM igs_uc_istarn_ints a
968: WHERE record_status = 'N'
969: AND appno = cp_appno ;
970:
971: c_starn_int_rec c_starn_int%ROWTYPE ;

Line 1204: UPDATE igs_uc_istarn_ints SET

1200: c_starn_int_rec := NULL ;
1201: OPEN c_starn_int( ln_appno ) ;
1202: FETCH c_starn_int INTO c_starn_int_rec ;
1203: IF c_starn_int%FOUND THEN
1204: UPDATE igs_uc_istarn_ints SET
1205: namechangedate = NVL(l_namechangedate,namechangedate),
1206: title = NVL(l_title,title),
1207: forenames = NVL(l_forenames,forenames),
1208: surname = NVL(l_surname,surname) ,

Line 1217: INSERT INTO igs_uc_istarn_ints (

1213: ad_api_id = NULL ,
1214: error_code = NULL
1215: WHERE rowid = c_starn_int_rec.rowid ;
1216: ELSE
1217: INSERT INTO igs_uc_istarn_ints (
1218: appno,
1219: checkdigit,
1220: namechangedate,
1221: title,

Line 1288: || replaced igs_uc_mv_ivstarn with igs_uc_istarn_ints

1284: || Who When What
1285: || (reverse chronological order - newest change first)
1286: || rgangara 28 Nov 02 For Y2K problem found during testing.
1287: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1288: || replaced igs_uc_mv_ivstarn with igs_uc_istarn_ints
1289: || smaddali 7-aug-03 Modified procedure logic for updating *N INTS record for bug 3085770
1290: */
1291:
1292: /* rgangara 28-Nov-02

Line 1301: ln_appno igs_uc_istarn_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

1297: which would through up errors. Hence since it is assumed that the Applicants in UCAS would have birthdates in
1298: 19's and not beyond 2000, the code here has been modified to do a proper conversion by changing format mask as 'DDMMRR' instead of 'DDMMYY'.
1299: */
1300:
1301: ln_appno igs_uc_istarn_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1302:
1303: -- Get the details of birthdate and sex from the Stark transaction
1304: CURSOR get_k_data( cp_appno NUMBER ) IS
1305: SELECT record_data

Line 1313: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS

1309:
1310: l_k_data igs_uc_load_mv_t.record_data%TYPE ;
1311:
1312: -- Get matching record from starN int table for the passed hercules record
1313: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS
1314: SELECT a.rowid , a.sex, a.birthdate
1315: FROM igs_uc_istarn_ints a
1316: WHERE record_status = 'N'
1317: AND appno = cp_appno ;

Line 1315: FROM igs_uc_istarn_ints a

1311:
1312: -- Get matching record from starN int table for the passed hercules record
1313: CURSOR c_starn_int( cp_appno igs_uc_istarn_ints.appno%TYPE ) IS
1314: SELECT a.rowid , a.sex, a.birthdate
1315: FROM igs_uc_istarn_ints a
1316: WHERE record_status = 'N'
1317: AND appno = cp_appno ;
1318:
1319: c_starn_int_rec c_starn_int%ROWTYPE ;

Line 1321: l_birthdate igs_uc_istarn_ints.birthdate%TYPE ;

1317: AND appno = cp_appno ;
1318:
1319: c_starn_int_rec c_starn_int%ROWTYPE ;
1320:
1321: l_birthdate igs_uc_istarn_ints.birthdate%TYPE ;
1322: l_sex igs_uc_istarn_ints.sex%TYPE ;
1323:
1324: -- get the name details for this applicant
1325: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS

Line 1322: l_sex igs_uc_istarn_ints.sex%TYPE ;

1318:
1319: c_starn_int_rec c_starn_int%ROWTYPE ;
1320:
1321: l_birthdate igs_uc_istarn_ints.birthdate%TYPE ;
1322: l_sex igs_uc_istarn_ints.sex%TYPE ;
1323:
1324: -- get the name details for this applicant
1325: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS
1326: SELECT birth_date , sex

Line 1378: UPDATE igs_uc_istarn_ints SET

1374: c_starn_int_rec := NULL;
1375: OPEN c_starn_int( ln_appno ) ;
1376: FETCH c_starn_int INTO c_starn_int_rec;
1377: IF c_starn_int%FOUND THEN
1378: UPDATE igs_uc_istarn_ints SET
1379: checkdigit = TO_NUMBER(TRIM(SUBSTR(p_record_data,9,1))) ,
1380: namechangedate = TO_DATE(TRIM(SUBSTR(p_record_data,11,6)), 'DDMMRR') ,
1381: title = UPPER(TRIM(SUBSTR(p_record_data,17,4))) ,
1382: forenames = TRIM(SUBSTR(p_record_data,42,24)) ,

Line 1392: INSERT INTO igs_uc_istarn_ints (

1388: ad_api_id = NULL ,
1389: error_code = NULL
1390: WHERE rowid = c_starn_int_rec.rowid ;
1391: ELSE
1392: INSERT INTO igs_uc_istarn_ints (
1393: appno,
1394: checkdigit,
1395: namechangedate,
1396: title,