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.

APPS.IGS_PS_GEN_001 dependencies on IGS_GE_NOTE

Line 84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;

80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;
81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;
82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;
84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;
85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;
86: gv_cop_seq_num IGS_PS_OFR_PAT.cop_id%TYPE;
87: gv_ca_rec IGS_PS_AWARD%ROWTYPE;
88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;

Line 154: FROM IGS_GE_NOTE nte

150: FROM IGS_PS_VER_NOTE cvn
151: WHERE cvn.course_cd = p_old_course_cd AND
152: cvn.version_number = p_old_version_number AND
153: EXISTS (SELECT 1
154: FROM IGS_GE_NOTE nte
155: WHERE nte.reference_number = cvn.reference_number AND
156: nte.note_text IS NOT NULL);
157: CURSOR gc_ae_rec IS
158: SELECT *

Line 230: FROM IGS_GE_NOTE nte

226: WHERE con.course_cd = p_old_course_cd AND
227: con.version_number = p_old_version_number AND
228: cal_type = gv_co_rec.cal_type AND
229: EXISTS (SELECT 1
230: FROM IGS_GE_NOTE nte
231: WHERE nte.reference_number = con.reference_number AND
232: nte.note_text IS NOT NULL);
233: -- Only interested in notes that are not OLE type as
234: -- currently unable to copy long raw field within PL/SQL

Line 245: FROM IGS_GE_NOTE nte

241: coon.location_cd = gv_coo_rec.location_cd AND
242: coon.attendance_mode = gv_coo_rec.attendance_mode AND
243: coon.attendance_type = gv_coo_rec.attendance_type AND
244: EXISTS (SELECT 1
245: FROM IGS_GE_NOTE nte
246: WHERE nte.reference_number = coon.reference_number AND
247: nte.note_text IS NOT NULL);
248: -- Find the latest IGS_CA_INST of IGS_PS_OFR_INST
249: -- which returns the list in descending order, and the first record

Line 272: FROM IGS_GE_NOTE nte

268: SELECT *
269: FROM IGS_PS_OFR_PAT_NOTE cop
270: WHERE cop.cop_id = gv_cop_rec.cop_id AND
271: EXISTS (SELECT 1
272: FROM IGS_GE_NOTE nte
273: WHERE nte.reference_number = cop.reference_number AND
274: nte.note_text IS NOT NULL);
275:
276: -- Removed cursor gc_revseg_rec as part of Enh# 2831572.

Line 279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL

275:
276: -- Removed cursor gc_revseg_rec as part of Enh# 2831572.
277:
278: CURSOR gc_ref_num IS
279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL
280: FROM DUAL;
281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;

Line 285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records

281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (
287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:

Line 291: SELECT rowid,IGS_GE_NOTE.*

287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:
290: CURSOR Cur_SGN IS
291: SELECT rowid,IGS_GE_NOTE.*
292: FROM IGS_GE_NOTE
293: WHERE reference_number = gv_coon_rec.reference_number;
294: BEGIN
295: OPEN gc_ref_num;

Line 292: FROM IGS_GE_NOTE

288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:
290: CURSOR Cur_SGN IS
291: SELECT rowid,IGS_GE_NOTE.*
292: FROM IGS_GE_NOTE
293: WHERE reference_number = gv_coon_rec.reference_number;
294: BEGIN
295: OPEN gc_ref_num;
296: FETCH gc_ref_num INTO gv_ref_num;

Line 298: -- inserting IGS_GE_NOTE record with this next reference_number

294: BEGIN
295: OPEN gc_ref_num;
296: FETCH gc_ref_num INTO gv_ref_num;
297: CLOSE gc_ref_num;
298: -- inserting IGS_GE_NOTE record with this next reference_number
299: -- Currently unable to copy Long Raw columns in PL/SQL.
300:
301: For SGN_Rec in CUR_SGN
302: Loop

Line 304: IGS_GE_NOTE_PKG.INSERT_ROW(

300:
301: For SGN_Rec in CUR_SGN
302: Loop
303: x_rowid := NULL;
304: IGS_GE_NOTE_PKG.INSERT_ROW(
305: X_ROWID => X_ROWID,
306: X_REFERENCE_NUMBER =>gv_ref_num,
307: X_S_NOTE_FORMAT_TYPE =>SGN_Rec.s_note_format_type,
308: X_NOTE_TEXT =>SGN_Rec.note_text,

Line 337: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT_NOTE records

333: ELSE
334: App_Exception.Raise_Exception;
335: END IF;
336: END crsp_ins_coon_rec;
337: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT_NOTE records
338:
339: PROCEDURE crsp_ins_copn_rec (
340: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
341: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

Line 345: rowid , IGS_GE_NOTE.*

341: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
342: CURSOR Cur_SGN
343: IS
344: SELECT
345: rowid , IGS_GE_NOTE.*
346: FROM
347: IGS_GE_NOTE
348: WHERE
349: reference_number = gv_copn_rec.reference_number;

Line 347: IGS_GE_NOTE

343: IS
344: SELECT
345: rowid , IGS_GE_NOTE.*
346: FROM
347: IGS_GE_NOTE
348: WHERE
349: reference_number = gv_copn_rec.reference_number;
350: BEGIN
351: -- select the next reference_number from the system

Line 355: -- inserting IGS_GE_NOTE record with this next reference_number

351: -- select the next reference_number from the system
352: OPEN gc_ref_num;
353: FETCH gc_ref_num INTO gv_ref_num;
354: CLOSE gc_ref_num;
355: -- inserting IGS_GE_NOTE record with this next reference_number
356: -- Currently unable to copy Long Raw columns in PL/SQL.
357: FOR Rec_SGN IN Cur_SGN LOOP
358: x_rowid := NULL;
359: IGS_GE_NOTE_PKG.INSERT_ROW(

Line 359: IGS_GE_NOTE_PKG.INSERT_ROW(

355: -- inserting IGS_GE_NOTE record with this next reference_number
356: -- Currently unable to copy Long Raw columns in PL/SQL.
357: FOR Rec_SGN IN Cur_SGN LOOP
358: x_rowid := NULL;
359: IGS_GE_NOTE_PKG.INSERT_ROW(
360: X_ROWID => x_rowid,
361: X_REFERENCE_NUMBER => gv_ref_num,
362: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
363: X_NOTE_TEXT => Rec_SGN.note_text,

Line 392: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT records

388: ELSE
389: App_Exception.Raise_Exception;
390: END IF;
391: END crsp_ins_copn_rec;
392: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT records
393:
394: PROCEDURE crsp_ins_cop_rec (
395: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
396: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

Line 498: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_NOTE records

494: ELSE
495: App_Exception.Raise_Exception;
496: END IF;
497: END crsp_ins_cop_rec;
498: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_NOTE records
499: PROCEDURE crsp_ins_con_rec (
500: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
501: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
502: CURSOR

Line 506: rowid,IGS_GE_NOTE.*

502: CURSOR
503: Cur_SGN
504: IS
505: SELECT
506: rowid,IGS_GE_NOTE.*
507: FROM
508: IGS_GE_NOTE
509: WHERE
510: reference_number = gv_con_rec.reference_number;

Line 508: IGS_GE_NOTE

504: IS
505: SELECT
506: rowid,IGS_GE_NOTE.*
507: FROM
508: IGS_GE_NOTE
509: WHERE
510: reference_number = gv_con_rec.reference_number;
511:
512: BEGIN

Line 517: -- inserting IGS_GE_NOTE record with this next reference_number

513: -- select the next reference_number from the system
514: OPEN gc_ref_num;
515: FETCH gc_ref_num INTO gv_ref_num;
516: CLOSE gc_ref_num;
517: -- inserting IGS_GE_NOTE record with this next reference_number
518: -- Currently unable to copy Long Raw columns in PL/SQL.
519: For Rec_SGN IN Cur_SGN LOOP
520: x_rowid := NULL;
521: IGS_GE_NOTE_PKG.INSERT_ROW(

Line 521: IGS_GE_NOTE_PKG.INSERT_ROW(

517: -- inserting IGS_GE_NOTE record with this next reference_number
518: -- Currently unable to copy Long Raw columns in PL/SQL.
519: For Rec_SGN IN Cur_SGN LOOP
520: x_rowid := NULL;
521: IGS_GE_NOTE_PKG.INSERT_ROW(
522: X_ROWID => x_rowid,
523: X_REFERENCE_NUMBER => gv_ref_num,
524: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
525: X_NOTE_TEXT => Rec_SGN.note_text,

Line 1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records

1573: ELSE
1574: App_Exception.Raise_Exception;
1575: END IF;
1576: END crsp_ins_cal_rec;
1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records
1578: PROCEDURE crsp_ins_cvn_rec (
1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS

Line 1583: SELECT rowid,IGS_GE_NOTE.*

1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS
1582: CURSOR Cur_SGN IS
1583: SELECT rowid,IGS_GE_NOTE.*
1584: FROM IGS_GE_NOTE
1585: WHERE reference_number = gv_cvn_rec.reference_number;
1586: BEGIN
1587: -- select the next reference_number from the system

Line 1584: FROM IGS_GE_NOTE

1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS
1582: CURSOR Cur_SGN IS
1583: SELECT rowid,IGS_GE_NOTE.*
1584: FROM IGS_GE_NOTE
1585: WHERE reference_number = gv_cvn_rec.reference_number;
1586: BEGIN
1587: -- select the next reference_number from the system
1588: OPEN gc_ref_num;

Line 1591: -- inserting IGS_GE_NOTE record with this next reference_number

1587: -- select the next reference_number from the system
1588: OPEN gc_ref_num;
1589: FETCH gc_ref_num INTO gv_ref_num;
1590: CLOSE gc_ref_num;
1591: -- inserting IGS_GE_NOTE record with this next reference_number
1592: -- Currently unable to copy Long Raw columns in PL/SQL.
1593:
1594:
1595: FOR Rec_SGN IN Cur_SGN LOOP

Line 1597: IGS_GE_NOTE_PKG.INSERT_ROW(

1593:
1594:
1595: FOR Rec_SGN IN Cur_SGN LOOP
1596: x_rowid := NULL;
1597: IGS_GE_NOTE_PKG.INSERT_ROW(
1598: X_ROWID => X_ROWID,
1599: X_REFERENCE_NUMBER =>gv_ref_num,
1600: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
1601: X_NOTE_TEXT =>Rec_SGN.note_text,

Line 1879: -- If the insertion of a IGS_PS_COURSE IGS_GE_NOTE fails, the associated IGS_GE_NOTE is removed.

1875: -- exception handler is raised when an error number is found to be in the
1876: -- range -20000 to -20999 (which indicates that the exception is user
1877: -- defined - one of the validation routines within the system). If not
1878: -- within this range, it will be raised by standard exception handling.
1879: -- If the insertion of a IGS_PS_COURSE IGS_GE_NOTE fails, the associated IGS_GE_NOTE is removed.
1880: -- IGS_GE_NOTE: If any tables to be added, be careful to ensure relational integrity
1881: -- is preserved. Please check that all foreign keys are catered for.
1882: -- (For example, IGS_PS_OF_OPT_UNT_ST relies on
1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.

Line 1880: -- IGS_GE_NOTE: If any tables to be added, be careful to ensure relational integrity

1876: -- range -20000 to -20999 (which indicates that the exception is user
1877: -- defined - one of the validation routines within the system). If not
1878: -- within this range, it will be raised by standard exception handling.
1879: -- If the insertion of a IGS_PS_COURSE IGS_GE_NOTE fails, the associated IGS_GE_NOTE is removed.
1880: -- IGS_GE_NOTE: If any tables to be added, be careful to ensure relational integrity
1881: -- is preserved. Please check that all foreign keys are catered for.
1882: -- (For example, IGS_PS_OF_OPT_UNT_ST relies on
1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.
1884: -- Only then can the records be created for the new version provided

Line 2277: FROM igs_ps_unt_ofr_opt_n snote, igs_ge_note genote

2273:
2274: -- 18
2275: CURSOR c_unt_ofr_opt_n (cp_uoo_id NUMBER) IS
2276: SELECT snote.*, genote.s_note_format_type, genote.note_text
2277: FROM igs_ps_unt_ofr_opt_n snote, igs_ge_note genote
2278: WHERE uoo_id = cp_uoo_id
2279: AND snote.reference_number = geNote.reference_number;
2280:
2281: -- 19

Line 3663: --insert a record in the igs_ge_note table corresponding to the reference number create

3659:
3660: OPEN cur_c_unt_ofr_opt_n_new(p_new_uoo_id, c_unt_ofr_opt_n_rec.crs_note_type);
3661: FETCH cur_c_unt_ofr_opt_n_new INTO l_cur_c_unt_ofr_opt_n_new;
3662: IF cur_c_unt_ofr_opt_n_new%NOTFOUND THEN
3663: --insert a record in the igs_ge_note table corresponding to the reference number create
3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:

Line 3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;

3662: IF cur_c_unt_ofr_opt_n_new%NOTFOUND THEN
3663: --insert a record in the igs_ge_note table corresponding to the reference number create
3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:
3668: igs_ge_note_pkg.insert_row(
3669: x_rowid => lv_gerowid,
3670: x_reference_number => lnnote_ref_number ,

Line 3668: igs_ge_note_pkg.insert_row(

3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:
3668: igs_ge_note_pkg.insert_row(
3669: x_rowid => lv_gerowid,
3670: x_reference_number => lnnote_ref_number ,
3671: x_s_note_format_type => c_unt_ofr_opt_n_rec.s_note_format_type,
3672: x_note_text => c_unt_ofr_opt_n_rec.Note_text,