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_001

Source


1 PACKAGE IGS_GR_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSGR13S.pls 115.4 2002/11/29 00:41:49 nsidana ship $ */
3 
4 FUNCTION grdp_del_gac_hist(
5   p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6   p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7   p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8   p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9   p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10   p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11   p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12   p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,
13   p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15 
16 
17 PROCEDURE grdp_del_gr_gac(
18   errbuf  out NOCOPY varchar2,
19   retcode out NOCOPY NUMBER,
20   p_grd_period IN VARCHAR2,
21   p_org_id IN NUMBER
22 );
23 
24 FUNCTION grdp_get_acusg_title(
25   p_grd_cal_type IN VARCHAR2 ,
26   p_grd_ci_sequence_number IN NUMBER ,
27   p_ceremony_number IN NUMBER ,
28   p_award_course_cd IN CHAR ,
29   p_award_crs_version_number IN NUMBER ,
30   p_award_cd IN VARCHAR2 ,
31   p_us_group_number IN NUMBER )
32 RETURN VARCHAR2 ;
33 PRAGMA RESTRICT_REFERENCES(grdp_get_acusg_title, WNDS);
34 
35 FUNCTION grdp_get_grad_name(
36   p_person_id IN NUMBER )
37 RETURN VARCHAR2 ;
38 
39 FUNCTION grdp_get_gr_ghl(
40   p_person_id IN NUMBER ,
41   p_course_cd IN VARCHAR2 )
42 RETURN VARCHAR2 ;
43 
44 PROCEDURE grdp_ins_gac_hist(
45   p_person_id  IGS_GR_AWD_CRMN.person_id%TYPE ,
46   p_create_dt  IGS_GR_AWD_CRMN.create_dt%TYPE ,
47   p_grd_cal_type  IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48   p_grd_ci_sequence_number  IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49   p_ceremony_number  IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50   p_award_course_cd  IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51   p_award_crs_version_number  IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52   p_award_cd  IGS_GR_AWD_CRMN.award_cd%TYPE ,
53   p_old_us_group_number  IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54   p_new_us_group_number  IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55   p_old_order_in_presentation  IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56   p_new_order_in_presentation  IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57   p_old_graduand_seat_number  IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58   p_new_graduand_seat_number  IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59   p_old_name_pronunciation  IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60   p_new_name_pronunciation  IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61   p_old_name_announced  IGS_GR_AWD_CRMN.name_announced%TYPE ,
62   p_new_name_announced  IGS_GR_AWD_CRMN.name_announced%TYPE ,
63   p_old_academic_dress_rqrd_ind  IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64   p_new_academic_dress_rqrd_ind  IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65   p_old_academic_gown_size  IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66   p_new_academic_gown_size  IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67   p_old_academic_hat_size  IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68   p_new_academic_hat_size  IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69   p_old_guest_tickets_requested  IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70   p_new_guest_tickets_requested  IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71   p_old_guest_tickets_allocated  IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72   p_new_guest_tickets_allocated  IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73   p_old_guest_seats  IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74   p_new_guest_seats  IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75   p_old_fees_paid_ind  IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76   p_new_fees_paid_ind  IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77   p_old_update_who  IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78   p_new_update_who  IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79   p_old_update_on  IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80   p_new_update_on  IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81   p_old_special_requirements  IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82   p_new_special_requirements  IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83   p_old_comments  IGS_GR_AWD_CRMN.comments%TYPE ,
84   p_new_comments  IGS_GR_AWD_CRMN.comments%TYPE ) ;
85 
86 END IGS_GR_GEN_001 ;