PACKAGE: APPS.IGS_GE_GEN_001

Source

1 PACKAGE IGS_GE_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSGE01S.pls 115.5 2002/11/29 00:31:22 nsidana ship $ */
3 
4 FUNCTION GENP_CHK_COL_UPPER(
5   p_column_name  VARCHAR2 ,
6   p_table_name  VARCHAR2 )
7 RETURN BOOLEAN ;
8 PRAGMA RESTRICT_REFERENCES(GENP_CHK_COL_UPPER, WNDS);
9 
10 FUNCTION genp_clc_dt_diff(
11   p_start_dt IN DATE ,
12   p_end_dt IN DATE ,
13   p_message_name OUT NOCOPY VARCHAR2)
14 RETURN NUMBER ;
15 PRAGMA RESTRICT_REFERENCES(genp_clc_dt_diff, WNDS);
16 
17 FUNCTION GENP_CLC_WEEK_END_DT(
18   p_date IN DATE ,
19   p_day_week_end IN VARCHAR2 DEFAULT 'FRIDAY')
20 RETURN DATE ;
21 PRAGMA RESTRICT_REFERENCES(GENP_CLC_WEEK_END_DT, WNDS);
22 
23 PROCEDURE GENP_DEL_LOG(
24   errbuf out NOCOPY varchar2,
25   retcode out NOCOPY number ,
26   p_s_log_type IN VARCHAR2 ,
27   p_days_old IN NUMBER );
28 
29 FUNCTION GENP_DEL_NOTE(
30   p_reference_number IN NUMBER ,
31   p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN ;
33 
34 FUNCTION genp_get_addr(
35   p_person_id  NUMBER ,
36   p_org_unit_cd  VARCHAR2 ,
37   p_institution_cd  VARCHAR2 ,
38   p_location_cd  VARCHAR2 ,
39   p_addr_type  VARCHAR2 ,
40   p_case_type  VARCHAR2 DEFAULT 'UPPER',
41   p_phone_no  VARCHAR2 DEFAULT 'Y',
42   p_name_style  VARCHAR2 DEFAULT 'CONTEXT',
43   p_inc_addr  VARCHAR2 DEFAULT 'Y')
44 RETURN VARCHAR2 ;
45  PRAGMA RESTRICT_REFERENCES(genp_get_addr, WNDS);
46 
47 FUNCTION genp_get_appl_owner
48 RETURN VARCHAR2 ;
49  PRAGMA RESTRICT_REFERENCES(genp_get_appl_owner, WNDS);
50 
51 PROCEDURE genp_get_audit(
52   p_table_name IN VARCHAR2 ,
53   p_rowid IN VARCHAR2 ,
54   p_update_who OUT NOCOPY VARCHAR2 ,
55   p_update_on OUT NOCOPY DATE );
56 
57 FUNCTION genp_get_cmp_cutoff(
58   p_acad_cal_type IN VARCHAR2 ,
59   p_acad_ci_sequence_number IN NUMBER )
60 RETURN DATE ;
61  PRAGMA RESTRICT_REFERENCES(genp_get_cmp_cutoff, WNDS);
62 
63 FUNCTION adm_get_name(
64 	x_person_id in NUMBER)
65 RETURN VARCHAR2;
66 
67 FUNCTION adm_get_unit_title(
68 	x_person_id             NUMBER,
69 	x_admission_appl_number NUMBER,
70         x_NOMINATED_COURSE_CD   VARCHAR2 )
71 RETURN VARCHAR2;
72 
73 END IGS_GE_GEN_001 ;