1 PACKAGE Igs_Ad_Imp_002 AS
2 /* $Header: IGSAD80S.pls 120.1 2006/02/06 02:07:43 gmaheswa noship $ */
3
4 /*
5 || Created By : nsinha
6 || Created On : 22-JUN-2001
7 || Purpose : This procedure process the Application
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || pkpatel 22-JUN-2001 Bug no.1834307 :For Modeling and Forecasting DLD
12 || Modified the signature by changing the datatype of parameter from
13 || igs_ad_interface_all%ROWTYPE to igs_ad_interface_dtl_dscp_v%ROWTYPE
14 || (reverse chronological order - newest change first)
15 */
16 PROCEDURE CREATE_PERSON(P_PERSON_REC IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
17 P_ADDR_TYPE IN VARCHAR2,
18 P_PERSON_ID_TYPE IN VARCHAR2,
19 P_PERSON_ID OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE);
20
21 /*
22 || Created By : nsinha
23 || Created On : 22-JUN-2001
24 || Purpose : This procedure process the Application
25 || Known limitations, enhancements or remarks :
26 || Change History :
27 || Who When What
28 || npalanis 21-May-2002 p_interface_run_id is removed as updation is done in IGSAD79B.pls
29 || pkpatel 22-JUN-2001 Bug no.1834307 :For Modeling and Forecasting DLD
30 || Modified the signature by changing the datatype of parameter from
31 || igs_ad_interface_all%ROWTYPE to igs_ad_interface_dtl_dscp_v%ROWTYPE
32 || (reverse chronological order - newest change first)
33 */
34 PROCEDURE UPDATE_PERSON( P_PERSON_REC IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
35 P_ADDR_TYPE IN VARCHAR2,
36 P_PERSON_ID_TYPE IN VARCHAR2,
37 P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE);
38
39 PROCEDURE CREATE_ADDRESS(p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
40 P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
41 P_STATUS OUT NOCOPY VARCHAR2,
42 P_ERROR_CODE OUT NOCOPY VARCHAR2);
43
44 /*
45 || Created By : nsinha
46 || Created On : 22-JUN-2001
47 || Purpose : This procedure process the Application
48 || Known limitations, enhancements or remarks :
49 || Change History :
50 || Who When What
51 || pkpatel 22-JUN-2001 Bug no.2466466
52 || Added the parameter p_party_site_id
53 || (reverse chronological order - newest change first)
54 */
55 PROCEDURE UPDATE_ADDRESS(P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
56 P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
57 p_location_id IN hz_party_sites.location_id%TYPE,
58 p_party_site_id IN hz_party_sites.party_site_id%TYPE);
59
60 PROCEDURE VALIDATE_ADDRESS( P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
61 P_PERSON_ID IN igs_pe_person_base_v.PERSON_ID%TYPE,
62 p_status OUT NOCOPY VARCHAR2,
63 p_error_code OUT NOCOPY VARCHAR2);
64
65 PROCEDURE CREATE_API(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE,
66 p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
67 p_status OUT NOCOPY VARCHAR2,
68 p_error_code OUT NOCOPY VARCHAR2);
69
70 /*
71 || Created By : nsinha
72 || Created On : 22-JUN-2001
73 || Purpose : This procedure process the Application
74 || Known limitations, enhancements or remarks :
75 || Change History :
76 || Who When What
77 || pkpatel 22-JUN-2001 Bug no.2702536
78 || Added the parameter p_match_set_id
79 || (reverse chronological order - newest change first)
80 */
81 PROCEDURE PRC_PE_DTLS(p_d_batch_id IN NUMBER,
82 p_d_source_type_id IN NUMBER,
83 p_match_set_id IN NUMBER);
84
85 -- Variable to check whether the address details are processed for a person.
86 -- If processed then the PL/SQL table for Address synchronization notification needs to be populated.
87 g_addr_process BOOLEAN;
88
89 END Igs_Ad_Imp_002;