1 PACKAGE IGS_CO_GEN_002 AS
2 /* $Header: IGSCO02S.pls 120.1 2005/09/08 16:24:33 appldev noship $ */
3 PROCEDURE CORP_UPD_OC_DT_SENT(
4 errbuf out NOCOPY varchar2,
5 retcode out NOCOPY varchar2,
6 p_reference_number IN NUMBER ,
7 p_person_id IN NUMBER ,
8 p_issue_dt_c IN VARCHAR2 ,
9 p_dt_sent_c IN VARCHAR2 );
10 --
11 FUNCTION CORP_DEL_CORI_SPL(
12 p_correspondence_type IN VARCHAR2 ,
13 p_reference_number IN NUMBER ,
14 p_letter_delete IN VARCHAR2 DEFAULT 'N',
15 p_message_name OUT NOCOPY varchar2 )
16 RETURN BOOLEAN ;
17 --
18 FUNCTION CORP_INS_SPLP(
19 p_person_id IN NUMBER ,
20 p_correspondence_type IN VARCHAR2 ,
21 p_letter_reference_number IN NUMBER ,
22 p_spl_sequence_number IN NUMBER ,
23 p_letter_parameter_type IN VARCHAR2 ,
24 p_letter_repeating_group_cd IN VARCHAR2 ,
25 p_splrg_sequence_number IN NUMBER ,
26 p_record_number IN NUMBER ,
27 p_letter_context_parameter IN VARCHAR2 ,
28 p_extra_context OUT NOCOPY VARCHAR2 ,
29 p_stored_ind OUT NOCOPY VARCHAR2 ,
30 p_message_name OUT NOCOPY varchar2,
31 p_letter_order_number IN NUMBER)
32 RETURN BOOLEAN ;
33 --
34 FUNCTION CORP_INS_SPL_DETAIL(
35 p_person_id IN NUMBER ,
36 p_correspondence_type IN VARCHAR2 ,
37 p_letter_reference_number IN NUMBER ,
38 p_letter_context_parameter IN VARCHAR2 ,
39 p_spl_sequence_number OUT NOCOPY NUMBER ,
40 p_message_name OUT NOCOPY varchar2 )
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 ,
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 ,
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 ,
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;