APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_PAT

Line 82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;

78: gv_coo_rec IGS_PS_OFR_OPT%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;

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 86: gv_cop_seq_num IGS_PS_OFR_PAT.cop_id%TYPE;

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;
89: gv_cow_rec IGS_PS_OWN%ROWTYPE;
90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;

Line 260: FROM IGS_PS_OFR_PAT

256: coi.cal_type = gv_co_rec.cal_type
257: ORDER BY coi.ci_end_dt DESC, coi.ci_start_dt DESC;
258: CURSOR gc_cop_rec IS
259: SELECT *
260: FROM IGS_PS_OFR_PAT
261: WHERE course_cd = p_old_course_cd AND
262: version_number = p_old_version_number AND
263: cal_type = gv_coi_rec.cal_type AND
264: ci_sequence_number = gv_coi_rec.ci_sequence_number;

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 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 408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL

404: FROM IGS_AS_GRD_SCHEMA gs
405: WHERE gs.grading_schema_cd = cp_gs_cd;
406: BEGIN
407: -- select the next sequence_number from the system
408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL
409: INTO gv_cop_seq_num
410: FROM DUAL;
411: -- get the latest grading schema version number
412: OPEN c_latest_gs_version (

Line 437: -- inserting IGS_PS_OFR_PAT records with this next sequence_number

433: gv_cop_rec.adm_contact_person_id,
434: v_message_name) = FALSE THEN
435: gv_cop_rec.adm_contact_person_id := NULL;
436: END IF;
437: -- inserting IGS_PS_OFR_PAT records with this next sequence_number
438: x_rowid := NULL;
439: IGS_PS_OFR_PAT_PKG.INSERT_ROW(
440: X_ROWID => X_ROWID,
441: X_COURSE_CD => p_new_course_cd,

Line 439: IGS_PS_OFR_PAT_PKG.INSERT_ROW(

435: gv_cop_rec.adm_contact_person_id := NULL;
436: END IF;
437: -- inserting IGS_PS_OFR_PAT records with this next sequence_number
438: x_rowid := NULL;
439: IGS_PS_OFR_PAT_PKG.INSERT_ROW(
440: X_ROWID => X_ROWID,
441: X_COURSE_CD => p_new_course_cd,
442: X_CI_SEQUENCE_NUMBER => gv_cop_rec.ci_sequence_number,
443: X_CAL_TYPE => gv_cop_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;

Line 469: -- associated with each IGS_PS_OFR_PAT record

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;
473: IF gc_copn_rec%FOUND THEN

Line 867: -- calling procedure to insert IGS_PS_OFR_PAT records

863: X_CI_END_DT => gv_coi_rec.ci_end_dt,
864: X_MIN_ENTRY_ASS_SCORE => gv_coi_rec.min_entry_ass_score,
865: X_GUARANTEED_ENTRY_ASS_SCR => gv_coi_rec.guaranteed_entry_ass_scr,
866: X_MODE => 'R' );
867: -- calling procedure to insert IGS_PS_OFR_PAT records
868: -- associated with each IGS_PS_OFR instance record
869: OPEN gc_cop_rec;
870: LOOP
871: FETCH gc_cop_rec INTO gv_cop_rec;