PACKAGE: APPS.IGS_UC_UTILS

Source

1 PACKAGE igs_uc_utils AUTHID CURRENT_USER AS
2 /* $Header: IGSUC26S.pls 115.10 2003/07/16 16:12:48 pmarada noship $ */
3 
4 
5   PROCEDURE format_app_no (p_app_no              IN     NUMBER,
6                            p_check_digit         IN     NUMBER,
7                            r_app_no_9            OUT NOCOPY    CHAR,
8                            r_app_no_11           OUT NOCOPY    CHAR);
9 
10 
11   PROCEDURE generate_pers_no (r_person_number    OUT NOCOPY    CHAR);
12 
13 
14   FUNCTION is_ucas_hesa_enabled RETURN BOOLEAN;
15 
16   PROCEDURE admission_residency_dtls (
17      p_interface_res_id       IN  NUMBER
18     ,p_residency_status_cd    IN  CHAR
19     ,p_residency_class_cd     IN  CHAR
20     ,p_start_dt               IN  DATE
21     ,p_person_id              IN  NUMBER
22     ,p_process_residency_status OUT NOCOPY CHAR );
23 
24 
25      TYPE step_rec IS RECORD(
26      APPNO        NUMBER,
27      CHECKDIGIT   NUMBER,
28      SURNAME      VARCHAR2(150),
29      FORENAMES    VARCHAR2(150),
30      BIRTHDATE    DATE,
31      SEX          VARCHAR2(30),
32      TITLE        VARCHAR2(60)
33       );
34 
35  TYPE cur_step_def IS REF CURSOR;
36 
37  PROCEDURE cvname_references( p_type      IN VARCHAR2,
38                               p_appno     IN NUMBER,
39                               p_surname   IN VARCHAR2,
40                               p_birthdate IN DATE,
41                               l_result   OUT NOCOPY igs_uc_utils.cur_step_def);
42 
43 
44 END igs_uc_utils;