1 package igs_as_anon_grd_pkg as
2 /* $Header: IGSAS39S.pls 120.0 2005/07/05 12:18:02 appldev noship $ */
3
4 /*
5 || Created By : pkpatel
6 || Created On : 28-JAN-2002
7 || Purpose :
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || (reverse chronological order - newest change first)
12 */
13 FUNCTION chk_anon_graded (
14 p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
15 p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE
16 ) RETURN VARCHAR2;
17
18 PROCEDURE mnt_anon_id (
19 errbuf OUT NOCOPY VARCHAR2, -- Standard Error Buffer Variable
20 retcode OUT NOCOPY NUMBER, -- Standard Concurrent Return code
21 p_load_calendar IN VARCHAR2, -- Award Year ( Concatenated value of Calandar Type and Sequence Number )
22 p_min_number IN NUMBER, -- Minimum Number for the Range of Anonymous ID
23 p_max_number IN NUMBER, -- Maximum Number for the Range of Anonymous ID
24 p_reallocate_anon_id IN VARCHAR2 -- Y/N value to choose whether to reallocate Anonymous ID OR assign the existing ones.
25 );
26
27 FUNCTION get_anon_id (
28 p_person_id IN hz_parties.party_id%TYPE, -- Person ID
29 p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE, -- Course Code
30 p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE, -- Unit Code
31 p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
32 p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE, -- Teach Sequence Number
33 p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE, -- Unit Ofering Option ID
34 p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE, -- Assessment ID
35 p_unit_grading_ind IN VARCHAR2 -- Unit Grading Indicator
36 )RETURN VARCHAR2;
37
38
39 FUNCTION get_person_id (
40 p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE, -- Anonymous ID
41 p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
42 p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE -- Teach Sequence Number
43 ) RETURN NUMBER;
44
45
46 FUNCTION user_anon_id (
47 p_anonymous_number varchar2,
48 p_method igs_as_anon_method.METHOD%TYPE,
49 p_person_id hz_parties.party_id%TYPE,
50 p_course_cd igs_en_su_attempt_all.course_cd%TYPE,
51 p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
52 p_teach_cal_type igs_ca_inst_all.cal_type%TYPE,
53 p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
54 p_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55 p_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE,
56 p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
57 p_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
58 ) RETURN VARCHAR2;
59
60 END igs_as_anon_grd_pkg;