1 package IGS_PS_DSCP_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSPI53S.pls 115.4 2002/11/29 02:30:58 nsidana ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_DISCIPLINE_GROUP_CD in VARCHAR2,
7 X_HIST_START_DT in DATE,
8 X_HIST_END_DT in DATE,
9 X_HIST_WHO in NUMBER,
10 X_DESCRIPTION in VARCHAR2,
11 X_FUNDING_INDEX_1 in NUMBER,
12 X_FUNDING_INDEX_2 in NUMBER,
13 X_FUNDING_INDEX_3 in NUMBER,
14 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
15 X_CLOSED_IND in VARCHAR2,
16 X_MODE in VARCHAR2 default 'R',
17 X_ORG_ID in NUMBER
18 );
19 procedure LOCK_ROW (
20 X_ROWID in VARCHAR2,
21 X_DISCIPLINE_GROUP_CD in VARCHAR2,
22 X_HIST_START_DT in DATE,
23 X_HIST_END_DT in DATE,
24 X_HIST_WHO in NUMBER,
25 X_DESCRIPTION in VARCHAR2,
26 X_FUNDING_INDEX_1 in NUMBER,
27 X_FUNDING_INDEX_2 in NUMBER,
28 X_FUNDING_INDEX_3 in NUMBER,
29 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
30 X_CLOSED_IND in VARCHAR2
31 );
32 procedure UPDATE_ROW (
33 X_ROWID in VARCHAR2,
34 X_DISCIPLINE_GROUP_CD in VARCHAR2,
35 X_HIST_START_DT in DATE,
36 X_HIST_END_DT in DATE,
37 X_HIST_WHO in NUMBER,
38 X_DESCRIPTION in VARCHAR2,
39 X_FUNDING_INDEX_1 in NUMBER,
40 X_FUNDING_INDEX_2 in NUMBER,
41 X_FUNDING_INDEX_3 in NUMBER,
42 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
43 X_CLOSED_IND in VARCHAR2,
44 X_MODE in VARCHAR2 default 'R'
45 );
46 procedure ADD_ROW (
47 X_ROWID in out NOCOPY VARCHAR2,
48 X_DISCIPLINE_GROUP_CD in VARCHAR2,
49 X_HIST_START_DT in DATE,
50 X_HIST_END_DT in DATE,
51 X_HIST_WHO in NUMBER,
52 X_DESCRIPTION in VARCHAR2,
53 X_FUNDING_INDEX_1 in NUMBER,
54 X_FUNDING_INDEX_2 in NUMBER,
55 X_FUNDING_INDEX_3 in NUMBER,
56 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
57 X_CLOSED_IND in VARCHAR2,
58 X_MODE in VARCHAR2 default 'R',
59 X_ORG_ID in NUMBER
60 );
61 procedure DELETE_ROW (
62 X_ROWID in VARCHAR2
63 );
64
65 FUNCTION Get_PK_For_Validation (
66 x_discipline_group_cd IN VARCHAR2,
67 x_hist_start_dt IN DATE
68 )RETURN BOOLEAN;
69
70 PROCEDURE Check_Constraints (
71 Column_Name IN VARCHAR2 DEFAULT NULL,
72 Column_Value IN VARCHAR2 DEFAULT NULL
73 );
74
75 PROCEDURE Before_DML (
76 p_action IN VARCHAR2,
77 x_rowid IN VARCHAR2 DEFAULT NULL,
78 x_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
79 x_hist_start_dt IN DATE DEFAULT NULL,
80 x_hist_end_dt IN DATE DEFAULT NULL,
81 x_hist_who IN NUMBER DEFAULT NULL,
82 x_description IN VARCHAR2 DEFAULT NULL,
83 x_funding_index_1 IN NUMBER DEFAULT NULL,
84 x_funding_index_2 IN NUMBER DEFAULT NULL,
85 x_funding_index_3 IN NUMBER DEFAULT NULL,
86 x_govt_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
87 x_closed_ind IN VARCHAR2 DEFAULT NULL,
88 x_creation_date IN DATE DEFAULT NULL,
89 x_created_by IN NUMBER DEFAULT NULL,
90 x_last_update_date IN DATE DEFAULT NULL,
91 x_last_updated_by IN NUMBER DEFAULT NULL,
92 x_last_update_login IN NUMBER DEFAULT NULL,
93 x_org_id IN NUMBER DEFAULT NULL
94 ) ;
95
96 end IGS_PS_DSCP_HIST_PKG;