PACKAGE: APPS.IGS_PE_GEN_004

Source

1 PACKAGE IGS_PE_GEN_004 AS
2 /* $Header: IGSPE20S.pls 120.1 2005/09/08 15:12:30 appldev noship $ */
3 
4 /*  +=======================================================================+
5     |    Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA     |
6     |                         All rights reserved.                          |
7     +=======================================================================+
8     who       when          what
9 */
10 
11 G_SKIP_MAND_DATA_VAL VARCHAR2(1);
12 
13 FUNCTION GET_RACE_DTLS(P_PERSON_ID IN NUMBER)
14 RETURN VARCHAR2;
15 
16 FUNCTION PERM_RES_COUNTRY_DTL (
17  P_PERSON_ID IN VARCHAR2,
18  P_DETAIL IN VARCHAR2)
19  RETURN VARCHAR2;
20 
21 FUNCTION perm_res_reg_date (
22  P_PERSON_ID IN VARCHAR2
23  )
24  RETURN DATE;
25 
26 FUNCTION CONVERT_COUNTRY_CODE (
27 P_COUNTRY_CODE IN VARCHAR2)
28 RETURN VARCHAR2;
29 
30 PROCEDURE PROCESS_APPLCITIZEN (
31 P_PERSON_ID        IN  NUMBER,
32 P_HAS_CITIZEN      IN  VARCHAR2,
33 P_CITIZEN_COUNTRY  IN  VARCHAR2,
34 P_PERM_RES         IN  VARCHAR2,
35 P_REG_NUMBER       IN  VARCHAR2,
36 P_REG_DATE         IN  DATE,
37 P_MSG_DATA         OUT NOCOPY VARCHAR2
38 );
39 
40 FUNCTION VALIDATE_FELONY (
41  P_PERSON_ID IN NUMBER,
42  P_EVER_FELONY_CONVICTED IN VARCHAR2)
43 RETURN VARCHAR2;
44 
45 FUNCTION GET_LOAD_TEACH_CONCAT(
46 P_TEACH_CAL_TYPE IN VARCHAR2,
47 P_TEACH_SEQ_NUMBER IN NUMBER
48 ) RETURN VARCHAR2;
49 
50 FUNCTION GET_START_TERM (
51 P_ACAD_CAL_TYPE IN VARCHAR2 ,
52 P_PROG_COMMENCEMENT_DT IN VARCHAR2
53 ) RETURN VARCHAR2;
54 
55 FUNCTION GET_OTHER_NAMES (
56 P_PERSON_ID IN NUMBER
57 ) RETURN VARCHAR2;
58 
59 PROCEDURE SKIP_MAND_DATA_VAL;
60 
61 PROCEDURE add_attachment(
62  P_PERSON_ID  IN NUMBER,
63  P_CRED_TYPE_ID IN NUMBER,
64  P_FILE_NAME  IN VARCHAR2,
65  P_FILE_CONTENT_TYPE  IN VARCHAR2,
66  P_FILE_FORMAT IN VARCHAR2,
67  P_FILE_ID OUT NOCOPY NUMBER,
68  P_MSG_DATA OUT NOCOPY VARCHAR2
69 );
70 
71 PROCEDURE delete_attachment(
72  P_CREDENTIAL_ID IN NUMBER,
73  P_DOCUMENT_ID IN NUMBER,
74  P_MSG_DATA OUT NOCOPY VARCHAR2
75 );
76 
77 FUNCTION GET_DECEASED_INDICATOR (
78 P_PERSON_ID IN NUMBER
79 ) RETURN VARCHAR2;
80 
81 END IGS_PE_GEN_004;