1 package IGS_PE_PERSON_ID_TYP_PKG AS
2 /* $Header: IGSNI25S.pls 120.0 2005/06/01 16:33:59 appldev noship $ */
3
4 ------------------------------------------------------------------
5 -- Change History
6 --
7 -- Bug ID : 2000408
8 -- who when what
9 -- CDCRUZ Sep 24,2002 New Col added for
10 -- Person DLD / FORMAT_MASK
11 ------------------------------------------------------------------
12
13 /******************************************************
14 Created By : nigupta
15 Date Created By : 11-MAY-2000
16 Purpose : To create Table Handler Specifications
17 Know limitations, enhancements or remarks : None
18 Change History
19 Who When What
20 gmuralid 4-dec-2002 included parameter x_region_ind due to column
21 region_ind being included in the table
22 IGS_PE_PERSON_ID_TYP
23
24 (reverse chronological order - newest change first)
25 ********************************************************/
26
27 procedure INSERT_ROW (
28 X_ROWID in out NOCOPY VARCHAR2,
29 x_PERSON_ID_TYPE IN VARCHAR2,
30 x_DESCRIPTION IN VARCHAR2,
31 x_S_PERSON_ID_TYPE IN VARCHAR2,
32 x_INSTITUTION_CD IN VARCHAR2,
33 x_PREFERRED_IND IN VARCHAR2,
34 x_UNIQUE_IND IN VARCHAR2,
35 X_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
36 X_REGION_IND IN VARCHAR2,
37 X_MODE in VARCHAR2 default 'R' ,
38 X_CLOSED_IND IN VARCHAR2
39 );
40
41 procedure LOCK_ROW (
42 X_ROWID in VARCHAR2,
43 x_PERSON_ID_TYPE IN VARCHAR2,
44 x_DESCRIPTION IN VARCHAR2,
45 x_S_PERSON_ID_TYPE IN VARCHAR2,
46 x_INSTITUTION_CD IN VARCHAR2,
47 x_PREFERRED_IND IN VARCHAR2,
48 x_UNIQUE_IND IN VARCHAR2 ,
49 X_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
50 X_REGION_IND IN VARCHAR2
51 );
52
53 procedure UPDATE_ROW (
54 X_ROWID in VARCHAR2,
55 x_PERSON_ID_TYPE IN VARCHAR2,
56 x_DESCRIPTION IN VARCHAR2,
57 x_S_PERSON_ID_TYPE IN VARCHAR2,
58 x_INSTITUTION_CD IN VARCHAR2,
59 x_PREFERRED_IND IN VARCHAR2,
60 x_UNIQUE_IND IN VARCHAR2,
61 X_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
62 X_REGION_IND IN VARCHAR2,
63 X_MODE in VARCHAR2 default 'R',
64 X_CLOSED_IND IN VARCHAR2
65 );
66
67 procedure ADD_ROW (
68 X_ROWID in out NOCOPY VARCHAR2,
69 x_PERSON_ID_TYPE IN VARCHAR2,
70 x_DESCRIPTION IN VARCHAR2,
71 x_S_PERSON_ID_TYPE IN VARCHAR2,
72 x_INSTITUTION_CD IN VARCHAR2,
73 x_PREFERRED_IND IN VARCHAR2,
74 x_UNIQUE_IND IN VARCHAR2,
75 X_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
76 X_REGION_IND IN VARCHAR2,
77 X_MODE in VARCHAR2 default 'R',
78 X_CLOSED_IND IN VARCHAR2
79 ) ;
80
81 FUNCTION Get_PK_For_Validation (
82 x_person_id_type IN VARCHAR2
83 ) RETURN BOOLEAN;
84
85 FUNCTION Get_PID_Type_Validation (
86 x_person_id_type IN VARCHAR2
87 ) RETURN BOOLEAN;
88
89 PROCEDURE GET_FK_IGS_OR_INSTITUTION (
90 x_institution_cd IN VARCHAR2
91 );
92
93 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
94 x_s_person_id_type IN VARCHAR2
95 );
96 PROCEDURE Check_Constraints (
97 Column_Name IN VARCHAR2 DEFAULT NULL,
98 Column_Value IN VARCHAR2 DEFAULT NULL
99 );
100
101 PROCEDURE Before_DML (
102 p_action IN VARCHAR2,
103 x_rowid IN VARCHAR2 DEFAULT NULL,
104 x_person_id_type IN VARCHAR2 DEFAULT NULL,
105 x_description IN VARCHAR2 DEFAULT NULL,
106 x_s_person_id_type IN VARCHAR2 DEFAULT NULL,
107 x_institution_cd IN VARCHAR2 DEFAULT NULL,
108 x_preferred_ind IN VARCHAR2 DEFAULT NULL,
109 x_unique_ind IN VARCHAR2 DEFAULT NULL,
110 X_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
111 X_REGION_IND IN VARCHAR2 DEFAULT NULL,
112 x_closed_ind IN VARCHAR2,
113 x_creation_date IN DATE DEFAULT NULL,
114 x_created_by IN NUMBER DEFAULT NULL,
115 x_last_update_date IN DATE DEFAULT NULL,
116 x_last_updated_by IN NUMBER DEFAULT NULL,
117 x_last_update_login IN NUMBER DEFAULT NULL
118 );
119
120 end IGS_PE_PERSON_ID_TYP_PKG;