1 PACKAGE igs_av_val_asuleb AUTHID CURRENT_USER AS
2 /* $Header: IGSAV07S.pls 115.6 2003/12/09 10:41:06 nalkumar ship $ */
3
4 -- To validate the basis year advanced standing units or levels.
5 FUNCTION advp_val_basis_year(
6 p_basis_year IN NUMBER ,
7 p_course_cd IN VARCHAR2 ,
8 p_version_number IN NUMBER ,
9 p_message_name OUT NOCOPY VARCHAR2,
10 p_return_type OUT NOCOPY VARCHAR2 )
11 RETURN BOOLEAN;
12
13 --
14 -- To validate the Advanced Standing records when a new Transcript is submitted.
15 -- Added as part of RECR50; Bug# 3270446
16 --
17 PROCEDURE validate_transcript(
18 p_person_id IN NUMBER,
19 p_education_id IN NUMBER,
20 p_transcript_id IN NUMBER);
21
22 --
23 -- To set the Advanced Standing Work Flow Role.
24 -- Added as part of RECR50; Bug# 3270446
25 --
26 PROCEDURE wf_set_role(
27 itemtype IN VARCHAR2,
28 itemkey IN VARCHAR2,
29 actid IN NUMBER ,
30 funcmode IN VARCHAR2,
31 resultout OUT NOCOPY VARCHAR2);
32
33 --
34 -- To launch the Advanced Standing Workflow
35 -- Added as part of RECR50; Bug# 3270446
36 --
37 PROCEDURE create_transcript(
38 document_id IN VARCHAR2,
39 display_type IN VARCHAR2,
40 document IN OUT NOCOPY CLOB,
41 document_type IN OUT NOCOPY VARCHAR2);
42
43 --
44 -- To set Atteribute values of the Advanced Standing Notifications.
45 -- Added as part of RECR50; Bug# 3270446
46 --
47 PROCEDURE get_transcript_data(
48 p_itemtype IN VARCHAR2,
49 p_itemkey IN VARCHAR2,
50 p_person_id IN NUMBER,
51 p_education_id IN NUMBER,
52 p_transcript_id IN NUMBER);
53
54 END igs_av_val_asuleb;