APPS.IGS_CO_GEN_002 dependencies on IGS_CO_DTL

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 54: cp_correspondence_type IGS_CO_DTL.CORRESPONDENCE_TYPE%TYPE,

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(
54: cp_correspondence_type IGS_CO_DTL.CORRESPONDENCE_TYPE%TYPE,
55: cp_reference_number IGS_CO_DTL.reference_number%TYPE) IS
56: SELECT ROWID
57: FROM IGS_CO_DTL cd
58: WHERE cd.CORRESPONDENCE_TYPE = cp_correspondence_type

Line 55: cp_reference_number IGS_CO_DTL.reference_number%TYPE) IS

51: AND cdo.reference_number = cp_reference_number
52: FOR UPDATE OF cdo.CORRESPONDENCE_TYPE NOWAIT;
53: CURSOR c_cd(
54: cp_correspondence_type IGS_CO_DTL.CORRESPONDENCE_TYPE%TYPE,
55: cp_reference_number IGS_CO_DTL.reference_number%TYPE) IS
56: SELECT ROWID
57: FROM IGS_CO_DTL cd
58: WHERE cd.CORRESPONDENCE_TYPE = cp_correspondence_type
59: AND cd.reference_number = cp_reference_number

Line 57: FROM IGS_CO_DTL cd

53: CURSOR c_cd(
54: cp_correspondence_type IGS_CO_DTL.CORRESPONDENCE_TYPE%TYPE,
55: cp_reference_number IGS_CO_DTL.reference_number%TYPE) IS
56: SELECT ROWID
57: FROM IGS_CO_DTL cd
58: WHERE cd.CORRESPONDENCE_TYPE = cp_correspondence_type
59: AND cd.reference_number = cp_reference_number
60: FOR UPDATE OF cd.CORRESPONDENCE_TYPE NOWAIT;
61: CURSOR c_ocr(

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,

Line 177: -- delete any IGS_CO_DTL records for this IGS_CO_ITM

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,
180: p_reference_number) LOOP
181: IGS_CO_DTL_PKG.DELETE_ROW(X_ROWID=>vcd_rec.ROWID);

Line 181: IGS_CO_DTL_PKG.DELETE_ROW(X_ROWID=>vcd_rec.ROWID);

177: -- delete any IGS_CO_DTL records for this IGS_CO_ITM
178: FOR vcd_rec IN c_cd(
179: p_correspondence_type,
180: p_reference_number) LOOP
181: IGS_CO_DTL_PKG.DELETE_ROW(X_ROWID=>vcd_rec.ROWID);
182: END LOOP;
183: IF(p_letter_delete = 'Y') THEN
184: -- find related IGS_CO_S_PER_LTR records from IGS_CO_OU_CO_REF
185: FOR v_ocr_rec IN c_ocr(