1 package IGS_AD_PS_APPL_PKG as
2 /* $Header: IGSAI16S.pls 120.0 2005/06/01 20:53:31 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_ORG_ID in NUMBER,
6 X_PERSON_ID in NUMBER,
7 X_ADMISSION_APPL_NUMBER in NUMBER,
8 X_NOMINATED_COURSE_CD in VARCHAR2,
9 X_TRANSFER_COURSE_CD in VARCHAR2,
10 X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
11 X_ADMISSION_CD in VARCHAR2,
12 X_COURSE_RANK_SET in VARCHAR2,
13 X_COURSE_RANK_SCHEDULE in VARCHAR2,
14 X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
15 X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
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_ADMISSION_APPL_NUMBER in NUMBER,
22 X_NOMINATED_COURSE_CD in VARCHAR2,
23 X_TRANSFER_COURSE_CD in VARCHAR2,
24 X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
25 X_ADMISSION_CD in VARCHAR2,
26 X_COURSE_RANK_SET in VARCHAR2,
27 X_COURSE_RANK_SCHEDULE in VARCHAR2,
28 X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
29 X_REQ_FOR_ADV_STANDING_IND in VARCHAR2
30 );
31 procedure UPDATE_ROW (
32 X_ROWID in VARCHAR2,
33 X_PERSON_ID in NUMBER,
34 X_ADMISSION_APPL_NUMBER in NUMBER,
35 X_NOMINATED_COURSE_CD in VARCHAR2,
36 X_TRANSFER_COURSE_CD in VARCHAR2,
37 X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
38 X_ADMISSION_CD in VARCHAR2,
39 X_COURSE_RANK_SET in VARCHAR2,
40 X_COURSE_RANK_SCHEDULE in VARCHAR2,
41 X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
42 X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
43 X_MODE in VARCHAR2 default 'R'
44 );
45 procedure ADD_ROW (
46 X_ROWID in out NOCOPY VARCHAR2,
47 X_ORG_ID in NUMBER,
48 X_PERSON_ID in NUMBER,
49 X_ADMISSION_APPL_NUMBER in NUMBER,
50 X_NOMINATED_COURSE_CD in VARCHAR2,
51 X_TRANSFER_COURSE_CD in VARCHAR2,
52 X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
53 X_ADMISSION_CD in VARCHAR2,
54 X_COURSE_RANK_SET in VARCHAR2,
55 X_COURSE_RANK_SCHEDULE in VARCHAR2,
56 X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
57 X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
58 X_MODE in VARCHAR2 default 'R'
59 );
60 procedure DELETE_ROW (
61 X_ROWID in VARCHAR2,
62 x_mode IN VARCHAR2 DEFAULT 'R'
63 );
64
65 FUNCTION Get_PK_For_Validation (
66 x_person_id IN NUMBER,
67 x_admission_appl_number IN NUMBER,
68 x_nominated_course_cd IN VARCHAR2
69 )
70 RETURN BOOLEAN;
71
72 PROCEDURE GET_FK_IGS_AD_APPL (
73 x_person_id IN NUMBER,
74 x_admission_appl_number IN NUMBER
75 );
76
77 PROCEDURE GET_FK_IGS_AD_CD (
78 x_admission_cd IN VARCHAR2
79 );
80
81 PROCEDURE GET_FK_IGS_AD_BASIS_FOR_AD (
82 x_basis_for_admission_type IN VARCHAR2
83 );
84
85 PROCEDURE GET_FK_IGS_PS_COURSE (
86 x_course_cd IN VARCHAR2
87 );
88
89 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
90 x_person_id IN NUMBER,
91 x_course_cd IN VARCHAR2
92 );
93
94
95 -- added to take care of check constraints
96 PROCEDURE CHECK_CONSTRAINTS(
97 column_name IN VARCHAR2 DEFAULT NULL,
98 column_value IN VARCHAR2 DEFAULT NULL
99 );
100
101 PROCEDURE Before_DML (
102 p_action IN VARCHAR2,
103 x_rowid IN VARCHAR2 DEFAULT NULL,
104 X_ORG_ID in NUMBER DEFAULT NULL,
105 x_person_id IN NUMBER DEFAULT NULL,
106 x_admission_appl_number IN NUMBER DEFAULT NULL,
107 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
108 x_transfer_course_cd IN VARCHAR2 DEFAULT NULL,
109 x_basis_for_admission_type IN VARCHAR2 DEFAULT NULL,
110 x_admission_cd IN VARCHAR2 DEFAULT NULL,
111 x_course_rank_set IN VARCHAR2 DEFAULT NULL,
112 x_course_rank_schedule IN VARCHAR2 DEFAULT NULL,
113 x_req_for_reconsideration_ind IN VARCHAR2 DEFAULT NULL,
114 x_req_for_adv_standing_ind IN VARCHAR2 DEFAULT NULL,
115 x_creation_date IN DATE DEFAULT NULL,
116 x_created_by IN NUMBER DEFAULT NULL,
117 x_last_update_date IN DATE DEFAULT NULL,
118 x_last_updated_by IN NUMBER DEFAULT NULL,
119 x_last_update_login IN NUMBER DEFAULT NULL
120 );
121
122 end IGS_AD_PS_APPL_PKG;