APPS.IGS_PS_GEN_001 dependencies on IGS_PS_VER_NOTE

Line 90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;

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;
91: gv_ae_rec IGS_PE_ALTERNATV_EXT%ROWTYPE;
92: gv_cgm_rec IGS_PS_GRP_MBR%ROWTYPE;
93: gv_fsr_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;
94: gv_cfos_rec IGS_PS_FIELD_STUDY%ROWTYPE;

Line 150: FROM IGS_PS_VER_NOTE cvn

146: -- Only interested in notes that are not OLE type as
147: -- currently unable to copy long raw field within PL/SQL
148: CURSOR gc_cvn_rec IS
149: SELECT *
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

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 1604: -- inserting new IGS_PS_VER_NOTE records

1600: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
1601: X_NOTE_TEXT =>Rec_SGN.note_text,
1602: X_MODE =>'R');
1603: END LOOP;
1604: -- inserting new IGS_PS_VER_NOTE records
1605: x_rowid := NULL;
1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(
1607: X_ROWID => x_rowid,
1608: X_COURSE_CD => p_new_course_cd,

Line 1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(

1602: X_MODE =>'R');
1603: END LOOP;
1604: -- inserting new IGS_PS_VER_NOTE records
1605: x_rowid := NULL;
1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(
1607: X_ROWID => x_rowid,
1608: X_COURSE_CD => p_new_course_cd,
1609: X_VERSION_NUMBER => p_new_version_number,
1610: X_REFERENCE_NUMBER => gv_ref_num,

Line 2008: -- calling procedure to insert IGS_PS_VER_NOTE records

2004: EXIT;
2005: END IF;
2006: END LOOP;
2007: CLOSE gc_cal_rec;
2008: -- calling procedure to insert IGS_PS_VER_NOTE records
2009: OPEN gc_cvn_rec;
2010: LOOP
2011: FETCH gc_cvn_rec INTO gv_cvn_rec;
2012: IF gc_cvn_rec%FOUND THEN