1 PACKAGE IGS_PR_GEN_004 AUTHID CURRENT_USER AS
2 /* $Header: IGSPR25S.pls 115.7 2003/05/30 07:17:02 kdande ship $ */
3 --
4 -- kdande; 23-Apr-2003; Bug# 2829262
5 -- Added p_uoo_id parameter to the PROCEDURE IGS_PR_ins_suao_todo
6 --
7 PROCEDURE igs_pr_ins_suao_todo (
8 p_person_id IN NUMBER,
9 p_course_cd IN VARCHAR2,
10 p_version_number IN NUMBER,
11 p_unit_cd IN VARCHAR2,
12 p_cal_type IN VARCHAR2,
13 p_ci_sequence_number IN NUMBER,
14 p_old_grading_schema_cd IN VARCHAR2,
15 p_new_grading_schema_cd IN VARCHAR ,
16 p_old_gs_version_number IN NUMBER,
17 p_new_gs_version_number IN NUMBER,
18 p_old_grade IN VARCHAR2,
19 p_new_grade IN VARCHAR2,
20 p_old_mark IN NUMBER,
21 p_new_mark IN NUMBER,
22 p_old_finalised_outcome_ind IN VARCHAR2,
23 p_new_finalised_outcome_ind IN VARCHAR2,
24 p_uoo_id IN NUMBER DEFAULT NULL
25 );
26 PROCEDURE igs_pr_upd_out_apply (
27 p_prg_cal_type IN VARCHAR2,
28 p_prg_sequence_number IN NUMBER,
29 p_course_type IN VARCHAR2,
30 p_org_unit_cd IN VARCHAR2,
31 p_ou_start_dt IN DATE ,
32 p_course_cd IN VARCHAR2,
33 p_location_cd IN VARCHAR2,
34 p_attendance_mode IN VARCHAR2,
35 p_progression_status IN VARCHAR2,
36 p_enrolment_cat IN VARCHAR2,
37 p_group_id IN NUMBER,
38 p_spo_person_id IN NUMBER,
39 p_spo_course_cd IN VARCHAR2,
40 p_spo_sequence_number IN NUMBER,
41 p_message_text IN OUT NOCOPY VARCHAR2,
42 p_message_level IN OUT NOCOPY VARCHAR2,
43 p_log_creation_dt OUT NOCOPY DATE
44 );
45 PROCEDURE igs_pr_upd_rule_apply (
46 p_prg_cal_type IN VARCHAR2,
47 p_prg_sequence_number IN NUMBER,
48 p_course_type IN VARCHAR2,
49 p_org_unit_cd IN VARCHAR2,
50 p_ou_start_dt IN DATE ,
51 p_course_cd IN VARCHAR2,
52 p_location_cd IN VARCHAR2,
53 p_attendance_mode IN VARCHAR2,
54 p_progression_status IN VARCHAR2,
55 p_enrolment_cat IN VARCHAR2,
56 p_group_id IN NUMBER,
57 p_processing_type IN VARCHAR2,
58 p_log_creation_dt OUT NOCOPY DATE
59 );
60 PROCEDURE igs_pr_upd_sca_apply (
61 p_person_id IN NUMBER,
62 p_course_cd IN VARCHAR2,
63 p_prg_cal_type IN VARCHAR2,
64 p_prg_sequence_number IN NUMBER,
65 p_application_type IN VARCHAR2,
66 p_log_creation_dt IN DATE ,
67 p_recommended_outcomes IN OUT NOCOPY NUMBER,
68 p_approved_outcomes IN OUT NOCOPY NUMBER,
69 p_removed_outcomes IN OUT NOCOPY NUMBER,
70 p_message_name OUT NOCOPY VARCHAR2
71 );
72 PROCEDURE igs_pr_upd_spo_aply_dt (
73 p_person_id IN NUMBER,
74 p_course_cd IN VARCHAR2,
75 p_sequence_number IN NUMBER
76 );
77 PROCEDURE igs_pr_upd_spo_maint (
78 errbuf OUT NOCOPY VARCHAR2,
79 retcode OUT NOCOPY NUMBER
80 );
81 END IGS_PR_GEN_004;