eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_GR_GEN_002

Source


1 PACKAGE IGS_GR_GEN_002 AS
2 /* $Header: IGSGR14S.pls 120.0 2005/07/05 12:16:53 appldev noship $ */
3 PROCEDURE grdp_ins_graduand(
4   	errbuf  out NOCOPY  varchar2,
5 	retcode out NOCOPY  number,
6 	p_ceremony_round  IN VARCHAR2,
7 	p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
8 	p_crs_location_cd IN IGS_AD_LOCATION_ALL.location_cd%TYPE,
9 	p_award_cd IGS_PS_AWD.award_cd%TYPE ,
10 	p_nominated_completion  VARCHAR2 ,
11 	p_derived_completion  VARCHAR2 ,
12 	p_restrict_rqrmnt_complete  VARCHAR2 ,
13 	p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
14 	p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
15 	p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE,
16 	p_org_id IN NUMBER,
17 	/* Added next two parameter as per Progression Completion TD. */
18   p_graduand_status  IGS_GR_STAT.graduand_status%TYPE DEFAULT NULL,
19   p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE DEFAULT NULL
20  ) ;
21 
22 PROCEDURE grdp_ins_gr_hist(
23   p_person_id  IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24   p_create_dt  IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25   p_old_grd_cal_type  IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26   p_new_grd_cal_type  IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27   p_old_grd_ci_sequence_number  IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28   p_new_grd_ci_sequence_number  IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29   p_old_course_cd  IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30   p_new_course_cd  IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31   p_old_award_course_cd  IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32   p_new_award_course_cd  IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33   p_old_award_crs_version_number  IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34   p_new_award_crs_version_number  IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35   p_old_award_cd  IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36   p_new_award_cd  IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
37   p_old_honours_level  VARCHAR2 DEFAULT NULL,
38   p_new_honours_level  VARCHAR2 DEFAULT NULL,
39   p_old_conferral_dt   DATE DEFAULT NULL,
40   p_new_conferral_dt   DATE DEFAULT NULL,
41   p_old_graduand_status  IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42   p_new_graduand_status  IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43   p_old_graduand_appr_status  IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44   p_new_graduand_appr_status  IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45   p_old_s_graduand_type  IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46   p_new_s_graduand_type  IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47   p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48   p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49   p_old_proxy_award_ind  IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50   p_new_proxy_award_ind  IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51   p_old_proxy_award_person_id  IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52   p_new_proxy_award_person_id  IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53   p_old_previous_qualifications  IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54   p_new_previous_qualifications  IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55   p_old_convocation_memb_ind  IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56   p_new_convocation_memb_ind  IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57   p_old_sur_for_course_cd  IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58   p_new_sur_for_course_cd  IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59   p_old_sur_for_crs_version_numb  IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60   p_new_sur_for_crs_version_numb  IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61   p_old_sur_for_award_cd  IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62   p_new_sur_for_award_cd  IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63   p_old_update_who  IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64   p_new_update_who  IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65   p_old_update_on  IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66   p_new_update_on  IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67   p_old_comments  IGS_GR_GRADUAND_ALL.comments%TYPE ,
68   p_new_comments  IGS_GR_GRADUAND_ALL.comments%TYPE );
69 
70 PROCEDURE grdp_prc_gac(
71   	errbuf  out NOCOPY  varchar2,
72 	retcode out NOCOPY  number,
73 	p_ceremony_round IN VARCHAR2,
74 	p_lctn_cd IN VARCHAR2 ,
75 	p_grdnd_status IN VARCHAR2 ,
76 	p_resolve_stalemate_type IN VARCHAR2 ,
77 	p_ignore_unit_sets_ind IN VARCHAR2 DEFAULT 'N',
78 	p_org_id IN NUMBER
79 ) ;
80 
81 PROCEDURE grdp_set_gr_gst(
82 	errbuf  out NOCOPY  varchar2,
83 	retcode out NOCOPY  NUMBER,
84 	p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
85 	p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
86 	p_org_id IN NUMBER,
87 	/* Added next two parameter as per Progression Completion TD. */
88         p_graduand_status  IGS_GR_STAT.graduand_status%TYPE DEFAULT NULL,
89         p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE DEFAULT NULL
90  ) ;
91 
92 PROCEDURE grdp_upd_gac_order(
93   	errbuf  out NOCOPY  varchar2,
94 	retcode out NOCOPY  NUMBER,
95 	p_grd_perd VARCHAR2,
96 	p_order_by IN VARCHAR2 ,
97 	p_ignore_unit_sets_ind IN VARCHAR2 DEFAULT 'N',
98 	p_group_multi_award_ind IN VARCHAR2 DEFAULT 'N',
99 	p_mode IN VARCHAR2 DEFAULT 'A',  -- Added a new parameter as part of Order in Presentation DLD.
100 	p_org_id IN NUMBER
101 ) ;
102 
103 END igs_gr_gen_002;