APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_PAT_NOTE

Line 83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;

79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;
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;

Line 269: FROM IGS_PS_OFR_PAT_NOTE cop

265: -- Only interested in notes that are not OLE type as
266: -- currently unable to copy long raw field within PL/SQL
267: CURSOR gc_copn_rec IS
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

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 368: -- inserting IGS_PS_OFR_PAT_NOTE records

364: X_MODE => 'R'
365: );
366: END LOOP;
367:
368: -- inserting IGS_PS_OFR_PAT_NOTE records
369: x_rowid := NULL;
370: IGS_PS_OFR_PAT_NOTE_PKG.INSERT_ROW(
371: X_ROWID => x_rowid,
372: X_COURSE_CD => p_new_course_cd,

Line 370: IGS_PS_OFR_PAT_NOTE_PKG.INSERT_ROW(

366: END LOOP;
367:
368: -- inserting IGS_PS_OFR_PAT_NOTE records
369: x_rowid := NULL;
370: IGS_PS_OFR_PAT_NOTE_PKG.INSERT_ROW(
371: X_ROWID => x_rowid,
372: X_COURSE_CD => p_new_course_cd,
373: X_CI_SEQUENCE_NUMBER => gv_copn_rec.ci_sequence_number,
374: X_CAL_TYPE => gv_copn_rec.cal_type,

Line 468: -- calling procedure to insert IGS_PS_OFR_PAT_NOTE records

464: X_GRADING_SCHEMA_CD => gv_cop_rec.grading_schema_cd,
465: X_GS_VERSION_NUMBER => gv_cop_rec.gs_version_number,
466: X_MODE => 'R'
467: );
468: -- calling procedure to insert IGS_PS_OFR_PAT_NOTE records
469: -- associated with each IGS_PS_OFR_PAT record
470: OPEN gc_copn_rec;
471: LOOP
472: FETCH gc_copn_rec INTO gv_copn_rec;