1 PACKAGE igs_pe_wf_gen AS
2 /* $Header: IGSPE07S.pls 120.4 2006/05/26 05:39:17 vskumar ship $ */
3
4 /******************************************************************
5 Created By : Vinay Chappidi
6 Date Created By : 20-Sep-2001
7 Purpose : Workflow General package for Person Module
8 remarks :
9 Change History
10 Who When What
11 sarakshi 23-Jan-2006 Bug#4938278, created TYPE t_addr_chg_persons and three procedures process_addr_sync,write_addr_sync_message and addr_bulk_synchronization
12 asbala 1-SEP-03 Created procedures get_res_details and process_residency and modified change_residence
13 gmaheswa 1-Nov-2004 Created a procedure change_housing_status for raising an event in case of insert/update of housing status
14 pkpatel 9-Nov-2004 Bug 3993967 (Modified signature of procedure CHANGE_RESIDENCE)
15 pkpatel 19=Sep-2005 Bug 4618459 (Removed the reference of HZ_PARAM_TAB. Commented the procedure get_address_dtls.
16 gmaheswa 17-Jan-20076 Bug 4938278: Removed comments code.
17 vskumar 24-May-2006 Bug 5211157 Added two procdeures specs raise_acad_intent_event and process_acad_intent
18 ******************************************************************/
19
20 TYPE t_addr_chg_persons IS TABLE OF hz_parties.party_id%TYPE INDEX BY PLS_INTEGER;
21 ti_addr_chg_persons t_addr_chg_persons;
22
23
24 PROCEDURE change_residence(p_resident_details_id IN NUMBER,
25 p_old_res_status IN VARCHAR2,
26 p_old_evaluator IN VARCHAR2,
27 p_old_evaluation_date IN VARCHAR2,
28 p_old_comment IN VARCHAR2,
29 p_action IN VARCHAR2);
30
31 PROCEDURE change_address ( p_person_number IN VARCHAR2, p_full_name IN VARCHAR2);
32
33 PROCEDURE get_res_details( p_person_id IN NUMBER, p_res_class IN VARCHAR2,
34 p_res_dtls_rec OUT NOCOPY igs_pe_res_dtls_v%ROWTYPE,
35 p_ind IN VARCHAR2 DEFAULT 'NEW');
36
37 PROCEDURE process_residency(itemtype IN VARCHAR2, itemkey IN VARCHAR2, actid IN NUMBER,
38 funcmode IN VARCHAR2, resultout OUT NOCOPY VARCHAR2);
39
40 PROCEDURE address_create(itemtype IN VARCHAR2, itemkey IN VARCHAR2, actid IN NUMBER,
41 funcmode IN VARCHAR2, resultout OUT NOCOPY VARCHAR2);
42
43 PROCEDURE address_update(itemtype IN VARCHAR2, itemkey IN VARCHAR2, actid IN NUMBER,
44 funcmode IN VARCHAR2, resultout OUT NOCOPY VARCHAR2);
45
46 PROCEDURE primary_address_ind_update(itemtype IN VARCHAR2, itemkey IN VARCHAR2, actid IN NUMBER,
47 funcmode IN VARCHAR2, resultout OUT NOCOPY VARCHAR2);
48
49 PROCEDURE change_housing_status(p_person_id IN NUMBER,
50 p_housing_status IN VARCHAR2,
51 P_CALENDER_TYPE IN VARCHAR2,
52 P_CAL_SEQ_NUM IN NUMBER,
53 P_TEACHING_PERIOD_ID IN NUMBER,
54 P_ACTION IN VARCHAR2 );
55
56 PROCEDURE process_addr_sync(itemtype in varchar2,
57 itemkey in varchar2,
58 actid in number,
59 funcmode in varchar2,
60 resultout out NOCOPY varchar2
61 );
62
63 PROCEDURE write_addr_sync_message(document_id IN VARCHAR2,
64 display_type IN VARCHAR2,
65 document IN OUT NOCOPY CLOB,
66 document_type IN OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE addr_bulk_synchronization (p_persons_processes IN OUT NOCOPY t_addr_chg_persons);
70
71 PROCEDURE raise_acad_intent_event(P_ACAD_INTENT_ID IN NUMBER,
72 P_PERSON_ID IN NUMBER,
73 P_CAL_TYPE IN VARCHAR2,
74 P_CAL_SEQ_NUMBER IN NUMBER,
75 P_ACAD_INTENT_CODE IN VARCHAR2,
76 P_OLD_ACAD_INTENT_CODE IN VARCHAR2 );
77
78 PROCEDURE process_acad_intent(itemtype IN VARCHAR2, itemkey IN VARCHAR2, actid IN NUMBER,
79 funcmode IN VARCHAR2, resultout OUT NOCOPY VARCHAR2);
80
81 END igs_pe_wf_gen;