1 PACKAGE IGS_PE_GEN_003 AS
2 /* $Header: IGSPE18S.pls 120.3 2006/01/23 06:33:09 gmaheswa noship $ */
3 /*
4 || Created By : gmaheswa
5 || Created On : 2-NOV-2004
6 || Purpose : Created to process FA todo items in case of insert/update of housing status/residency status
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || gmaheswa 17-Jan-06 4938278: Added a procedure TURNOFF_TCA_BE to disable and enable business events in bulk import process.
11 || skpandey 18-AUG-2005 Bug#: 4378028
12 || Added procedure raise_person_type_event and resp_assignment to handle person type responsibility enhancements
13 || (reverse chronological order - newest change first)
14 */
15 PROCEDURE PROCESS_RES_DTLS(
16 P_ACTION IN VARCHAR2 , -- I/U I-INSERT U-UPDATE,
17 P_OLD_RECORD IN IGS_PE_RES_DTLS_ALL%ROWTYPE,
18 P_NEW_RECORD IN IGS_PE_RES_DTLS_ALL%ROWTYPE);
19
20 PROCEDURE PROCESS_HOUSING_DTLS(
21 P_ACTION IN VARCHAR2 , -- I/U I-INSERT U-UPDATE,
22 P_OLD_RECORD IN IGS_PE_TEACH_PERIODS_ALL%ROWTYPE,
23 P_NEW_RECORD IN IGS_PE_TEACH_PERIODS_ALL%ROWTYPE);
24
25 FUNCTION RESP_ASSIGNMENT(
26 P_SUBSCRIPTION_GUID IN RAW,
27 P_EVENT IN OUT NOCOPY WF_EVENT_T)
28 RETURN VARCHAR2;
29
30 PROCEDURE RAISE_PERSON_TYPE_EVENT(
31 p_person_id IN NUMBER,
32 p_person_type_code IN VARCHAR2,
33 p_action IN VARCHAR2,
34 p_end_date IN DATE DEFAULT NULL);
35
36 PROCEDURE TURNOFF_TCA_BE(
37 p_turnoff VARCHAR2
38 );
39 g_hz_api_callouts_profl VARCHAR2(30);
40
41 END IGS_PE_GEN_003;