APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_NAMES

Line 562: CURSOR old_starn_cur(p_appno igs_uc_app_names.app_no%TYPE) IS

558: WHERE ivstn.record_status = 'N';
559:
560:
561: -- check for corresponding record in UCAS Names table.
562: CURSOR old_starn_cur(p_appno igs_uc_app_names.app_no%TYPE) IS
563: SELECT uapn.rowid,
564: uapn.*
565: FROM igs_uc_app_names uapn
566: WHERE uapn.app_no = p_appno;

Line 565: FROM igs_uc_app_names uapn

561: -- check for corresponding record in UCAS Names table.
562: CURSOR old_starn_cur(p_appno igs_uc_app_names.app_no%TYPE) IS
563: SELECT uapn.rowid,
564: uapn.*
565: FROM igs_uc_app_names uapn
566: WHERE uapn.app_no = p_appno;
567:
568:
569: -- check for corresponding record in UCAS Applicants table.

Line 977: -- Beginning processing for IGS_UC_APP_NAMES table

973: END IF; -- error code check for inserting into UC applicants
974:
975:
976: ----------------------------------------------------------------------------------------
977: -- Beginning processing for IGS_UC_APP_NAMES table
978: -- Ideally, an insert into UC_APPLICANTS must result in Insert into UC_APP_NAMES.
979: ----------------------------------------------------------------------------------------
980: IF g_error_code IS NULL THEN
981:

Line 996: igs_uc_app_names_pkg.insert_row

992: IF old_starn_rec.rowid IS NULL THEN
993: -- since corresponding record does not exist in UCAS APplicants, Insert a record with basic details.
994: BEGIN
995: -- call the insert row to insert a new record
996: igs_uc_app_names_pkg.insert_row
997: (
998: x_rowid => old_starn_rec.rowid, -- while insert this rec variable would be null.
999: x_app_no => new_ivstarn_rec.appno,
1000: x_check_digit => new_ivstarn_rec.checkdigit,

Line 1023: igs_uc_app_names_pkg.update_row

1019: ELSE -- Corr. rec exists in UCAS Names table hence going for update.
1020:
1021: BEGIN
1022: -- call the update row to update existing record in UC APP NAMES table.
1023: igs_uc_app_names_pkg.update_row
1024: (
1025: x_rowid => old_starn_rec.rowid, -- while insert this rec variable would be null.
1026: x_app_no => old_starn_rec.app_no,
1027: x_check_digit => old_starn_rec.check_digit,

Line 1048: -- End of processing for IGS_UC_APP_NAMES table

1044: END IF; -- insert/update APP NAMES table.
1045:
1046: END IF; -- beginning of processing for APP NAMES table
1047: -----------------------------------------------
1048: -- End of processing for IGS_UC_APP_NAMES table
1049: -----------------------------------------------
1050:
1051:
1052: -----------------------------------------------