PACKAGE: APPS.IGS_PE_DUP_PAIRS_PKG

Source

1 PACKAGE igs_pe_dup_pairs_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSNI68S.pls 115.8 2002/11/29 01:29:25 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_DUPLICATE_PAIR_ID IN OUT NOCOPY NUMBER,
6        x_BATCH_ID IN NUMBER,
7        x_MATCH_SET_ID IN NUMBER,
8        x_ACTUAL_PERSON_ID IN NUMBER,
9        x_DUPLICATE_PERSON_ID IN NUMBER,
10        x_OBSOLETE_ID IN NUMBER,
11        x_MATCH_CATEGORY IN VARCHAR2,
12        x_DUP_STATUS IN VARCHAR2,
13        x_ADDRESS_TYPE IN VARCHAR2,
14        x_LOCATION_ID IN NUMBER,
15        x_PERSON_ID_TYPE IN VARCHAR2,
16        X_ORG_ID in NUMBER,
17       X_MODE in VARCHAR2 default 'R'
18   );
19 
20  procedure LOCK_ROW (
21       X_ROWID in  VARCHAR2,
22        x_DUPLICATE_PAIR_ID IN NUMBER,
23        x_BATCH_ID IN NUMBER,
24        x_MATCH_SET_ID IN NUMBER,
25        x_ACTUAL_PERSON_ID IN NUMBER,
26        x_DUPLICATE_PERSON_ID IN NUMBER,
27        x_OBSOLETE_ID IN NUMBER,
28        x_MATCH_CATEGORY IN VARCHAR2,
29        x_DUP_STATUS IN VARCHAR2,
30        x_ADDRESS_TYPE IN VARCHAR2,
31        x_LOCATION_ID IN NUMBER,
32        x_PERSON_ID_TYPE IN VARCHAR2  );
33  procedure UPDATE_ROW (
34       X_ROWID in  VARCHAR2,
35        x_DUPLICATE_PAIR_ID IN NUMBER,
36        x_BATCH_ID IN NUMBER,
37        x_MATCH_SET_ID IN NUMBER,
38        x_ACTUAL_PERSON_ID IN NUMBER,
39        x_DUPLICATE_PERSON_ID IN NUMBER,
40        x_OBSOLETE_ID IN NUMBER,
41        x_MATCH_CATEGORY IN VARCHAR2,
42        x_DUP_STATUS IN VARCHAR2,
43        x_ADDRESS_TYPE IN VARCHAR2,
44        x_LOCATION_ID IN NUMBER,
45        x_PERSON_ID_TYPE IN VARCHAR2,
46       X_MODE in VARCHAR2 default 'R'
47   );
48 
49  procedure ADD_ROW (
50       X_ROWID in out NOCOPY VARCHAR2,
51        x_DUPLICATE_PAIR_ID IN OUT NOCOPY NUMBER,
52        x_BATCH_ID IN NUMBER,
53        x_MATCH_SET_ID IN NUMBER,
54        x_ACTUAL_PERSON_ID IN NUMBER,
55        x_DUPLICATE_PERSON_ID IN NUMBER,
56        x_OBSOLETE_ID IN NUMBER,
57        x_MATCH_CATEGORY IN VARCHAR2,
58        x_DUP_STATUS IN VARCHAR2,
59        x_ADDRESS_TYPE IN VARCHAR2,
60        x_LOCATION_ID IN NUMBER,
61        x_PERSON_ID_TYPE IN VARCHAR2,
62        X_ORG_ID in NUMBER,
63       X_MODE in VARCHAR2 default 'R'
64   ) ;
65 
66 procedure DELETE_ROW (
67   X_ROWID in VARCHAR2
68 ) ;
69   FUNCTION Get_PK_For_Validation (
70     x_duplicate_pair_id IN NUMBER
71     ) RETURN BOOLEAN ;
72 
73   PROCEDURE Check_Constraints (
74 		 Column_Name IN VARCHAR2  DEFAULT NULL,
75 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
76   PROCEDURE Before_DML (
77     p_action IN VARCHAR2,
78     x_rowid IN VARCHAR2 DEFAULT NULL,
79     x_duplicate_pair_id IN NUMBER DEFAULT NULL,
80     x_batch_id IN NUMBER DEFAULT NULL,
81     x_match_set_id IN NUMBER DEFAULT NULL,
82     x_actual_person_id IN NUMBER DEFAULT NULL,
83     x_duplicate_person_id IN NUMBER DEFAULT NULL,
84     x_obsolete_id IN NUMBER DEFAULT NULL,
85     x_match_category IN VARCHAR2 DEFAULT NULL,
86     x_dup_status IN VARCHAR2 DEFAULT NULL,
87     x_address_type IN VARCHAR2 DEFAULT NULL,
88     x_location_id IN NUMBER DEFAULT NULL,
89     x_person_id_type IN VARCHAR2 DEFAULT NULL,
90     X_ORG_ID in NUMBER DEFAULT NULL,
91     x_creation_date IN DATE DEFAULT NULL,
92     x_created_by IN NUMBER DEFAULT NULL,
93     x_last_update_date IN DATE DEFAULT NULL,
94     x_last_updated_by IN NUMBER DEFAULT NULL,
95     x_last_update_login IN NUMBER DEFAULT NULL
96  );
97 END igs_pe_dup_pairs_pkg;