1 PACKAGE Igs_Ad_Acad_History_Pkg AS
2 /* $Header: IGSAI81S.pls 120.0 2005/06/01 21:10:01 appldev noship $ */
3 PROCEDURE insert_row (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_attribute14 IN VARCHAR2,
6 x_attribute15 IN VARCHAR2,
7 x_attribute16 IN VARCHAR2,
8 x_attribute17 IN VARCHAR2,
9 x_attribute18 IN VARCHAR2,
10 x_attribute19 IN VARCHAR2,
11 x_attribute20 IN VARCHAR2,
12 x_attribute13 IN VARCHAR2,
13 x_attribute11 IN VARCHAR2,
14 x_attribute12 IN VARCHAR2,
15 x_education_id OUT NOCOPY NUMBER,
16 x_person_id IN NUMBER,
17 x_current_inst IN VARCHAR2,
18 x_degree_attempted IN VARCHAR2 DEFAULT NULL,
19 x_program_code IN VARCHAR2,
20 x_degree_earned IN VARCHAR2 DEFAULT NULL,
21 x_comments IN VARCHAR2,
22 x_start_date IN DATE,
23 x_end_date IN DATE,
24 x_planned_completion_date IN DATE,
25 x_recalc_total_cp_attempted IN NUMBER,
26 x_recalc_total_cp_earned IN NUMBER,
27 x_recalc_total_unit_gp IN NUMBER,
28 x_recalc_tot_gpa_units_attemp IN NUMBER,
29 x_recalc_inst_gpa IN VARCHAR2,
30 x_recalc_grading_scale_id IN NUMBER,
31 x_selfrep_total_cp_attempted IN NUMBER,
32 x_selfrep_total_cp_earned IN NUMBER,
33 x_selfrep_total_unit_gp IN NUMBER,
34 X_selfrep_tot_gpa_uts_attemp IN NUMBER,
35 x_selfrep_inst_gpa IN VARCHAR2,
36 x_selfrep_grading_scale_id IN NUMBER,
37 x_selfrep_weighted_gpa IN VARCHAR2,
38 x_selfrep_rank_in_class IN NUMBER,
39 x_selfrep_weighed_rank IN VARCHAR2,
40 x_type_of_school IN VARCHAR2,
41 x_institution_code IN VARCHAR2,
42 x_attribute_category IN VARCHAR2,
43 x_attribute1 IN VARCHAR2,
44 x_attribute2 IN VARCHAR2,
45 x_attribute3 IN VARCHAR2,
46 x_attribute4 IN VARCHAR2,
47 x_attribute5 IN VARCHAR2,
48 x_attribute6 IN VARCHAR2,
49 x_attribute7 IN VARCHAR2,
50 x_attribute8 IN VARCHAR2,
51 x_attribute9 IN VARCHAR2,
52 x_attribute10 IN VARCHAR2,
53 x_selfrep_class_size IN NUMBER DEFAULT NULL,
54 x_transcript_required IN VARCHAR2 DEFAULT NULL,
55 x_school_party_id IN NUMBER DEFAULT NULL,
56 x_status IN VARCHAR2 DEFAULT NULL,
57 x_object_version_number OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_mode IN VARCHAR2 DEFAULT NULL,
61 x_school_attended_name IN VARCHAR2 DEFAULT NULL,
62 x_program_type_attempted IN VARCHAR2 DEFAULT NULL,
63 x_program_type_earned IN VARCHAR2 DEFAULT NULL
64
65 );
66 PROCEDURE update_row (
67 x_rowid IN VARCHAR2,
68 x_attribute14 IN VARCHAR2,
69 x_attribute15 IN VARCHAR2,
70 x_attribute16 IN VARCHAR2,
71 x_attribute17 IN VARCHAR2,
72 x_attribute18 IN VARCHAR2,
73 x_attribute19 IN VARCHAR2,
74 x_attribute20 IN VARCHAR2,
75 x_attribute13 IN VARCHAR2,
76 x_attribute11 IN VARCHAR2,
77 x_attribute12 IN VARCHAR2,
78 x_education_id IN NUMBER,
79 x_person_id IN NUMBER,
80 x_current_inst IN VARCHAR2,
81 x_degree_attempted IN VARCHAR2 DEFAULT NULL,
82 x_program_code IN VARCHAR2,
83 x_degree_earned IN VARCHAR2 DEFAULT NULL,
84 x_comments IN VARCHAR2,
85 x_start_date IN DATE,
86 x_end_date IN DATE,
87 x_planned_completion_date IN DATE,
88 x_recalc_total_cp_attempted IN NUMBER,
89 x_recalc_total_cp_earned IN NUMBER,
90 x_recalc_total_unit_gp IN NUMBER,
91 x_recalc_tot_gpa_units_attemp IN NUMBER,
92 x_recalc_inst_gpa IN VARCHAR2,
93 x_recalc_grading_scale_id IN NUMBER,
94 x_selfrep_total_cp_attempted IN NUMBER,
95 x_selfrep_total_cp_earned IN NUMBER,
96 x_selfrep_total_unit_gp IN NUMBER,
97 x_selfrep_tot_gpa_uts_attemp IN NUMBER,
98 x_selfrep_inst_gpa IN VARCHAR2,
99 x_selfrep_grading_scale_id IN NUMBER,
100 x_selfrep_weighted_gpa IN VARCHAR2,
101 x_selfrep_rank_in_class IN NUMBER,
102 x_selfrep_weighed_rank IN VARCHAR2,
103 x_type_of_school IN VARCHAR2,
104 x_institution_code IN VARCHAR2,
105 x_attribute_category IN VARCHAR2,
106 x_attribute1 IN VARCHAR2,
107 x_attribute2 IN VARCHAR2,
108 x_attribute3 IN VARCHAR2,
109 x_attribute4 IN VARCHAR2,
110 x_attribute5 IN VARCHAR2,
111 x_attribute6 IN VARCHAR2,
112 x_attribute7 IN VARCHAR2,
113 x_attribute8 IN VARCHAR2,
114 x_attribute9 IN VARCHAR2,
115 x_attribute10 IN VARCHAR2,
116 x_selfrep_class_size IN NUMBER DEFAULT NULL,
117 x_transcript_required IN VARCHAR2 DEFAULT NULL,
118 x_school_party_id IN NUMBER DEFAULT NULL,
119 x_status IN VARCHAR2 DEFAULT NULL,
120 x_object_version_number IN OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_mode IN VARCHAR2 DEFAULT NULL,
124 x_school_attended_name IN VARCHAR2 DEFAULT NULL,
125 x_program_type_attempted IN VARCHAR2 DEFAULT NULL,
126 x_program_type_earned IN VARCHAR2 DEFAULT NULL
127 );
128 END Igs_Ad_Acad_History_Pkg;