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

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 121: cp_correspondence_type IGS_CO_OU_CO.CORRESPONDENCE_TYPE%TYPE,

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(
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

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 124: FROM IGS_CO_OU_CO oc

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
127: FOR UPDATE OF oc.CORRESPONDENCE_TYPE NOWAIT;
128: CURSOR c_cit(

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 240: IGS_CO_OU_CO_PKG.DELETE_ROW(X_ROWID=>v_oc_rec.ROWID);

236: -- delete all the outgoing correspondence records for this correspondence item.
237: FOR v_oc_rec IN c_oc(
238: p_correspondence_type,
239: p_reference_number) LOOP
240: IGS_CO_OU_CO_PKG.DELETE_ROW(X_ROWID=>v_oc_rec.ROWID);
241: END LOOP;
242: -- delete correspondence item
243: FOR v_cit_rec IN c_cit(
244: p_correspondence_type,

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 575: cp_person_id IGS_CO_OU_CO.person_id%TYPE,

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 ,
579: oc.CORRESPONDENCE_TYPE,

Line 576: cp_issue_dt IGS_CO_OU_CO.issue_dt%TYPE) IS

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 ,
579: oc.CORRESPONDENCE_TYPE,
580: oc.REFERENCE_NUMBER,

Line 589: FROM IGS_CO_OU_CO oc

585: oc.TRACKING_ID,
586: oc.COMMENTS,
587: oc.LETTER_REFERENCE_NUMBER ,
588: oc.SPL_SEQUENCE_NUMBER
589: FROM IGS_CO_OU_CO oc
590: WHERE oc.reference_number = cp_reference_number AND
591: ((oc.person_id = cp_person_id AND
592: (cp_person_id IS NOT NULL OR cp_person_id <> 0)) OR
593: (cp_person_id IS NULL OR cp_person_id = 0))AND

Line 617: IGS_CO_OU_CO_PKG.update_row(

613: p_reference_number,
614: p_person_id,
615: p_issue_dt) LOOP
616: v_record_found := TRUE;
617: IGS_CO_OU_CO_PKG.update_row(
618: X_ROWID => v_outgoing_correspondence_rec.ROWID,
619: X_PERSON_ID =>v_outgoing_correspondence_rec.PERSON_ID ,
620: X_CORRESPONDENCE_TYPE =>v_outgoing_correspondence_rec.CORRESPONDENCE_TYPE,
621: X_REFERENCE_NUMBER => v_outgoing_correspondence_rec.REFERENCE_NUMBER,

Line 653: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,

649: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
650: END corp_upd_oc_dt_sent;
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 ,

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 ,

Line 663: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%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 ,
667: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,

Line 664: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%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 ,
667: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,
668: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,

Line 671: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,

667: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,
668: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,
669: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
670: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
671: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
672: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
673: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
674: p_adt_description OUT NOCOPY varchar2,
675: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,

Line 672: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,

668: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,
669: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
670: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
671: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
672: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
673: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
674: p_adt_description OUT NOCOPY varchar2,
675: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
676: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,

Line 673: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,

669: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
670: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
671: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
672: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
673: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
674: p_adt_description OUT NOCOPY varchar2,
675: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
676: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,
677: p_output_num OUT NOCOPY IGS_CO_ITM.output_num%TYPE ,

Line 678: p_oc_comments OUT NOCOPY IGS_CO_OU_CO.comments%TYPE ,

674: p_adt_description OUT NOCOPY varchar2,
675: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
676: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,
677: p_output_num OUT NOCOPY IGS_CO_ITM.output_num%TYPE ,
678: p_oc_comments OUT NOCOPY IGS_CO_OU_CO.comments%TYPE ,
679: p_cori_comments OUT NOCOPY IGS_CO_ITM.comments%TYPE ,
680: p_message_name OUT NOCOPY varchar2 )
681: AS
682: BEGIN -- corp_get_ocv_details

Line 714: FROM IGS_CO_OU_CO_V

710: originator_person_id,
711: output_num,
712: oc_comments,
713: cori_comments
714: FROM IGS_CO_OU_CO_V
715: WHERE (p_person_id IS NULL OR
716: person_id = p_person_id) AND
717: (p_correspondence_type IS NULL OR
718: CORRESPONDENCE_TYPE = p_correspondence_type) AND