PACKAGE: APPS.IGS_PE_PERSON_ALIAS_PKG

Source

1 package  IGS_PE_PERSON_ALIAS_PKG AS
2  /* $Header: IGSNI11S.pls 120.0 2005/06/01 16:51:44 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_ALIAS_TYPE in VARCHAR2,
8   X_SEQUENCE_NUMBER in NUMBER,
9   X_TITLE in VARCHAR2,
10   X_ALIAS_COMMENT in VARCHAR2,
11   X_START_DT in DATE,
12   X_END_DT in DATE,
13   X_SURNAME in VARCHAR2,
14   X_GIVEN_NAMES in VARCHAR2,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_PERSON_ID in NUMBER,
20   X_ALIAS_TYPE in VARCHAR2,
21   X_SEQUENCE_NUMBER in NUMBER,
22   X_TITLE in VARCHAR2,
23   X_ALIAS_COMMENT in VARCHAR2,
24   X_START_DT in DATE,
25   X_END_DT in DATE,
26   X_SURNAME in VARCHAR2,
27   X_GIVEN_NAMES in VARCHAR2
28 );
29 procedure UPDATE_ROW (
30   X_ROWID in VARCHAR2,
31   X_PERSON_ID in NUMBER,
32   X_ALIAS_TYPE in VARCHAR2,
33   X_SEQUENCE_NUMBER in NUMBER,
34   X_TITLE in VARCHAR2,
35   X_ALIAS_COMMENT in VARCHAR2,
36   X_START_DT in DATE,
37   X_END_DT in DATE,
38   X_SURNAME in VARCHAR2,
39   X_GIVEN_NAMES in VARCHAR2,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure ADD_ROW (
43   X_ROWID in out NOCOPY VARCHAR2,
44   X_PERSON_ID in NUMBER,
45   X_ALIAS_TYPE in VARCHAR2,
46   X_SEQUENCE_NUMBER in NUMBER,
47   X_TITLE in VARCHAR2,
48   X_ALIAS_COMMENT in VARCHAR2,
49   X_START_DT in DATE,
50   X_END_DT in DATE,
51   X_SURNAME in VARCHAR2,
52   X_GIVEN_NAMES in VARCHAR2,
53   X_MODE in VARCHAR2 default 'R'
54   );
55 procedure DELETE_ROW (
56   X_ROWID in VARCHAR2,
57   x_mode IN VARCHAR2 DEFAULT 'R'
58 );
59 FUNCTION  Get_PK_For_Validation (
60     x_person_id IN NUMBER,
61     x_sequence_number IN NUMBER
62     ) RETURN BOOLEAN ;
63 
64   PROCEDURE GET_FK_IGS_PE_PERSON (
65     x_person_id IN NUMBER
66     );
67 
68  PROCEDURE Check_Constraints (
69  Column_Name    IN      VARCHAR2        DEFAULT NULL,
70  Column_Value   IN      VARCHAR2        DEFAULT NULL
71  );
72 
73  PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_person_id IN NUMBER DEFAULT NULL,
77     X_ALIAS_TYPE in VARCHAR2 DEFAULT NULL,
78     x_sequence_number IN NUMBER DEFAULT NULL,
79     x_start_dt IN DATE DEFAULT NULL,
80     x_end_dt IN DATE DEFAULT NULL,
81     x_surname IN VARCHAR2 DEFAULT NULL,
82     x_given_names IN VARCHAR2 DEFAULT NULL,
83     x_title IN VARCHAR2 DEFAULT NULL,
84     x_alias_comment IN VARCHAR2 DEFAULT NULL,
85     x_creation_date IN DATE DEFAULT NULL,
86     x_created_by IN NUMBER DEFAULT NULL,
87     x_last_update_date IN DATE DEFAULT NULL,
88     x_last_updated_by IN NUMBER DEFAULT NULL,
89     x_last_update_login IN NUMBER DEFAULT NULL
90   );
91 
92 end IGS_PE_PERSON_ALIAS_PKG;