1 package IGS_PE_PERS_NOTE_PKG AS
2 /* $Header: IGSNI27S.pls 120.0 2005/06/01 19:33:17 appldev noship $ */
3
4
5 procedure INSERT_ROW (
6 X_ROWID in out NOCOPY VARCHAR2,
7 X_PERSON_ID in NUMBER,
8 X_REFERENCE_NUMBER in NUMBER,
9 X_PE_NOTE_TYPE in VARCHAR2,
10 X_START_DATE IN DATE DEFAULT NULL,
11 X_END_DATE IN DATE DEFAULT NULL,
12 X_MODE in VARCHAR2 default 'R'
13 );
14 procedure LOCK_ROW (
15 X_ROWID in VARCHAR2,
16 X_PERSON_ID in NUMBER,
17 X_REFERENCE_NUMBER in NUMBER,
18 X_PE_NOTE_TYPE in VARCHAR2,
19 X_START_DATE IN DATE DEFAULT NULL,
20 X_END_DATE IN DATE DEFAULT NULL
21 );
22 procedure UPDATE_ROW (
23 X_ROWID in VARCHAR2,
24 X_PERSON_ID in NUMBER,
25 X_REFERENCE_NUMBER in NUMBER,
26 X_PE_NOTE_TYPE in VARCHAR2,
27 X_START_DATE IN DATE DEFAULT NULL,
28 X_END_DATE IN DATE DEFAULT NULL,
29 X_MODE in VARCHAR2 default 'R'
30 );
31 procedure ADD_ROW (
32 X_ROWID in out NOCOPY VARCHAR2,
33 X_PERSON_ID in NUMBER,
34 X_REFERENCE_NUMBER in NUMBER,
35 X_PE_NOTE_TYPE in VARCHAR2,
36 X_START_DATE IN DATE DEFAULT NULL,
37 X_END_DATE IN DATE DEFAULT NULL,
38 X_MODE in VARCHAR2 default 'R'
39 );
40 procedure DELETE_ROW (
41 X_ROWID in VARCHAR2,
42 x_mode IN VARCHAR2 DEFAULT 'R'
43 );
44
45 FUNCTION Get_PK_For_Validation (
46 x_person_id IN NUMBER,
47 x_reference_number IN NUMBER
48 ) RETURN BOOLEAN;
49
50 PROCEDURE GET_FK_IGS_GE_NOTE (
51 x_reference_number IN NUMBER
52 );
53
54 PROCEDURE GET_FK_IGS_PE_PERSON (
55 x_person_id IN NUMBER
56 );
57
58 PROCEDURE GET_FK_IGS_PE_NOTE_TYPE (
59 x_pe_note_type IN VARCHAR2
60 );
61 PROCEDURE Check_Constraints (
62 Column_Name IN VARCHAR2 DEFAULT NULL,
63 Column_Value IN VARCHAR2 DEFAULT NULL
64 );
65 PROCEDURE Before_DML (
66 p_action IN VARCHAR2,
67 x_rowid IN VARCHAR2 DEFAULT NULL,
68 x_person_id IN NUMBER DEFAULT NULL,
69 x_reference_number IN NUMBER DEFAULT NULL,
70 x_pe_note_type IN VARCHAR2 DEFAULT NULL,
71 X_START_DATE IN DATE DEFAULT NULL,
72 X_END_DATE IN DATE DEFAULT NULL,
73 x_creation_date IN DATE DEFAULT NULL,
74 x_created_by IN NUMBER DEFAULT NULL,
75 x_last_update_date IN DATE DEFAULT NULL,
76 x_last_updated_by IN NUMBER DEFAULT NULL,
77 x_last_update_login IN NUMBER DEFAULT NULL
78
79 );
80
81
82 end IGS_PE_PERS_NOTE_PKG;
[Home] [Help]