1 PACKAGE igs_as_adi_upld_pr_pkg AS
2 /* $Header: IGSPR33S.pls 120.0 2005/07/05 11:26:29 appldev noship $ */
3 --
4 -- Validate the records before inserting into base table and call the table handlers
5 --
6 PROCEDURE progression_outcome_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 uploading.
16 -- This validation is called from the interface table import routine,
17 -- and also the ADI pre-validation functionality.
18 --
19 PROCEDURE igs_as_pr_val_upld (
20 p_person_number IN VARCHAR2,
21 p_anonymous_id IN VARCHAR2,
22 p_course_cd IN VARCHAR2,
23 p_progression_outcome_type IN VARCHAR2,
24 p_person_id OUT NOCOPY NUMBER,
25 p_prg_cal_type OUT NOCOPY VARCHAR2,
26 p_prg_ci_sequence_number OUT NOCOPY NUMBER,
27 p_error_code OUT NOCOPY VARCHAR2,
28 p_load_file_flag OUT NOCOPY VARCHAR2,
29 p_load_record_flag OUT NOCOPY VARCHAR2,
30 p_unit_set_cd OUT NOCOPY igs_as_su_setatmpt.unit_set_cd%TYPE,
31 p_us_version_number OUT NOCOPY igs_as_su_setatmpt.us_version_number%TYPE,
32 p_sequence_number OUT NOCOPY igs_he_en_susa.sequence_number%TYPE,
33 p_mark IN NUMBER,
34 p_grade IN OUT NOCOPY VARCHAR2
35 );
36 --
37 -- API to upload the Progression and Unit Outcomes from Web ADI that is used
38 -- to upload multiple outcomes for Progression and Unit together from a
39 -- single spreadsheet.
40 --
41 -- This routine calls the existing routines for Progression and Unit Grading
42 -- that validate and upload the data from Web ADI to corresponding OSS tables.
43 --
44 PROCEDURE prog_ug_process (
45 errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY NUMBER,
47 p_user_id IN NUMBER,
48 p_batch_datetime IN VARCHAR2,
49 p_grade_creation_method_type IN VARCHAR2,
50 p_delete_rows IN VARCHAR2 DEFAULT 'Y'
51 );
52 --
53 -- API to upload the Progression, Unit and Assessment Item Outcomes from
54 -- Web ADI that is used to upload multiple outcomes for Progression, Unit
55 -- and Assessment Items together from a single spreadsheet.
56 --
57 -- This routine calls the existing routines for Progression, Unit Grading
58 -- and Assessment Item that validate and upload the data from Web ADI to
59 -- corresponding OSS tables.
60 --
61 PROCEDURE prog_ug_aio_process (
62 errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY NUMBER,
64 p_user_id IN NUMBER,
65 p_batch_datetime IN VARCHAR2,
66 p_grade_creation_method_type IN VARCHAR2,
67 p_delete_rows IN VARCHAR2 DEFAULT 'Y'
68 );
69 --
70 END igs_as_adi_upld_pr_pkg;