DBA Data[Home] [Help]

APPS.IGS_CO_GEN_002 dependencies on IGS_CO_OU_CO

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

41: RETURN BOOLEAN ;
42: --
43:
44: PROCEDURE corp_get_ocv_details(
45: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
46: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,

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

43:
44: PROCEDURE corp_get_ocv_details(
45: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
46: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,

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

44: PROCEDURE corp_get_ocv_details(
45: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
46: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,

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

45: p_person_id IN OUT NOCOPY IGS_CO_OU_CO.person_id%TYPE ,
46: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,

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

46: p_correspondence_type IN OUT NOCOPY IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE ,
47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,

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

47: p_cal_type IN OUT NOCOPY IGS_CO_OU_CO_REF.CAL_TYPE%TYPE ,
48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,

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

48: p_ci_sequence_number IN OUT NOCOPY IGS_CO_OU_CO_REF.ci_sequence_number%TYPE,
49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,

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

49: p_course_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.course_cd%TYPE ,
50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
57: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,

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

50: p_cv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.cv_version_number%TYPE ,
51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
57: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,
58: p_s_job_name IN OUT NOCOPY IGS_CO_ITM.s_job_name%TYPE ,

Line 55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,

51: p_unit_cd IN OUT NOCOPY IGS_CO_OU_CO_REF.unit_cd%TYPE ,
52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
57: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,
58: p_s_job_name IN OUT NOCOPY IGS_CO_ITM.s_job_name%TYPE ,
59: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,

Line 56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,

52: p_uv_version_number IN OUT NOCOPY IGS_CO_OU_CO_REF.uv_version_number%TYPE ,
53: p_s_other_reference_type IN OUT NOCOPY IGS_CO_OU_CO_REF.S_OTHER_REFERENCE_TYPE%TYPE ,
54: p_other_reference IN OUT NOCOPY IGS_CO_OU_CO_REF.other_reference%TYPE ,
55: p_addr_type IN OUT NOCOPY IGS_CO_OU_CO.ADDR_TYPE%TYPE ,
56: p_tracking_id IN OUT NOCOPY IGS_CO_OU_CO.tracking_id%TYPE ,
57: p_request_num IN OUT NOCOPY IGS_CO_ITM.request_num%TYPE ,
58: p_s_job_name IN OUT NOCOPY IGS_CO_ITM.s_job_name%TYPE ,
59: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,
60: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,

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

59: p_request_job_id IN OUT NOCOPY IGS_CO_ITM.request_job_id%TYPE ,
60: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,
61: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
62: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
63: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
64: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
65: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
66: p_adt_description OUT NOCOPY varchar2,
67: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,

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

60: p_request_job_run_id IN OUT NOCOPY IGS_CO_ITM.request_job_run_id%TYPE,
61: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
62: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
63: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
64: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
65: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
66: p_adt_description OUT NOCOPY varchar2,
67: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
68: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,

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

61: p_correspondence_cat OUT NOCOPY VARCHAR2 ,
62: p_reference_number OUT NOCOPY IGS_CO_ITM.reference_number%TYPE ,
63: p_issue_dt OUT NOCOPY IGS_CO_OU_CO.issue_dt%TYPE ,
64: p_dt_sent OUT NOCOPY IGS_CO_OU_CO.dt_sent%TYPE ,
65: p_unknown_return_dt OUT NOCOPY IGS_CO_OU_CO.unknown_return_dt%TYPE ,
66: p_adt_description OUT NOCOPY varchar2,
67: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
68: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,
69: p_output_num OUT NOCOPY IGS_CO_ITM.output_num%TYPE ,

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

66: p_adt_description OUT NOCOPY varchar2,
67: p_create_dt OUT NOCOPY IGS_CO_ITM.create_dt%TYPE ,
68: p_originator_person_id OUT NOCOPY IGS_CO_ITM.originator_person_id%TYPE ,
69: p_output_num OUT NOCOPY IGS_CO_ITM.output_num%TYPE ,
70: p_oc_comments OUT NOCOPY IGS_CO_OU_CO.comments%TYPE ,
71: p_cori_comments OUT NOCOPY IGS_CO_ITM.comments%TYPE ,
72: p_message_name OUT NOCOPY varchar2 );
73: --
74: END IGS_CO_GEN_002;