1 PACKAGE igs_as_adi_upld_aio_pkg AS
2 /* $Header: IGSAS44S.pls 120.0 2005/07/05 11:31:46 appldev noship $ */
3 --
4 -- Get year of program for student unit set attempt
5 --
6 FUNCTION get_sua_yop (
7 p_person_id IN igs_en_su_attempt.person_id%TYPE,
8 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
9 p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
10 p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
11 ) RETURN VARCHAR2;
12 --
13 -- Validate the records before inserting into base table and call the table handlers
14 --
15 PROCEDURE assessment_item_grade_process (
16 errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY NUMBER,
18 p_user_id IN NUMBER,
19 p_batch_datetime IN VARCHAR2,
20 p_grade_creation_method_type IN VARCHAR2,
21 p_delete_rows IN VARCHAR2 DEFAULT 'Y'
22 );
23 --
24 -- Validate the records before inserting into base table and call the table handlers
25 -- This is a wrapper API to the Grade Unit and Grade Assessment Item API's
26 --
27 PROCEDURE assmnt_item_grade_unit_process (
28 errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30 p_user_id IN NUMBER,
31 p_batch_datetime IN VARCHAR2,
32 p_grade_creation_method_type IN VARCHAR2,
33 p_delete_rows IN VARCHAR2 DEFAULT 'Y'
34 );
35 --
36 -- Validate single Assessment Item Outcome record from the interface table before being uploaded.
37 -- This validation is called from the interface table import routine,
38 -- and also the ADI pre-validation functionality.
39 --
40 PROCEDURE igs_as_aio_val_upld (
41 p_person_number IN VARCHAR2,
42 p_person_id OUT NOCOPY NUMBER,
43 p_anonymous_id IN VARCHAR2,
44 p_course_cd IN VARCHAR2,
45 p_unit_cd IN VARCHAR2,
46 p_cal_type IN OUT NOCOPY VARCHAR2,
47 p_ci_sequence_number IN OUT NOCOPY NUMBER,
48 p_alternate_code IN VARCHAR2,
49 p_ass_id IN OUT NOCOPY NUMBER,
50 p_assessment_type IN VARCHAR2,
51 p_reference IN VARCHAR2,
52 p_grading_schema_cd OUT NOCOPY VARCHAR2,
53 p_gs_version_number OUT NOCOPY NUMBER,
54 p_grade IN OUT NOCOPY VARCHAR2,
55 p_mark IN NUMBER,
56 p_error_code OUT NOCOPY VARCHAR2,
57 p_ret_val OUT NOCOPY BOOLEAN,
58 p_insert_flag OUT NOCOPY VARCHAR2,
59 p_load_flag OUT NOCOPY VARCHAR2,
60 p_unit_class IN VARCHAR2 DEFAULT NULL,
61 p_location_cd IN VARCHAR2 DEFAULT NULL,
62 p_override_due_dt IN DATE DEFAULT NULL,
63 p_penalty_applied_flag IN VARCHAR2 DEFAULT NULL,
64 p_waived_flag IN VARCHAR2 DEFAULT NULL,
65 p_submitted_date IN DATE DEFAULT NULL,
66 p_uoo_id IN NUMBER DEFAULT NULL
67 );
68
69 --Validate the user while upload and download of ADI data
70 FUNCTION isvaliduser (
71 p_userid IN NUMBER,
72 p_uoo_id IN NUMBER DEFAULT NULL,
73 p_group_id IN NUMBER DEFAULT NULL
74 )RETURN VARCHAR2;
75
76
77 END igs_as_adi_upld_aio_pkg;