eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_GEN_002 dependencies on IGS_CO_OU_CO_REF

Line 62: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,

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(
62: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,
63: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
64: SELECT ocr.rowid,
65: ocr.other_reference,
66: ocr.person_id

Line 63: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS

59: AND cd.reference_number = cp_reference_number
60: FOR UPDATE OF cd.CORRESPONDENCE_TYPE NOWAIT;
61: CURSOR c_ocr(
62: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,
63: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
64: SELECT ocr.rowid,
65: ocr.other_reference,
66: ocr.person_id
67: FROM IGS_CO_OU_CO_REF ocr

Line 67: FROM IGS_CO_OU_CO_REF ocr

63: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
64: SELECT ocr.rowid,
65: ocr.other_reference,
66: ocr.person_id
67: FROM IGS_CO_OU_CO_REF ocr
68: WHERE ocr.CORRESPONDENCE_TYPE = cp_correspondence_type
69: AND ocr.reference_number = cp_reference_number
70: AND ocr.S_OTHER_REFERENCE_TYPE = cst_spl_seqnum
71: FOR UPDATE OF ocr.other_reference NOWAIT;

Line 113: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,

109: WHERE aal.spl_sequence_number = cp_sequence_number
110: AND aal.person_id = cp_person_id
111: FOR UPDATE OF aal.letter_reference_number, aal.spl_sequence_number NOWAIT;
112: CURSOR c_ocr_1(
113: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,
114: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
115: SELECT ROWID
116: FROM IGS_CO_OU_CO_REF ocr
117: WHERE ocr.CORRESPONDENCE_TYPE = cp_correspondence_type

Line 114: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS

110: AND aal.person_id = cp_person_id
111: FOR UPDATE OF aal.letter_reference_number, aal.spl_sequence_number NOWAIT;
112: CURSOR c_ocr_1(
113: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,
114: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
115: SELECT ROWID
116: FROM IGS_CO_OU_CO_REF ocr
117: WHERE ocr.CORRESPONDENCE_TYPE = cp_correspondence_type
118: AND ocr.reference_number = cp_reference_number

Line 116: FROM IGS_CO_OU_CO_REF ocr

112: CURSOR c_ocr_1(
113: cp_correspondence_type IGS_CO_OU_CO_REF.CORRESPONDENCE_TYPE%TYPE,
114: cp_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE) IS
115: SELECT ROWID
116: FROM IGS_CO_OU_CO_REF ocr
117: WHERE ocr.CORRESPONDENCE_TYPE = cp_correspondence_type
118: AND ocr.reference_number = cp_reference_number
119: FOR UPDATE OF ocr.CORRESPONDENCE_TYPE NOWAIT;
120: CURSOR c_oc(

Line 122: cp_reference_number IGS_CO_OU_CO.reference_number%TYPE) IS

118: AND ocr.reference_number = cp_reference_number
119: FOR UPDATE OF ocr.CORRESPONDENCE_TYPE NOWAIT;
120: CURSOR c_oc(
121: cp_correspondence_type IGS_CO_OU_CO.CORRESPONDENCE_TYPE%TYPE,
122: cp_reference_number IGS_CO_OU_CO.reference_number%TYPE) IS
123: SELECT ROWID
124: FROM IGS_CO_OU_CO oc
125: WHERE oc.CORRESPONDENCE_TYPE = cp_correspondence_type
126: AND oc.reference_number = cp_reference_number

Line 184: -- find related IGS_CO_S_PER_LTR records from IGS_CO_OU_CO_REF

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(
186: p_correspondence_type,
187: p_reference_number) LOOP
188: v_spl_sequence_number := TO_NUMBER(v_ocr_rec.other_reference);

Line 225: -- delete current IGS_CO_OU_CO_REF record

221: END LOOP;
222: -- delete the IGS_CO_S_PER_LTR record
223: IGS_CO_S_PER_LTR_PKG.DELETE_ROW(X_ROWID => v_spl_rec.rowid);
224: END LOOP;
225: -- delete current IGS_CO_OU_CO_REF record
226: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID => v_ocr_rec.ROWID );
227: END LOOP;
228: ELSE -- p_letter_delete = 'N'
229: -- delete all the out NOCOPY correspondence ref records for this correspondence item

Line 226: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID => v_ocr_rec.ROWID );

222: -- delete the IGS_CO_S_PER_LTR record
223: IGS_CO_S_PER_LTR_PKG.DELETE_ROW(X_ROWID => v_spl_rec.rowid);
224: END LOOP;
225: -- delete current IGS_CO_OU_CO_REF record
226: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID => v_ocr_rec.ROWID );
227: END LOOP;
228: ELSE -- p_letter_delete = 'N'
229: -- delete all the out NOCOPY correspondence ref records for this correspondence item
230: FOR v_ocr_1_rec IN c_ocr_1(

Line 233: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID=>v_ocr_1_rec.ROWID);

229: -- delete all the out NOCOPY correspondence ref records for this correspondence item
230: FOR v_ocr_1_rec IN c_ocr_1(
231: p_correspondence_type,
232: p_reference_number) LOOP
233: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID=>v_ocr_1_rec.ROWID);
234: END LOOP;
235: END IF;
236: -- delete all the outgoing correspondence records for this correspondence item.
237: FOR v_oc_rec IN c_oc(

Line 574: cp_reference_number IGS_CO_OU_CO.reference_number%TYPE,

570: e_no_records_found EXCEPTION;
571: e_resource_busy EXCEPTION;
572: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
573: CURSOR c_outgoing_correspondence (
574: cp_reference_number IGS_CO_OU_CO.reference_number%TYPE,
575: cp_person_id IGS_CO_OU_CO.person_id%TYPE,
576: cp_issue_dt IGS_CO_OU_CO.issue_dt%TYPE) IS
577: SELECT oc.ROWID,
578: oc.PERSON_ID ,

Line 655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,

651: --
652: PROCEDURE corp_get_ocv_details(
653: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
654: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,

Line 656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,

652: PROCEDURE corp_get_ocv_details(
653: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
654: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,

Line 657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,

653: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
654: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,

Line 658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,

654: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,

Line 659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,

655: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
663: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,

Line 660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,

656: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
663: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
664: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,

Line 661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,

657: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
663: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
664: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
665: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,

Line 662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,

658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
659: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
660: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
661: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
662: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
663: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
664: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
665: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,
666: p_s_job_name IN OUT NOCOPY IGS_CO_ITM.s_job_name%TYPE ,