APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_WRONG_APP

Line 6666: CURSOR old_starw_cur(p_appno igs_uc_wrong_app.app_no%TYPE) IS

6662: FROM igs_uc_istarw_ints ivstz2
6663: WHERE ivstz2.record_status = 'N';
6664:
6665: -- check for corresponding record in main table.
6666: CURSOR old_starw_cur(p_appno igs_uc_wrong_app.app_no%TYPE) IS
6667: SELECT uwap.rowid,
6668: uwap.*
6669: FROM igs_uc_wrong_app uwap
6670: WHERE uwap.app_no = p_appno;

Line 6669: FROM igs_uc_wrong_app uwap

6665: -- check for corresponding record in main table.
6666: CURSOR old_starw_cur(p_appno igs_uc_wrong_app.app_no%TYPE) IS
6667: SELECT uwap.rowid,
6668: uwap.*
6669: FROM igs_uc_wrong_app uwap
6670: WHERE uwap.app_no = p_appno;
6671:
6672: old_starw_rec old_starw_cur%ROWTYPE;
6673:

Line 6680: l_reinstate_meaning IGS_UC_WRONG_APP.REMARK%TYPE;

6676: FROM IGS_LOOKUP_VALUES LKUP
6677: WHERE LKUP.LOOKUP_TYPE = 'IGS_UC_APP_WITHDRAWN'
6678: AND LKUP.LOOKUP_CODE = 'R';
6679:
6680: l_reinstate_meaning IGS_UC_WRONG_APP.REMARK%TYPE;
6681: l_expunge_flag IGS_UC_WRONG_APP.EXPUNGE%TYPE;
6682:
6683: BEGIN
6684:

Line 6681: l_expunge_flag IGS_UC_WRONG_APP.EXPUNGE%TYPE;

6677: WHERE LKUP.LOOKUP_TYPE = 'IGS_UC_APP_WITHDRAWN'
6678: AND LKUP.LOOKUP_CODE = 'R';
6679:
6680: l_reinstate_meaning IGS_UC_WRONG_APP.REMARK%TYPE;
6681: l_expunge_flag IGS_UC_WRONG_APP.EXPUNGE%TYPE;
6682:
6683: BEGIN
6684:
6685: -- initialize variables

Line 6754: igs_uc_wrong_app_pkg.insert_row -- IGSXI34B.pls

6750: IF old_starw_rec.rowid IS NULL THEN -- i.e. new record.
6751:
6752: BEGIN
6753: -- call the TBH to update the record
6754: igs_uc_wrong_app_pkg.insert_row -- IGSXI34B.pls
6755: (
6756: x_rowid => old_starw_rec.rowid -- since it would be NULL if old rec not found
6757: ,x_wrong_app_id => old_starw_rec.wrong_app_id -- since it would be NULL if old rec not found
6758: ,x_app_no => new_ivstarw_rec.appno

Line 6788: igs_uc_wrong_app_pkg.update_row -- IGSXI34B.pls

6784: ELSE -- update
6785:
6786: BEGIN
6787: -- call the TBH to update the record
6788: igs_uc_wrong_app_pkg.update_row -- IGSXI34B.pls
6789: (
6790: x_rowid => old_starw_rec.rowid
6791: ,x_wrong_app_id => old_starw_rec.wrong_app_id
6792: ,x_app_no => old_starw_rec.app_no