PACKAGE: APPS.IGS_AD_IMP_NEAR_MTCH_PKG

Source

1 PACKAGE igs_ad_imp_near_mtch_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIB2S.pls 115.12 2003/05/22 13:17:28 npalanis ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5       X_ORG_ID in NUMBER,
6        x_NEAR_MTCH_ID IN OUT NOCOPY NUMBER,
7        x_INTERFACE_ID IN NUMBER,
8        x_PERSON_ID IN NUMBER,
9        x_MATCH_IND IN VARCHAR2,
10        x_ACTION IN VARCHAR2,
11        x_ADDR_TYPE IN VARCHAR2,
12        x_PERSON_ID_TYPE IN VARCHAR2,
13        x_MATCH_SET_ID IN NUMBER,
14       X_MODE in VARCHAR2 default 'R',
15       x_party_site_id IN NUMBER  ,
16       X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
17   );
18 
19  procedure LOCK_ROW (
20       X_ROWID in  VARCHAR2,
21        x_NEAR_MTCH_ID IN NUMBER,
22        x_INTERFACE_ID IN NUMBER,
23        x_PERSON_ID IN NUMBER,
24        x_MATCH_IND IN VARCHAR2,
25        x_ACTION IN VARCHAR2,
26        x_ADDR_TYPE IN VARCHAR2,
27        x_PERSON_ID_TYPE IN VARCHAR2,
28        x_MATCH_SET_ID IN NUMBER,
29        x_party_site_id IN NUMBER ,
30       X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL);
31 
32  procedure UPDATE_ROW (
33       X_ROWID in  VARCHAR2,
34        x_NEAR_MTCH_ID IN NUMBER,
35        x_INTERFACE_ID IN NUMBER,
36        x_PERSON_ID IN NUMBER,
37        x_MATCH_IND IN VARCHAR2,
38        x_ACTION IN VARCHAR2,
39        x_ADDR_TYPE IN VARCHAR2,
40        x_PERSON_ID_TYPE IN VARCHAR2,
41        x_MATCH_SET_ID IN NUMBER,
42       X_MODE in VARCHAR2 default 'R',
43       x_party_site_id IN NUMBER  ,
44       X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
45   );
46 
47  procedure ADD_ROW (
48       X_ROWID in out NOCOPY VARCHAR2,
49       X_ORG_ID in NUMBER,
50        x_NEAR_MTCH_ID IN OUT NOCOPY NUMBER,
51        x_INTERFACE_ID IN NUMBER,
52        x_PERSON_ID IN NUMBER,
53        x_MATCH_IND IN VARCHAR2,
54        x_ACTION IN VARCHAR2,
55        x_ADDR_TYPE IN VARCHAR2,
56        x_PERSON_ID_TYPE IN VARCHAR2,
57        x_MATCH_SET_ID IN NUMBER,
58       X_MODE in VARCHAR2 default 'R',
59       x_party_site_id IN NUMBER   ,
60       X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
61   ) ;
62 
63   procedure DELETE_ROW (
64     X_ROWID in VARCHAR2
65     );
66 
67   FUNCTION Get_PK_For_Validation (
68     x_near_mtch_id IN NUMBER
69     ) RETURN BOOLEAN ;
70 
71   PROCEDURE Get_FK_Igs_Ad_Interface (
72     x_interface_id IN NUMBER
73     );
74 
75   PROCEDURE Get_FK_Igs_Co_Addr_Type (
76     x_addr_type IN VARCHAR2
77     );
78 
79   PROCEDURE Get_FK_Igs_Pe_Match_Sets (
80     x_match_set_id IN NUMBER
81     );
82 
83   PROCEDURE Get_FK_Igs_Pe_Person (
84     x_person_id IN NUMBER
85     );
86 
87   PROCEDURE Check_Constraints (
88 		 Column_Name IN VARCHAR2  DEFAULT NULL,
89 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
90 
91   PROCEDURE Before_DML (
92     p_action IN VARCHAR2,
93     x_rowid IN VARCHAR2 DEFAULT NULL,
94     x_org_id IN NUMBER DEFAULT NULL,
95     x_near_mtch_id IN NUMBER DEFAULT NULL,
96     x_interface_id IN NUMBER DEFAULT NULL,
97     x_person_id IN NUMBER DEFAULT NULL,
98     x_match_ind IN VARCHAR2 DEFAULT NULL,
99     x_action IN VARCHAR2 DEFAULT NULL,
100     x_addr_type IN VARCHAR2 DEFAULT NULL,
101     x_person_id_type IN VARCHAR2 DEFAULT NULL,
102     x_match_set_id IN NUMBER DEFAULT NULL,
103     x_creation_date IN DATE DEFAULT NULL,
104     x_created_by IN NUMBER DEFAULT NULL,
105     x_last_update_date IN DATE DEFAULT NULL,
106     x_last_updated_by IN NUMBER DEFAULT NULL,
107     x_last_update_login IN NUMBER DEFAULT NULL,
108     x_party_site_id IN NUMBER DEFAULT NULL,
109     X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
110  );
111 END igs_ad_imp_near_mtch_pkg;