PACKAGE: APPS.IGS_IN_GEN_001

Source

1 PACKAGE igs_in_gen_001   AS
2   /* $Header: IGSIN01S.pls 120.0 2005/06/01 16:58:28 appldev noship $ */
3 /*
4 | Who         When            What
5 |
6 | knaraset  09-May-03   Modified inqp_get_sua_achvd to add parameter p_uoo_id,
7 |                       as part of MUS build bug 2829262
8 |
9 */
10 FUNCTION inqp_get_appl_ind(
11   p_person_id IN NUMBER )
12 RETURN BOOLEAN ;
13 --PRAGMA RESTRICT_REFERENCES (inqp_get_appl_ind,WNDS);
14 
15 FUNCTION inqp_get_encmb(
16   p_person_id IN NUMBER ,
17   p_course_cd IN VARCHAR2 ,
18   p_level IN VARCHAR2 ,
19   p_effective_dt IN DATE ,
20   p_serious_only_ind IN VARCHAR2 ,
21   p_include_all_course_ind IN VARCHAR2 ,
22   p_academic_ind OUT NOCOPY VARCHAR2 ,
23   p_admin_ind OUT NOCOPY VARCHAR2 )
24 RETURN boolean ;
25 --PRAGMA RESTRICT_REFERENCES (inqp_get_encmb,WNDS);
26 PROCEDURE inqp_get_enr_cat(
27   p_person_id IN NUMBER ,
28   p_course_cd IN VARCHAR2 ,
29   p_enrolment_cat OUT NOCOPY VARCHAR2 ,
30   p_description OUT NOCOPY VARCHAR2 );
31 
32 PROCEDURE inqp_get_prg_cp(
33   p_person_id IN NUMBER ,
34   p_course_cd IN VARCHAR2 ,
35   p_version_number IN NUMBER ,
36   p_cp_required OUT NOCOPY NUMBER ,
37   p_cp_passed OUT NOCOPY NUMBER ,
38   p_adv_granted OUT NOCOPY NUMBER ,
39   p_enrolled_cp OUT NOCOPY NUMBER ,
40   p_cp_remaining OUT NOCOPY NUMBER );
41 
42 PROCEDURE inqp_get_sca_status(
43   p_person_id IN NUMBER ,
44   p_course_cd IN VARCHAR2 ,
45   p_course_attempt_status IN VARCHAR2 ,
46   p_commencement_dt IN DATE ,
47   p_discontinued_dt IN DATE ,
48   p_discontinuation_reason_cd IN VARCHAR2 ,
49   p_lapsed_dt IN DATE ,
50   p_status_dt OUT NOCOPY DATE ,
51   p_reason_cd OUT NOCOPY VARCHAR2 ,
52   p_description OUT NOCOPY VARCHAR2 );
53 
54 PROCEDURE inqp_get_scho(
55   p_person_id IN NUMBER ,
56   p_course_cd IN VARCHAR2 ,
57   p_hecs_payment_option OUT NOCOPY VARCHAR2 ,
58   p_tax_file_number_ind OUT NOCOPY VARCHAR2 ,
59   p_start_dt OUT NOCOPY DATE ,
60   p_end_dt OUT NOCOPY DATE );
61 
62 PROCEDURE inqp_get_sci(
63   p_person_id IN NUMBER ,
64   p_course_cd IN VARCHAR2 ,
65   p_start_dt OUT NOCOPY DATE ,
66   p_end_dt OUT NOCOPY DATE ,
67   p_voluntary_ind OUT NOCOPY VARCHAR2 );
68 
69 FUNCTION inqp_get_sua_achvd(
70   p_person_id IN NUMBER ,
71   p_course_cd IN VARCHAR2 ,
72   p_unit_cd IN VARCHAR2 ,
73   p_cal_type IN VARCHAR2 ,
74   p_ci_sequence_number IN NUMBER ,
75   p_version_number IN NUMBER ,
76   p_ci_end_dt IN DATE ,
77   p_unit_attempt_status IN VARCHAR2 ,
78   p_override_achievable_cp IN NUMBER ,
79   p_s_result_type IN VARCHAR2 ,
80   p_repeatable_ind IN VARCHAR2 ,
81   p_achievable_credit_points IN NUMBER ,
82   p_enrolled_credit_points IN NUMBER,
83   p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE)
84 RETURN NUMBER;
85  PRAGMA RESTRICT_REFERENCES(inqp_get_sua_achvd,WNDS,WNPS);
86 
87 END igs_in_gen_001 ;