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.

[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_FORM_QUALS

Line 7149: CURSOR old_frmqual_cur(p_appno igs_uc_form_quals.app_no%TYPE,

7145: FROM igs_uc_ifrmqul_ints ivfq
7146: WHERE ivfq.record_status = 'N';
7147:
7148: -- check for corresponding record in main table.
7149: CURSOR old_frmqual_cur(p_appno igs_uc_form_quals.app_no%TYPE,
7150: p_qualtype igs_uc_form_quals.qual_type%TYPE,
7151: p_title igs_uc_form_quals.title%TYPE) IS
7152: SELECT ufq.rowid,
7153: ufq.*

Line 7150: p_qualtype igs_uc_form_quals.qual_type%TYPE,

7146: WHERE ivfq.record_status = 'N';
7147:
7148: -- check for corresponding record in main table.
7149: CURSOR old_frmqual_cur(p_appno igs_uc_form_quals.app_no%TYPE,
7150: p_qualtype igs_uc_form_quals.qual_type%TYPE,
7151: p_title igs_uc_form_quals.title%TYPE) IS
7152: SELECT ufq.rowid,
7153: ufq.*
7154: FROM igs_uc_form_quals ufq

Line 7151: p_title igs_uc_form_quals.title%TYPE) IS

7147:
7148: -- check for corresponding record in main table.
7149: CURSOR old_frmqual_cur(p_appno igs_uc_form_quals.app_no%TYPE,
7150: p_qualtype igs_uc_form_quals.qual_type%TYPE,
7151: p_title igs_uc_form_quals.title%TYPE) IS
7152: SELECT ufq.rowid,
7153: ufq.*
7154: FROM igs_uc_form_quals ufq
7155: WHERE ufq.app_no = p_appno

Line 7154: FROM igs_uc_form_quals ufq

7150: p_qualtype igs_uc_form_quals.qual_type%TYPE,
7151: p_title igs_uc_form_quals.title%TYPE) IS
7152: SELECT ufq.rowid,
7153: ufq.*
7154: FROM igs_uc_form_quals ufq
7155: WHERE ufq.app_no = p_appno
7156: AND ufq.qual_type = p_qualtype
7157: AND ufq.title = p_title;
7158:

Line 7223: igs_uc_form_quals_pkg.insert_row -- IGSXI51B.pls

7219:
7220: BEGIN
7221:
7222: -- call the TBH to Insert the record
7223: igs_uc_form_quals_pkg.insert_row -- IGSXI51B.pls
7224: (
7225: x_rowid => old_frmqual_rec.rowid
7226: ,x_app_no => new_ivfrmqual_rec.appno
7227: ,x_qual_id => new_ivfrmqual_rec.qualid

Line 7247: igs_uc_form_quals_pkg.update_row -- IGSXI51B.pls

7243:
7244: ELSE -- update
7245:
7246: BEGIN
7247: igs_uc_form_quals_pkg.update_row -- IGSXI51B.pls
7248: (
7249: x_rowid => old_frmqual_rec.rowid
7250: ,x_app_no => old_frmqual_rec.app_no
7251: ,x_qual_id => new_ivfrmqual_rec.qualid