APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_NOTE

Line 75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;

71: cst_ret_message_name CONSTANT VARCHAR2(30) := 'IGS_PS_FAIL_COPY_PRGVER_DETAI';
72: cst_max_error_range CONSTANT NUMBER := -20999;
73: cst_min_error_range CONSTANT NUMBER := -20000;
74: gv_cv_rec IGS_PS_VER%ROWTYPE;
75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;
76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;
77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;
79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;

Line 225: FROM IGS_PS_OFR_NOTE con

221: -- Only interested in notes that are not OLE type as
222: -- currently unable to copy long raw field within PL/SQL
223: CURSOR gc_con_rec IS
224: SELECT *
225: FROM IGS_PS_OFR_NOTE con
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

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 529: -- inserting IGS_PS_OFR_NOTE records

525: X_NOTE_TEXT => Rec_SGN.note_text,
526: X_MODE => 'R'
527: );
528: END LOOP;
529: -- inserting IGS_PS_OFR_NOTE records
530: x_rowid := NULL;
531: IGS_PS_OFR_NOTE_PKG.INSERT_ROW (
532: X_ROWID => x_rowid,
533: X_COURSE_CD => p_new_course_cd,

Line 531: IGS_PS_OFR_NOTE_PKG.INSERT_ROW (

527: );
528: END LOOP;
529: -- inserting IGS_PS_OFR_NOTE records
530: x_rowid := NULL;
531: IGS_PS_OFR_NOTE_PKG.INSERT_ROW (
532: X_ROWID => x_rowid,
533: X_COURSE_CD => p_new_course_cd,
534: X_REFERENCE_NUMBER => gv_ref_num,
535: X_CAL_TYPE => gv_con_rec.cal_type,

Line 1263: -- calling procedure to insert IGS_PS_OFR_NOTE records

1259: -- if found, only the latest one needs to be copied over.
1260: crsp_ins_coi_rec(p_new_course_cd, p_new_version_number);
1261: END IF;
1262: CLOSE gc_coi_rec;
1263: -- calling procedure to insert IGS_PS_OFR_NOTE records
1264: -- associated with each IGS_PS_OFR record
1265: OPEN gc_con_rec;
1266: LOOP
1267: FETCH gc_con_rec INTO gv_con_rec;