1 package IGS_PE_UNT_SET_EXCL_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSNI35S.pls 115.3 2002/11/29 01:22:56 nsidana ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PERSON_ID in NUMBER,
7 X_ENCUMBRANCE_TYPE in VARCHAR2,
8 X_PEN_START_DT in DATE,
9 X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
10 X_PEE_START_DT in DATE,
11 X_PEE_SEQUENCE_NUMBER in NUMBER,
12 X_UNIT_SET_CD in VARCHAR2,
13 X_US_VERSION_NUMBER in NUMBER,
14 X_PUSE_START_DT in DATE,
15 X_EXPIRY_DT in DATE,
16 X_MODE in VARCHAR2 default 'R'
17 );
18 procedure LOCK_ROW (
19 X_ROWID in VARCHAR2,
20 X_PERSON_ID in NUMBER,
21 X_ENCUMBRANCE_TYPE in VARCHAR2,
22 X_PEN_START_DT in DATE,
23 X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
24 X_PEE_START_DT in DATE,
25 X_PEE_SEQUENCE_NUMBER in NUMBER,
26 X_UNIT_SET_CD in VARCHAR2,
27 X_US_VERSION_NUMBER in NUMBER,
28 X_PUSE_START_DT in DATE,
29 X_EXPIRY_DT in DATE
30 );
31 procedure UPDATE_ROW (
32 X_ROWID in VARCHAR2,
33 X_PERSON_ID in NUMBER,
34 X_ENCUMBRANCE_TYPE in VARCHAR2,
35 X_PEN_START_DT in DATE,
36 X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
37 X_PEE_START_DT in DATE,
38 X_PEE_SEQUENCE_NUMBER in NUMBER,
39 X_UNIT_SET_CD in VARCHAR2,
40 X_US_VERSION_NUMBER in NUMBER,
41 X_PUSE_START_DT in DATE,
42 X_EXPIRY_DT in DATE,
43 X_MODE in VARCHAR2 default 'R'
44 );
45 procedure ADD_ROW (
46 X_ROWID in out NOCOPY VARCHAR2,
47 X_PERSON_ID in NUMBER,
48 X_ENCUMBRANCE_TYPE in VARCHAR2,
49 X_PEN_START_DT in DATE,
50 X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
51 X_PEE_START_DT in DATE,
52 X_PEE_SEQUENCE_NUMBER in NUMBER,
53 X_UNIT_SET_CD in VARCHAR2,
54 X_US_VERSION_NUMBER in NUMBER,
55 X_PUSE_START_DT in DATE,
56 X_EXPIRY_DT in DATE,
57 X_MODE in VARCHAR2 default 'R'
58 );
59 procedure DELETE_ROW (
60 X_ROWID in VARCHAR2
61 );
62
63 FUNCTION Get_PK_For_Validation (
64 x_s_encmb_effect_type IN VARCHAR2,
65 x_pen_start_dt IN DATE,
66 x_person_id IN NUMBER,
67 x_encumbrance_type IN VARCHAR2,
68 x_pee_start_dt IN DATE,
69 x_pee_sequence_number IN NUMBER,
70 x_unit_set_cd IN VARCHAR2,
71 x_us_version_number IN NUMBER,
72 x_puse_start_dt IN DATE
73 ) RETURN BOOLEAN;
74
75 PROCEDURE GET_FK_IGS_PE_PERSENC_EFFCT (
76 x_person_id IN NUMBER,
77 x_encumbrance_type IN VARCHAR2,
78 x_pen_start_dt IN DATE,
79 x_s_encmb_effect_type IN VARCHAR2,
80 x_pee_start_dt IN DATE,
81 x_pee_sequence_number IN NUMBER
82 );
83
84 PROCEDURE GET_FK_IGS_EN_UNIT_SET (
85 x_unit_set_cd IN VARCHAR2,
86 x_version_number IN NUMBER
87 );
88 PROCEDURE Check_Constraints (
89 Column_Name IN VARCHAR2 DEFAULT NULL,
90 Column_Value IN VARCHAR2 DEFAULT NULL
91 );
92 PROCEDURE Before_DML (
93 p_action IN VARCHAR2,
94 x_rowid IN VARCHAR2 DEFAULT NULL,
95 x_pee_sequence_number IN NUMBER DEFAULT NULL,
96 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
97 x_us_version_number IN NUMBER DEFAULT NULL,
98 x_puse_start_dt IN DATE DEFAULT NULL,
99 x_expiry_dt IN DATE DEFAULT NULL,
100 x_person_id IN NUMBER DEFAULT NULL,
101 x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
102 x_pen_start_dt IN DATE DEFAULT NULL,
103 x_s_encmb_effect_type IN VARCHAR2 DEFAULT NULL,
104 x_pee_start_dt IN DATE DEFAULT NULL,
105 x_creation_date IN DATE DEFAULT NULL,
106 x_created_by IN NUMBER DEFAULT NULL,
107 x_last_update_date IN DATE DEFAULT NULL,
108 x_last_updated_by IN NUMBER DEFAULT NULL,
109 x_last_update_login IN NUMBER DEFAULT NULL
110 );
111
112 end IGS_PE_UNT_SET_EXCL_PKG;