PACKAGE: APPS.IGS_PE_MATCH_SETS_PKG

Source

1 PACKAGE igs_pe_match_sets_pkg AS
2 /* $Header: IGSNI66S.pls 120.0 2005/06/01 21:31:16 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_MATCH_SET_ID IN OUT NOCOPY NUMBER,
6        x_SOURCE_TYPE_ID IN NUMBER,
7        x_MATCH_SET_NAME IN VARCHAR2,
8        x_DESCRIPTION IN VARCHAR2,
9        x_CLOSED_IND IN VARCHAR2,
10        x_PARTIAL_IF_NULL IN VARCHAR2,
11        x_EXCLUDE_INACTIVE_IND IN VARCHAR2 default 'N',
12       X_MODE in VARCHAR2 default 'R'  ,
13        X_ORG_ID in NUMBER,
14        X_primary_addr_flag IN VARCHAR2 DEFAULT 'N'
15   );
16 
17  procedure LOCK_ROW (
18       X_ROWID in  VARCHAR2,
19        x_MATCH_SET_ID IN NUMBER,
20        x_SOURCE_TYPE_ID IN NUMBER,
21        x_MATCH_SET_NAME IN VARCHAR2,
22        x_DESCRIPTION IN VARCHAR2,
23        x_CLOSED_IND IN VARCHAR2,
24        x_PARTIAL_IF_NULL IN VARCHAR2,
25        x_primary_addr_flag IN VARCHAR2 DEFAULT 'N',
26        x_exclude_inactive_ind IN VARCHAR2 DEFAULT 'N'
27   );
28  procedure UPDATE_ROW (
29       X_ROWID in  VARCHAR2,
30        x_MATCH_SET_ID IN NUMBER,
31        x_SOURCE_TYPE_ID IN NUMBER,
32        x_MATCH_SET_NAME IN VARCHAR2,
33        x_DESCRIPTION IN VARCHAR2,
34        x_CLOSED_IND IN VARCHAR2,
35        x_PARTIAL_IF_NULL IN VARCHAR2,
36        x_primary_addr_flag IN VARCHAR2 DEFAULT 'N',
37        x_EXCLUDE_INACTIVE_IND IN VARCHAR2 DEFAULT 'N',
38       X_MODE in VARCHAR2 default 'R'
39 
40   );
41 
42  procedure ADD_ROW (
43       X_ROWID in out NOCOPY VARCHAR2,
44        x_MATCH_SET_ID IN OUT NOCOPY NUMBER,
45        x_SOURCE_TYPE_ID IN NUMBER,
46        x_MATCH_SET_NAME IN VARCHAR2,
47        x_DESCRIPTION IN VARCHAR2,
48        x_CLOSED_IND IN VARCHAR2,
49        x_PARTIAL_IF_NULL IN VARCHAR2,
50        X_EXCLUDE_INACTIVE_IND IN VARCHAR2,
51        X_MODE in VARCHAR2 default 'R'  ,
52        X_ORG_ID in NUMBER,
53        x_primary_addr_flag IN VARCHAR2 DEFAULT 'N'
54   ) ;
55 
56 procedure DELETE_ROW (
57   X_ROWID in VARCHAR2
58 ) ;
59   FUNCTION Get_PK_For_Validation (
60     x_match_set_id IN NUMBER
61     ) RETURN BOOLEAN ;
62 
63   PROCEDURE GET_FK_IGS_PE_SRC_TYPES (
64       X_source_type_id in number
65       );
66 
67 PROCEDURE GET_FK_IGS_PE_DUP_PAIRS (
68       X_duplicate_pair_id in number
69      );
70 
71 FUNCTION Get_UK1_For_Validation (
72     x_match_set_name IN VARCHAR2
73     )
74    RETURN BOOLEAN;
75 
76   PROCEDURE Check_Constraints (
77 		 Column_Name IN VARCHAR2  DEFAULT NULL,
78 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
79   PROCEDURE Before_DML (
80     p_action IN VARCHAR2,
81     x_rowid IN VARCHAR2 DEFAULT NULL,
82     x_match_set_id IN NUMBER DEFAULT NULL,
83     x_source_type_id IN NUMBER DEFAULT NULL,
84     x_match_set_name IN VARCHAR2 DEFAULT NULL,
85     x_description IN VARCHAR2 DEFAULT NULL,
86     x_closed_ind IN VARCHAR2 DEFAULT NULL,
87     x_PARTIAL_IF_NULL IN VARCHAR2 DEFAULT NULL,
88     x_EXCLUDE_INACTIVE_IND IN VARCHAR2 DEFAULT 'N',
89     x_creation_date IN DATE DEFAULT NULL,
90     x_created_by IN NUMBER DEFAULT NULL,
91     x_last_update_date IN DATE DEFAULT NULL,
92     x_last_updated_by IN NUMBER DEFAULT NULL,
93     x_last_update_login IN NUMBER DEFAULT NULL,
94     X_primary_addr_flag IN VARCHAR2 DEFAULT 'N',
95     X_ORG_ID in NUMBER default NULL
96   );
97 END igs_pe_match_sets_pkg;