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_APP_NAMES

Line 974: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS

970:
971: c_starn_int_rec c_starn_int%ROWTYPE ;
972:
973: -- get the name details for this applicant
974: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS
975: SELECT name_change_date , title , fore_names , surname
976: FROM igs_uc_app_names
977: WHERE app_no = cp_appno ;
978: c_app_name_rec c_app_name%ROWTYPE ;

Line 976: FROM igs_uc_app_names

972:
973: -- get the name details for this applicant
974: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS
975: SELECT name_change_date , title , fore_names , surname
976: FROM igs_uc_app_names
977: WHERE app_no = cp_appno ;
978: c_app_name_rec c_app_name%ROWTYPE ;
979:
980: -- Get the name details from the Starn transaction for this applicant

Line 989: l_namechangedate igs_uc_app_names.name_change_date%TYPE ;

985: AND TO_NUMBER(TRIM(SUBSTR(record_data,1,8))) = cp_appno;
986:
987: l_n_data igs_uc_load_mv_t.record_data%TYPE ;
988:
989: l_namechangedate igs_uc_app_names.name_change_date%TYPE ;
990: l_title igs_uc_app_names.title%TYPE ;
991: l_forenames igs_uc_app_names.fore_names%TYPE ;
992: l_surname igs_uc_app_names.surname%TYPE ;
993:

Line 990: l_title igs_uc_app_names.title%TYPE ;

986:
987: l_n_data igs_uc_load_mv_t.record_data%TYPE ;
988:
989: l_namechangedate igs_uc_app_names.name_change_date%TYPE ;
990: l_title igs_uc_app_names.title%TYPE ;
991: l_forenames igs_uc_app_names.fore_names%TYPE ;
992: l_surname igs_uc_app_names.surname%TYPE ;
993:
994: BEGIN

Line 991: l_forenames igs_uc_app_names.fore_names%TYPE ;

987: l_n_data igs_uc_load_mv_t.record_data%TYPE ;
988:
989: l_namechangedate igs_uc_app_names.name_change_date%TYPE ;
990: l_title igs_uc_app_names.title%TYPE ;
991: l_forenames igs_uc_app_names.fore_names%TYPE ;
992: l_surname igs_uc_app_names.surname%TYPE ;
993:
994: BEGIN
995:

Line 992: l_surname igs_uc_app_names.surname%TYPE ;

988:
989: l_namechangedate igs_uc_app_names.name_change_date%TYPE ;
990: l_title igs_uc_app_names.title%TYPE ;
991: l_forenames igs_uc_app_names.fore_names%TYPE ;
992: l_surname igs_uc_app_names.surname%TYPE ;
993:
994: BEGIN
995:
996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

Line 1175: -- from igs_uc_app_names

1171: FETCH c_starn_int INTO c_starn_int_rec;
1172: CLOSE c_starn_int;
1173:
1174: -- Else if *N INTS record is not present or if name fields are NULL then Get values
1175: -- from igs_uc_app_names
1176: c_app_name_rec := NULL;
1177: OPEN c_app_name( ln_appno ) ;
1178: FETCH c_app_name INTO c_app_name_rec ;
1179: CLOSE c_app_name ;

Line 1325: CURSOR c_app_name (cp_appno igs_uc_app_names.app_no%TYPE ) IS

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
1327: FROM igs_uc_app_names
1328: WHERE app_no = cp_appno ;
1329: c_app_name_rec c_app_name%ROWTYPE ;

Line 1327: FROM igs_uc_app_names

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
1327: FROM igs_uc_app_names
1328: WHERE app_no = cp_appno ;
1329: c_app_name_rec c_app_name%ROWTYPE ;
1330:
1331: BEGIN

Line 1355: -- Else if *N INTS record is not present or if dob and sex are NULL then Get values from igs_uc_app_names

1351: OPEN c_starn_int( ln_appno ) ;
1352: FETCH c_starn_int INTO c_starn_int_rec;
1353: CLOSE c_starn_int;
1354:
1355: -- Else if *N INTS record is not present or if dob and sex are NULL then Get values from igs_uc_app_names
1356: c_app_name_rec := NULL ;
1357: OPEN c_app_name( ln_appno ) ;
1358: FETCH c_app_name INTO c_app_name_rec ;
1359: CLOSE c_app_name ;