PACKAGE: APPS.IGS_AV_GEN_001

Source

1 PACKAGE IGS_AV_GEN_001 AS
2 /* $Header: IGSAV01S.pls 120.5 2005/11/24 01:15:16 appldev ship $ */
3 
4 
5 FUNCTION advp_del_adv_stnd(
6   p_person_id IN NUMBER ,
7   p_course_cd IN VARCHAR2 ,
8   p_message_name OUT NOCOPY VARCHAR2 ,
9   p_default_message OUT NOCOPY VARCHAR2 )
10 RETURN BOOLEAN ;
11 
12 FUNCTION advp_get_as_total(
13   p_person_id IN NUMBER ,
14   p_course_cd IN VARCHAR2 ,
15   p_effective_dt IN DATE )
16 RETURN NUMBER ;
17 
18 PRAGMA RESTRICT_REFERENCES (advp_get_as_total,WNDS,WNPS);
19 
20 PROCEDURE advp_upd_as_grant(errbuf   out NOCOPY   varchar2,
21 			    retcode  out NOCOPY   number,
22 			    p_org_id IN    NUMBER);
23 
24 FUNCTION advp_upd_as_inst(
25   p_person_id IN NUMBER ,
26   p_course_cd IN VARCHAR2 ,
27   p_version_number IN NUMBER ,
28   p_message_name OUT NOCOPY VARCHAR2 )
29 RETURN BOOLEAN ;
30 
31 PROCEDURE advp_upd_as_pe_expry
32        ( errbuf   OUT NOCOPY  varchar2,
33          retcode  OUT NOCOPY  number,
34 	 p_org_id IN   NUMBER  );
35 
36 FUNCTION advp_upd_as_pe_grant(
37   p_person_id IN NUMBER ,
38   p_course_cd IN VARCHAR2 ,
39   p_version_number IN NUMBER ,
40   p_granted_dt IN DATE ,
41   p_process_type IN VARCHAR2 ,
42   p_s_log_type IN OUT NOCOPY VARCHAR2 ,
43   p_creation_dt IN OUT NOCOPY DATE ,
44   p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46 
47 FUNCTION advp_upd_as_totals(
48   p_person_id IN NUMBER ,
49   p_course_cd IN VARCHAR2 ,
50   p_version_number IN NUMBER ,
51   p_message_name OUT NOCOPY VARCHAR2,
52   p_exemption_institution_cd IN VARCHAR2 DEFAULT NULL)
53 RETURN BOOLEAN;
54 
55 FUNCTION advp_upd_sua_advstnd(
56   p_person_id IN NUMBER ,
57   p_course_cd IN VARCHAR2 ,
58   p_unit_cd IN VARCHAR2 ,
59   p_version_number IN NUMBER ,
60   p_granted_dt IN DATE ,
61   p_message_name OUT NOCOPY VARCHAR2 )
62 RETURN BOOLEAN ;
63 
64 FUNCTION upd_sua_advstnd(
65   p_person_id IN NUMBER ,
66   p_course_cd IN VARCHAR2 ,
67   p_unit_cd IN VARCHAR2 ,
68   p_version_number IN NUMBER ,
69   p_granted_dt IN DATE ,
70   p_message_name OUT NOCOPY VARCHAR2 )
71 RETURN VARCHAR2 ;
72 
73  PROCEDURE advp_create_basis(
74   p_person_id IN NUMBER ,
75   p_course_cd IN VARCHAR2 ,
76   p_version_number IN NUMBER );
77 
78   FUNCTION advp_val_basis_year(
79   p_basis_year IN NUMBER ,
80   p_course_cd IN VARCHAR2 ,
81   p_version_number IN NUMBER ,
82   p_message_name OUT NOCOPY VARCHAR2,
83   p_return_type OUT NOCOPY VARCHAR2 )
84   RETURN VARCHAR2;
85 
86 FUNCTION eval_unit_repeat (
87     p_person_id                    IN     NUMBER,
88     p_load_cal_type                IN     VARCHAR2,
89     p_load_cal_seq_number          IN     NUMBER,
90     p_uoo_id                       IN     NUMBER,
91     p_program_cd                   IN     VARCHAR2,
92     p_program_version              IN     NUMBER,
93     p_message                      IN OUT NOCOPY VARCHAR2,
94     p_deny_warn                    IN     VARCHAR2,
95     p_repeat_tag                   OUT NOCOPY    VARCHAR2 ,
96     p_unit_cd                      IN     VARCHAR2  ,
97     p_unit_version                 IN     NUMBER,
98     p_calling_obj	           IN VARCHAR2
99   ) RETURN VARCHAR2 ;
100 
101  PROCEDURE advp_updt_advstnd(
102   p_person_id IN NUMBER ,
103   p_course_cd IN VARCHAR2 ,
104   p_version_number IN NUMBER );
105 
106 
107  PROCEDURE adv_validate_grade(
108   p_grdschcode IN VARCHAR2,
109   p_grde IN VARCHAR2,
110   p_grschverno IN NUMBER,
111   validity OUT NOCOPY VARCHAR2 );
112 
113  PROCEDURE adv_cal_creditpts (
114  p_personid IN NUMBER,
115  p_coursecd IN VARCHAR2,
116  p_unitsetcd IN VARCHAR2,
117  p_usverno IN VARCHAR2,
118  creditpts OUT NOCOPY NUMBER);
119 
120 END IGS_AV_GEN_001 ;