1 PACKAGE igs_as_adi_upld_ug_pkg AS
2 /* $Header: IGSAS43S.pls 120.0 2005/07/05 12:31:11 appldev noship $ */
3 --
4 -- Validate the records before inserting into base table and call the table handlers
5 --
6 PROCEDURE grading_period_grade_process (
7 errbuf OUT NOCOPY VARCHAR2,
8 retcode OUT NOCOPY NUMBER,
9 p_user_id IN NUMBER,
10 p_batch_datetime IN VARCHAR2,
11 p_grade_creation_method_type IN VARCHAR2,
12 p_delete_rows IN VARCHAR2 DEFAULT 'Y'
13 );
14 --
15 -- Validate single Grading Period record from the interface table before
16 -- being uploaded. This validation is called from the interface table import
17 -- routine, and also the ADI pre-validation functionality.
18 --
19 PROCEDURE igs_as_ug_val_upld (
20 p_person_number IN VARCHAR2,
21 p_anonymous_id IN VARCHAR2,
22 p_alternate_code IN VARCHAR2,
23 p_course_cd IN VARCHAR2,
24 p_unit_cd IN VARCHAR2,
25 p_grading_period_cd IN VARCHAR2,
26 p_mark IN NUMBER,
27 p_grade IN OUT NOCOPY VARCHAR2,
28 p_person_id OUT NOCOPY NUMBER,
29 p_cal_type IN OUT NOCOPY VARCHAR2,
30 p_ci_sequence_number IN OUT NOCOPY NUMBER,
31 p_ci_start_dt OUT NOCOPY DATE,
32 p_ci_end_dt OUT NOCOPY DATE,
33 p_grading_schema_cd OUT NOCOPY VARCHAR2,
34 p_gs_version_number OUT NOCOPY NUMBER,
35 p_error_code OUT NOCOPY VARCHAR2,
36 p_load_file_flag OUT NOCOPY VARCHAR2,
37 p_load_record_flag OUT NOCOPY VARCHAR2,
38 p_unit_class IN VARCHAR2,
39 p_location_cd IN VARCHAR2,
40 manual_override_flag IN VARCHAR2,
41 mark_capped_flag IN VARCHAR2,
42 release_date IN DATE,
43 p_uoo_id IN NUMBER DEFAULT NULL
44 );
45 END igs_as_adi_upld_ug_pkg;