1 package IGS_PE_PERS_ENCUMB_PKG AS
2 /* $Header: IGSNI18S.pls 120.1 2005/09/30 04:19:26 appldev ship $ */
3
4 ------------------------------------------------------------------
5 -- Change History
6 --
7 -- Bug ID : 2000408
8 -- who when what
9 -- CDCRUZ Sep 24,2002 New Col's added for
10 -- Person DLD / cal_type , sequence_number added
11 -- pkpatel 30-SEP-2002 Bug No: 2600842
12 -- Added the column auth_resp_id and the variable 'initialised' was declared
13 ------------------------------------------------------------------
14
15 initialised VARCHAR2(1);
16
17 procedure INSERT_ROW (
18 X_ROWID in out NOCOPY VARCHAR2,
19 X_PERSON_ID in NUMBER,
20 X_ENCUMBRANCE_TYPE in VARCHAR2,
21 X_START_DT in DATE,
22 X_EXPIRY_DT in DATE,
23 X_AUTHORISING_PERSON_ID in NUMBER,
24 X_COMMENTS in VARCHAR2,
25 x_spo_course_cd IN VARCHAR2,
26 x_spo_sequence_number IN NUMBER,
27 X_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
28 X_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
29 X_AUTH_RESP_ID IN NUMBER DEFAULT NULL,
30 X_EXTERNAL_REFERENCE in VARCHAR2 DEFAULT NULL,
31 X_MODE in VARCHAR2 default 'R'
32 );
33 procedure LOCK_ROW (
34 X_ROWID in VARCHAR2,
35 X_PERSON_ID in NUMBER,
36 X_ENCUMBRANCE_TYPE in VARCHAR2,
37 X_START_DT in DATE,
38 X_EXPIRY_DT in DATE,
39 X_AUTHORISING_PERSON_ID in NUMBER,
40 x_spo_course_cd IN VARCHAR2,
41 x_spo_sequence_number IN NUMBER,
42 X_COMMENTS in VARCHAR2,
43 X_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
44 X_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
45 X_AUTH_RESP_ID IN NUMBER DEFAULT NULL,
46 X_EXTERNAL_REFERENCE in VARCHAR2 DEFAULT NULL
47 );
48
49 procedure UPDATE_ROW (
50 X_ROWID in VARCHAR2,
51 X_PERSON_ID in NUMBER,
52 X_ENCUMBRANCE_TYPE in VARCHAR2,
53 X_START_DT in DATE,
54 X_EXPIRY_DT in DATE,
55 X_AUTHORISING_PERSON_ID in NUMBER,
56 X_COMMENTS in VARCHAR2,
57 x_spo_course_cd IN VARCHAR2,
58 x_spo_sequence_number IN NUMBER,
59 X_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
60 X_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
61 X_AUTH_RESP_ID IN NUMBER DEFAULT NULL,
62 X_EXTERNAL_REFERENCE in VARCHAR2 DEFAULT NULL,
63 X_MODE in VARCHAR2 default 'R'
64 );
65 procedure ADD_ROW (
66 X_ROWID in out NOCOPY VARCHAR2,
67 X_PERSON_ID in NUMBER,
68 X_ENCUMBRANCE_TYPE in VARCHAR2,
69 X_START_DT in DATE,
70 X_EXPIRY_DT in DATE,
71 X_AUTHORISING_PERSON_ID in NUMBER,
72 X_COMMENTS in VARCHAR2,
73 x_spo_course_cd IN VARCHAR2,
74 x_spo_sequence_number IN NUMBER,
75 X_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
76 X_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
77 X_AUTH_RESP_ID IN NUMBER DEFAULT NULL,
78 X_EXTERNAL_REFERENCE in VARCHAR2 DEFAULT NULL,
79 X_MODE in VARCHAR2 default 'R'
80 );
81 procedure DELETE_ROW (
82 X_ROWID in VARCHAR2
83 );
84
85 FUNCTION Get_PK_For_Validation (
86 x_person_id IN NUMBER,
87 x_encumbrance_type IN VARCHAR2,
88 x_start_dt IN DATE
89 ) RETURN BOOLEAN;
90
91 PROCEDURE GET_FK_IGS_CA_INST (
92 x_cal_type IN VARCHAR2,
93 x_ci_sequence_number NUMBER
94 );
95
96 PROCEDURE GET_FK_IGS_FI_ENCMB_TYPE (
97 x_encumbrance_type IN VARCHAR2
98 );
99
100 PROCEDURE GET_FK_IGS_PE_PERSON (
101 x_person_id IN NUMBER
102 );
103 PROCEDURE Check_Constraints (
104 Column_Name IN VARCHAR2 DEFAULT NULL,
105 Column_Value IN VARCHAR2 DEFAULT NULL
106 );
107 PROCEDURE Before_DML (
108 p_action IN VARCHAR2,
109 x_rowid IN VARCHAR2 DEFAULT NULL,
110 x_comments IN VARCHAR2 DEFAULT NULL,
111 x_person_id IN NUMBER DEFAULT NULL,
112 x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
113 x_start_dt IN DATE DEFAULT NULL,
114 x_expiry_dt IN DATE DEFAULT NULL,
115 x_authorising_person_id IN NUMBER DEFAULT NULL,
116 x_spo_course_cd IN VARCHAR2 DEFAULT NULL,
117 x_spo_sequence_number IN NUMBER DEFAULT NULL,
118 X_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
119 X_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
120 X_AUTH_RESP_ID IN NUMBER DEFAULT NULL,
121 X_EXTERNAL_REFERENCE in VARCHAR2 DEFAULT NULL,
122 x_creation_date IN DATE DEFAULT NULL,
123 x_created_by IN NUMBER DEFAULT NULL,
124 x_last_update_date IN DATE DEFAULT NULL,
125 x_last_updated_by IN NUMBER DEFAULT NULL,
126 x_last_update_login IN NUMBER DEFAULT NULL
127 );
128
129
130 end IGS_PE_PERS_ENCUMB_PKG;