1 package IGS_AD_SBMAO_FN_UITT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI62S.pls 115.4 2003/09/01 05:59:41 akadam ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_SUBMISSION_YR in NUMBER,
6 X_SUBMISSION_NUMBER in NUMBER,
7 X_ORG_UNIT_CD in VARCHAR2,
8 X_OU_START_DT in DATE,
9 X_FUNDING_SOURCE in VARCHAR2,
10 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
11 X_INTAKE_TARGET_TYPE in VARCHAR2,
12 X_TARGET in NUMBER,
13 X_MAX_TARGET in NUMBER,
14 X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
15 X_ACTUAL_ENROLMENT in NUMBER,
16 X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
17 X_MODE in VARCHAR2 default 'R'
18 );
19 procedure LOCK_ROW (
20 X_ROWID in VARCHAR2,
21 X_SUBMISSION_YR in NUMBER,
22 X_SUBMISSION_NUMBER in NUMBER,
23 X_ORG_UNIT_CD in VARCHAR2,
24 X_OU_START_DT in DATE,
25 X_FUNDING_SOURCE in VARCHAR2,
26 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
27 X_INTAKE_TARGET_TYPE in VARCHAR2,
28 X_TARGET in NUMBER,
29 X_MAX_TARGET in NUMBER,
30 X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
31 X_ACTUAL_ENROLMENT in NUMBER,
32 X_ACTUAL_ENR_EFFECTIVE_DT in DATE
33 );
34 procedure UPDATE_ROW (
35 X_ROWID in VARCHAR2,
36 X_SUBMISSION_YR in NUMBER,
37 X_SUBMISSION_NUMBER in NUMBER,
38 X_ORG_UNIT_CD in VARCHAR2,
39 X_OU_START_DT in DATE,
40 X_FUNDING_SOURCE in VARCHAR2,
41 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
42 X_INTAKE_TARGET_TYPE in VARCHAR2,
43 X_TARGET in NUMBER,
44 X_MAX_TARGET in NUMBER,
45 X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
46 X_ACTUAL_ENROLMENT in NUMBER,
47 X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
48 X_MODE in VARCHAR2 default 'R'
49 );
50 procedure ADD_ROW (
51 X_ROWID in out NOCOPY VARCHAR2,
52 X_SUBMISSION_YR in NUMBER,
53 X_SUBMISSION_NUMBER in NUMBER,
54 X_ORG_UNIT_CD in VARCHAR2,
55 X_OU_START_DT in DATE,
56 X_FUNDING_SOURCE in VARCHAR2,
57 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
58 X_INTAKE_TARGET_TYPE in VARCHAR2,
59 X_TARGET in NUMBER,
60 X_MAX_TARGET in NUMBER,
61 X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
62 X_ACTUAL_ENROLMENT in NUMBER,
63 X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
64 X_MODE in VARCHAR2 default 'R'
65 );
66 procedure DELETE_ROW (
67 X_ROWID in VARCHAR2
68 );
69
70 FUNCTION Get_PK_For_Validation (
71 x_submission_yr IN NUMBER,
72 x_submission_number IN NUMBER,
73 x_org_unit_cd IN VARCHAR2,
74 x_ou_start_dt IN DATE,
75 x_funding_source IN VARCHAR2,
76 x_unit_int_course_level_cd IN VARCHAR2,
77 x_intake_target_type IN VARCHAR2
78 )
79 RETURN BOOLEAN;
80
81 PROCEDURE GET_FK_IGS_FI_FUND_SRC (
82 x_funding_source IN VARCHAR2
83 );
84
85 PROCEDURE GET_FK_IGS_ST_GVT_SPSHT_CTL (
86 x_submission_yr IN NUMBER,
87 x_submission_number IN NUMBER
88 );
89
90 PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
91 x_intake_target_type IN VARCHAR2
92 );
93
94 PROCEDURE GET_FK_IGS_OR_UNIT (
95 x_org_unit_cd IN VARCHAR2,
96 x_start_dt IN DATE
97 );
98
99 PROCEDURE GET_FK_IGS_PS_UNIT_INT_LVL (
100 x_unit_int_course_level_cd IN VARCHAR2
101 );
102
103 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
104 x_override_s_amount_type IN VARCHAR2
105 );
106
107 -- added to take care of check constraints
108 PROCEDURE CHECK_CONSTRAINTS(
109 column_name IN VARCHAR2 DEFAULT NULL,
110 column_value IN VARCHAR2 DEFAULT NULL
111 );
112
113 PROCEDURE Before_DML (
114 p_action IN VARCHAR2,
115 x_rowid IN VARCHAR2 DEFAULT NULL,
116 x_submission_yr IN NUMBER DEFAULT NULL,
117 x_submission_number IN NUMBER DEFAULT NULL,
118 x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
119 x_ou_start_dt IN DATE DEFAULT NULL,
120 x_funding_source IN VARCHAR2 DEFAULT NULL,
121 x_unit_int_course_level_cd IN VARCHAR2 DEFAULT NULL,
122 x_intake_target_type IN VARCHAR2 DEFAULT NULL,
123 x_target IN NUMBER DEFAULT NULL,
124 x_max_target IN NUMBER DEFAULT NULL,
125 x_override_s_amount_type IN VARCHAR2 DEFAULT NULL,
126 x_actual_enrolment IN NUMBER DEFAULT NULL,
127 x_actual_enr_effective_dt IN DATE DEFAULT NULL,
128 x_creation_date IN DATE DEFAULT NULL,
129 x_created_by IN NUMBER DEFAULT NULL,
130 x_last_update_date IN DATE DEFAULT NULL,
131 x_last_updated_by IN NUMBER DEFAULT NULL,
132 x_last_update_login IN NUMBER DEFAULT NULL
133 );
134
135 end IGS_AD_SBMAO_FN_UITT_PKG;