APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_INST_CONTROL

Line 75: rbezawad 27-Apr-04 Added code to insert a record into igs_uc_inst_control

71: Purpose : For processing UVINSTITITUTION view
72: Known limitations,enhancements,remarks:
73: Change History
74: Who When What
75: rbezawad 27-Apr-04 Added code to insert a record into igs_uc_inst_control
76: when there is no existing record for bug 3595582.
77: jbaber 03-Aug-05 Import ALL fields instead of just some for bug 4532072
78: jchakrab 08-Aug-2005 Modified for UC315 - removed validation for insttype
79: and updater, as these columns are no longer used

Line 94: FROM igs_uc_inst_control;

90: WHERE record_status = 'N';
91:
92: CURSOR chk_inst_ctl IS
93: SELECT count(*)
94: FROM igs_uc_inst_control;
95:
96: CURSOR old_inst_cur IS
97: SELECT inst.rowid row_id,
98: inst.*

Line 99: FROM igs_uc_inst_control inst;

95:
96: CURSOR old_inst_cur IS
97: SELECT inst.rowid row_id,
98: inst.*
99: FROM igs_uc_inst_control inst;
100:
101: old_inst_ctl_rec old_inst_cur%ROWTYPE;
102:
103: BEGIN

Line 128: igs_uc_inst_control_pkg.insert_row -- IGSXI20B.pls

124:
125: -- check that the Institution data is setup. If not available then insert a record.
126: IF(l_rowcnt = 0) THEN
127: BEGIN
128: igs_uc_inst_control_pkg.insert_row -- IGSXI20B.pls
129: (
130: x_rowid => l_rowid
131: ,x_updater => '-1'
132: ,x_inst_type => 'C'

Line 205: igs_uc_inst_control_pkg.update_row -- IGSXI20B.pls

201:
202: IF g_error_code IS NULL THEN
203:
204: BEGIN
205: igs_uc_inst_control_pkg.update_row -- IGSXI20B.pls
206: (
207: x_rowid => old_inst_ctl_rec.row_id
208: ,x_updater => new_uinst_rec.updater
209: ,x_inst_type => new_uinst_rec.insttype