APPS.IGS_CO_GEN_002 dependencies on IGS_CO_DTL_OLE

Line 46: cp_correspondence_type IGS_CO_DTL_OLE.CORRESPONDENCE_TYPE%TYPE,

42: SELECT 'x'
43: FROM IGS_CO_S_LTR sl
44: WHERE sl.CORRESPONDENCE_TYPE = cp_correspondence_type;
45: CURSOR c_cdo(
46: cp_correspondence_type IGS_CO_DTL_OLE.CORRESPONDENCE_TYPE%TYPE,
47: cp_reference_number IGS_CO_DTL_OLE.reference_number%TYPE) IS
48: SELECT ROWID
49: FROM IGS_CO_DTL_OLE cdo
50: WHERE cdo.CORRESPONDENCE_TYPE = cp_correspondence_type

Line 47: cp_reference_number IGS_CO_DTL_OLE.reference_number%TYPE) IS

43: FROM IGS_CO_S_LTR sl
44: WHERE sl.CORRESPONDENCE_TYPE = cp_correspondence_type;
45: CURSOR c_cdo(
46: cp_correspondence_type IGS_CO_DTL_OLE.CORRESPONDENCE_TYPE%TYPE,
47: cp_reference_number IGS_CO_DTL_OLE.reference_number%TYPE) IS
48: SELECT ROWID
49: FROM IGS_CO_DTL_OLE cdo
50: WHERE cdo.CORRESPONDENCE_TYPE = cp_correspondence_type
51: AND cdo.reference_number = cp_reference_number

Line 49: FROM IGS_CO_DTL_OLE cdo

45: CURSOR c_cdo(
46: cp_correspondence_type IGS_CO_DTL_OLE.CORRESPONDENCE_TYPE%TYPE,
47: cp_reference_number IGS_CO_DTL_OLE.reference_number%TYPE) IS
48: SELECT ROWID
49: FROM IGS_CO_DTL_OLE cdo
50: WHERE cdo.CORRESPONDENCE_TYPE = cp_correspondence_type
51: AND cdo.reference_number = cp_reference_number
52: FOR UPDATE OF cdo.CORRESPONDENCE_TYPE NOWAIT;
53: CURSOR c_cd(

Line 171: -- delete any IGS_CO_DTL_OLE records for this correspondence item

167: RETURN FALSE;
168: END IF;
169: CLOSE c_sl;
170: END IF;
171: -- delete any IGS_CO_DTL_OLE records for this correspondence item
172: FOR v_cdo_rec IN c_cdo(
173: p_correspondence_type,
174: p_reference_number) LOOP
175: IGS_CO_DTL_OLE_PKG.DELETE_ROW(X_ROWID=>v_cdo_rec.ROWID);

Line 175: IGS_CO_DTL_OLE_PKG.DELETE_ROW(X_ROWID=>v_cdo_rec.ROWID);

171: -- delete any IGS_CO_DTL_OLE records for this correspondence item
172: FOR v_cdo_rec IN c_cdo(
173: p_correspondence_type,
174: p_reference_number) LOOP
175: IGS_CO_DTL_OLE_PKG.DELETE_ROW(X_ROWID=>v_cdo_rec.ROWID);
176: END LOOP;
177: -- delete any IGS_CO_DTL records for this IGS_CO_ITM
178: FOR vcd_rec IN c_cd(
179: p_correspondence_type,