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_ITM

Line 32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,

28: v_spl_sequence_number NUMBER(10);
29: v_dummy VARCHAR2(1);
30: v_sys_generated_ind IGS_CO_TYPE.sys_generated_ind%TYPE;
31: CURSOR c_corit(
32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
34: SELECT cort.sys_generated_ind
35: FROM IGS_CO_ITM cori,
36: IGS_CO_TYPE cort

Line 33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS

29: v_dummy VARCHAR2(1);
30: v_sys_generated_ind IGS_CO_TYPE.sys_generated_ind%TYPE;
31: CURSOR c_corit(
32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
34: SELECT cort.sys_generated_ind
35: FROM IGS_CO_ITM cori,
36: IGS_CO_TYPE cort
37: WHERE cori.CORRESPONDENCE_TYPE = cp_correspondence_type

Line 35: FROM IGS_CO_ITM cori,

31: CURSOR c_corit(
32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
34: SELECT cort.sys_generated_ind
35: FROM IGS_CO_ITM cori,
36: IGS_CO_TYPE cort
37: WHERE cori.CORRESPONDENCE_TYPE = cp_correspondence_type
38: AND cori.reference_number = cp_reference_number
39: AND cort.CORRESPONDENCE_TYPE = cori.CORRESPONDENCE_TYPE;

Line 41: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE) IS

37: WHERE cori.CORRESPONDENCE_TYPE = cp_correspondence_type
38: AND cori.reference_number = cp_reference_number
39: AND cort.CORRESPONDENCE_TYPE = cori.CORRESPONDENCE_TYPE;
40: CURSOR c_sl(
41: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE) IS
42: SELECT 'x'
43: FROM IGS_CO_S_LTR sl
44: WHERE sl.CORRESPONDENCE_TYPE = cp_correspondence_type;
45: CURSOR c_cdo(

Line 129: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,

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(
129: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
130: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
131: SELECT ROWID
132: FROM IGS_CO_ITM cit
133: WHERE cit.CORRESPONDENCE_TYPE = cp_correspondence_type

Line 130: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS

126: AND oc.reference_number = cp_reference_number
127: FOR UPDATE OF oc.CORRESPONDENCE_TYPE NOWAIT;
128: CURSOR c_cit(
129: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
130: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
131: SELECT ROWID
132: FROM IGS_CO_ITM cit
133: WHERE cit.CORRESPONDENCE_TYPE = cp_correspondence_type
134: AND cit.reference_number = cp_reference_number

Line 132: FROM IGS_CO_ITM cit

128: CURSOR c_cit(
129: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
130: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
131: SELECT ROWID
132: FROM IGS_CO_ITM cit
133: WHERE cit.CORRESPONDENCE_TYPE = cp_correspondence_type
134: AND cit.reference_number = cp_reference_number
135: FOR UPDATE OF cit.CORRESPONDENCE_TYPE NOWAIT;
136:

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 246: IGS_CO_ITM_PKG.DELETE_ROW(X_ROWID=>v_cit_rec.ROWID);

242: -- delete correspondence item
243: FOR v_cit_rec IN c_cit(
244: p_correspondence_type,
245: p_reference_number) LOOP
246: IGS_CO_ITM_PKG.DELETE_ROW(X_ROWID=>v_cit_rec.ROWID);
247: END LOOP;
248: COMMIT;
249: RETURN TRUE;
250: END;

Line 654: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,

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 ,
658: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,

Line 665: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%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,
669: p_correspondence_cat OUT NOCOPY VARCHAR2 ,

Line 666: p_s_job_name IN OUT NOCOPY IGS_CO_ITM.s_job_name%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,
669: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
670: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,

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

Line 668: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%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,
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 ,

Line 670: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%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,
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,

Line 675: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%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 ,
678: p_oc_comments OUT NOCOPY IGS_CO_OU_CO.comments%TYPE ,
679: p_cori_comments OUT NOCOPY IGS_CO_ITM.comments%TYPE ,

Line 676: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%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 ,
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 )

Line 677: p_output_num OUT NOCOPY IGS_CO_ITM.output_num%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 ,
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

Line 679: p_cori_comments OUT NOCOPY IGS_CO_ITM.comments%TYPE ,

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
683: -- This module gets information from the latest record in the outgoing