1 PACKAGE IGS_AS_GEN_006 AS
2 /* $Header: IGSAS06S.pls 120.0 2005/07/05 13:00:44 appldev noship $ */
3
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 --Who When What
7 -- Aiyer 08-APR-2002 Bug No. 2124034. The parameter p_reproduce was also added as a hidden parameter in the
8 -- concurrent job IGSASJ05 Produce Student Assignment Cover Sheet with a default value as 'NO'.
9 -- In the package body of porocedure too it was made to have a default value of 'NO'.
10 -------------------------------------------------------------------------------------------------------------------------
11
12
13 PROCEDURE assp_get_ese_key(
14 p_exam_cal_type IN OUT NOCOPY VARCHAR2 ,
15 p_exam_ci_sequence_number IN OUT NOCOPY NUMBER ,
16 p_dt_alias IN OUT NOCOPY VARCHAR2 ,
17 p_dai_sequence_number IN OUT NOCOPY NUMBER ,
18 p_start_time IN OUT NOCOPY DATE ,
19 p_end_time IN OUT NOCOPY DATE ,
20 p_ese_id IN OUT NOCOPY NUMBER );
21
22 PROCEDURE assp_ins_admin_grds(
23 errbuf out NOCOPY varchar2,
24 retcode out NOCOPY number,
25 p_assess_calendar IN VARCHAR2 ,
26 p_teaching_calendar IN VARCHAR2,
27 p_org_unt_cd IN VARCHAR2 ,
28 p_unt_cd VARCHAR2 ,
29 p_lctn_cd IN VARCHAR2 ,
30 p_unt_md IN VARCHAR2 ,
31 p_unt_cls IN VARCHAR2 ,
32 p_insert_default_ind IN VARCHAR2 ,
33 p_grade IN VARCHAR2 ,
34 p_finalised_ind IN VARCHAR2 ,
35 p_assble_type IN VARCHAR2 ,
36 p_no_assmnt_type IN VARCHAR2,
37 p_org_id IN NUMBER ,
38 --added by lkaki--
39 p_audit_grade IN VARCHAR2 DEFAULT NULL);
40
41 PROCEDURE assp_ins_aia(
42 p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
43 p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
44 p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,
45 p_primary_assessor_ind IN IGS_AS_ITEM_ASSESSOR.primary_assessor_ind%TYPE ,
46 p_item_limit IN IGS_AS_ITEM_ASSESSOR.item_limit%TYPE ,
47 p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
48 p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
49 p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
50 p_comments IN IGS_AS_ITEM_ASSESSOR.comments%TYPE );
51
52 PROCEDURE assp_ins_aia_default(
53 p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
54 p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
55 p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE );
56
57 PROCEDURE assp_ins_ai_cvr_sht(
58 errbuf out NOCOPY varchar2,
59 retcode out NOCOPY number,
60 p_acad_calendar IN VARCHAR2,
61 p_teach_calendar IN VARCHAR2,
62 p_crs_cd VARCHAR2 ,
63 p_unt_cd IN VARCHAR2 ,
64 p_lctn_cd IN VARCHAR2 ,
65 p_unt_cls IN VARCHAR2 ,
66 p_unt_md IN VARCHAR2 ,
67 p_person_id IN NUMBER ,
68 p_ass_id NUMBER ,
69 p_reprdc IN VARCHAR2 DEFAULT 'N',
70 p_org_id IN NUMBER);
71
72 PROCEDURE assp_ins_asr1020_tmp(
73 p_ass_perd_cal_type IN VARCHAR2 ,
74 p_ass_perd_sequence_number IN NUMBER ,
75 p_owner_org_unit_cd IN VARCHAR2 ,
76 p_owner_ou_start_dt IN DATE ,
77 p_unit_mode IN VARCHAR2 );
78
79 PROCEDURE assp_ins_dflt_evsa_a(
80 errbuf out NOCOPY varchar2,
81 retcode out NOCOPY number,
82 p_exam_cal varchar2,
83 p_org_id IN NUMBER
84 );
85
86 PROCEDURE assp_ins_ese_sprvsr(
87 p_exam_cal_type IN VARCHAR2 ,
88 p_exam_ci_sequence_number IN NUMBER ,
89 p_person_id IN NUMBER ,
90 p_exam_supervisor_type IN VARCHAR2 ,
91 p_venue_cd IN VARCHAR2 ,
92 p_session_venue_ind IN VARCHAR2 DEFAULT 'N',
93 p_ignore_warnings_ind IN VARCHAR2 DEFAULT 'N',
94 p_message_name OUT NOCOPY VARCHAR2 );
95
96 PROCEDURE assp_ins_gs_duprec(
97 p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
98 p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
99 p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
100 p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
101 p_message_name OUT NOCOPY VARCHAR2 );
102
103 PROCEDURE assp_upd_suao_trans(
104 errbuf out NOCOPY varchar2,
105 retcode out NOCOPY number,
106 p_assess_calendar IN VARCHAR2 ,
107 p_teaching_calendar IN VARCHAR2,
108 p_crs_grp_cd IN VARCHAR2 ,
109 p_crs_cd IN VARCHAR2 ,
110 p_crs_org_unt_cd IN VARCHAR2 ,
111 p_crs_lctn_cd IN VARCHAR2 ,
112 p_crs_attd_md IN VARCHAR2 ,
113 p_unt_cd IN VARCHAR2 ,
114 p_unt_org_unt_cd IN VARCHAR2 ,
115 p_unt_lctn_cd IN VARCHAR2 ,
116 p_u_mode IN VARCHAR2 ,
117 p_u_class IN VARCHAR2 ,
118 p_allow_invalid_ind IN VARCHAR2,
119 p_org_id in NUMBER );
120
121 END IGS_AS_GEN_006 ;