1 package IGS_PS_TYPE_HIST_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI39S.pls 115.8 2002/11/29 02:24:11 nsidana ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_COURSE_TYPE 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_GOVT_COURSE_TYPE in NUMBER,
12 X_AWARD_COURSE_IND in VARCHAR2,
13 X_COURSE_TYPE_GROUP_CD in VARCHAR2,
14 X_TAC_COURSE_LEVEL in VARCHAR2,
15 X_RESEARCH_TYPE_IND in VARCHAR2,
16 X_CLOSED_IND in VARCHAR2,
17 X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT 'Y',
18 X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
19 X_MODE in VARCHAR2 default 'R' ,
20 X_ORG_ID in NUMBER
21 );
22 procedure LOCK_ROW (
23 X_ROWID in VARCHAR2,
24 X_COURSE_TYPE in VARCHAR2,
25 X_HIST_START_DT in DATE,
26 X_HIST_END_DT in DATE,
27 X_HIST_WHO in NUMBER,
28 X_DESCRIPTION in VARCHAR2,
29 X_GOVT_COURSE_TYPE in NUMBER,
30 X_AWARD_COURSE_IND in VARCHAR2,
31 X_COURSE_TYPE_GROUP_CD in VARCHAR2,
32 X_TAC_COURSE_LEVEL in VARCHAR2,
33 X_RESEARCH_TYPE_IND in VARCHAR2,
34 X_CLOSED_IND in VARCHAR2,
35 X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT 'Y',
36 X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL
37 );
38 procedure UPDATE_ROW (
39 X_ROWID in VARCHAR2,
40 X_COURSE_TYPE in VARCHAR2,
41 X_HIST_START_DT in DATE,
42 X_HIST_END_DT in DATE,
43 X_HIST_WHO in NUMBER,
44 X_DESCRIPTION in VARCHAR2,
45 X_GOVT_COURSE_TYPE in NUMBER,
46 X_AWARD_COURSE_IND in VARCHAR2,
47 X_COURSE_TYPE_GROUP_CD in VARCHAR2,
48 X_TAC_COURSE_LEVEL in VARCHAR2,
49 X_RESEARCH_TYPE_IND in VARCHAR2,
50 X_CLOSED_IND in VARCHAR2,
51 X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT 'Y',
52 X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
53 X_MODE in VARCHAR2 default 'R'
54 );
55 procedure ADD_ROW (
56 X_ROWID in out NOCOPY VARCHAR2,
57 X_COURSE_TYPE in VARCHAR2,
58 X_HIST_START_DT in DATE,
59 X_HIST_END_DT in DATE,
60 X_HIST_WHO in NUMBER,
61 X_DESCRIPTION in VARCHAR2,
62 X_GOVT_COURSE_TYPE in NUMBER,
63 X_AWARD_COURSE_IND in VARCHAR2,
64 X_COURSE_TYPE_GROUP_CD in VARCHAR2,
65 X_TAC_COURSE_LEVEL in VARCHAR2,
66 X_RESEARCH_TYPE_IND in VARCHAR2,
67 X_CLOSED_IND in VARCHAR2,
68 X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT 'Y',
69 X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
70 X_MODE in VARCHAR2 default 'R',
71 X_ORG_ID in NUMBER
72 );
73 procedure DELETE_ROW (
74 X_ROWID in VARCHAR2
75 );
76 FUNCTION Get_PK_For_Validation (
77 x_course_type IN VARCHAR2,
78 x_hist_start_dt IN DATE
79 )RETURN BOOLEAN;
80
81 PROCEDURE CHECK_CONSTRAINTS (
82 Column_Name IN VARCHAR2 DEFAULT NULL,
83 Column_Value IN VARCHAR2 DEFAULT NULL
84 );
85
86 PROCEDURE Before_DML (
87 p_action IN VARCHAR2,
88 x_rowid IN VARCHAR2 DEFAULT NULL,
89 x_course_type IN VARCHAR2 DEFAULT NULL,
90 x_hist_start_dt IN DATE DEFAULT NULL,
91 x_hist_end_dt IN DATE DEFAULT NULL,
92 x_hist_who IN NUMBER DEFAULT NULL,
93 x_description IN VARCHAR2 DEFAULT NULL,
94 x_govt_course_type IN NUMBER DEFAULT NULL,
95 x_course_type_group_cd IN VARCHAR2 DEFAULT NULL,
96 x_tac_course_level IN VARCHAR2 DEFAULT NULL,
97 x_award_course_ind IN VARCHAR2 DEFAULT NULL,
98 x_research_type_ind IN VARCHAR2 DEFAULT NULL,
99 x_closed_ind IN VARCHAR2 DEFAULT NULL,
100 x_primary_auto_select IN VARCHAR2 DEFAULT 'Y',
101 X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
102 x_creation_date IN DATE DEFAULT NULL,
103 x_created_by IN NUMBER DEFAULT NULL,
104 x_last_update_date IN DATE DEFAULT NULL,
105 x_last_updated_by IN NUMBER DEFAULT NULL,
106 x_last_update_login IN NUMBER DEFAULT NULL,
107 x_org_id IN NUMBER DEFAULT NULL
108 ) ;
109
110 end IGS_PS_TYPE_HIST_PKG;