APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_ADDRESES

Line 1418: FROM igs_uc_app_addreses appaddr

1414:
1415: CURSOR old_stara_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
1416: SELECT appaddr.rowid,
1417: appaddr.*
1418: FROM igs_uc_app_addreses appaddr
1419: WHERE appaddr.app_no = p_appno;
1420:
1421: CURSOR appl_details (cp_appno igs_uc_applicants.app_no%TYPE) IS
1422: SELECT app.rowid, app.*

Line 1528: igs_uc_app_addreses_pkg.insert_row --

1524: IF old_stara_rec.rowid IS NULL THEN
1525:
1526: BEGIN
1527: --Insert a new record as no corresponding record exists.
1528: igs_uc_app_addreses_pkg.insert_row --
1529: (
1530: x_rowid => old_stara_rec.rowid
1531: ,x_app_no => new_ivstara_rec.appno
1532: ,x_address_area => new_ivstara_rec.addressarea

Line 1569: igs_uc_app_addreses_pkg.update_row --

1565: ELSE /* Update the record */
1566:
1567: BEGIN
1568: -- call the TBH to update the record
1569: igs_uc_app_addreses_pkg.update_row --
1570: (
1571: x_rowid => old_stara_rec.rowid
1572: ,x_app_no => old_stara_rec.app_no
1573: ,x_address_area => new_ivstara_rec.addressarea