APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_OPT_NOTE

Line 76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;

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;
80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;

Line 237: FROM IGS_PS_OFR_OPT_NOTE coon

233: -- Only interested in notes that are not OLE type as
234: -- currently unable to copy long raw field within PL/SQL
235: CURSOR gc_coon_rec IS
236: SELECT *
237: FROM IGS_PS_OFR_OPT_NOTE coon
238: WHERE coon.course_cd = p_old_course_cd AND
239: coon.version_number = p_old_version_number AND
240: coon.cal_type = gv_coo_rec.cal_type AND
241: coon.location_cd = gv_coo_rec.location_cd AND

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 313: -- inserting IGS_PS_OFR_OPT_NOTE records

309: X_MODE =>'R');
310: End Loop;
311:
312:
313: -- inserting IGS_PS_OFR_OPT_NOTE records
314: x_rowid := NULL;
315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(
316: X_ROWID => X_ROWID,
317: X_COURSE_CD => p_new_course_cd,

Line 315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(

311:
312:
313: -- inserting IGS_PS_OFR_OPT_NOTE records
314: x_rowid := NULL;
315: IGS_PS_OFR_OPT_NOTE_PKG.INSERT_ROW(
316: X_ROWID => X_ROWID,
317: X_COURSE_CD => p_new_course_cd,
318: X_VERSION_NUMBER => p_new_version_number,
319: X_CAL_TYPE => gv_coon_rec.cal_type,

Line 765: -- calling procedure to insert IGS_PS_OFR_OPT_NOTE records

761: X_ORG_ID => l_org_id ,
762: x_program_length => gv_coo_rec.program_length, --added as per bug# 2608227
763: x_program_length_measurement => gv_coo_rec.program_length_measurement --added as per bug# 2608227
764: );
765: -- calling procedure to insert IGS_PS_OFR_OPT_NOTE records
766: -- associated with each IGS_PS_OFR_OPT record
767: OPEN gc_coon_rec;
768: LOOP
769: FETCH gc_coon_rec INTO gv_coon_rec;