1 PACKAGE IGS_SV_BATCH_PROCESS_PKG AS
2 /* $Header: IGSSV01S.pls 120.2 2006/04/27 22:14:54 prbhardw noship $ */
3
4 /******************************************************************
5
6 Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
7 All rights reserved.
8
9 Created By : Don Shellito
10
11 Date Created By : Oct-01-2002
12
13 Purpose : This package is to be used for the processing and
14 gathering of the SEVIS related information that is
15 to be sent for transmital.
16
17 The concurrent programs that are to be executed are
18 defined globally. All other procedures are to be
19 defined internally.
20
21 remarks : None
22
23 Change History
24
25 Who When What
26 -----------------------------------------------------------
27 Don Shellito 28-Jan-2002 New Package created.
28
29 ******************************************************************/
30
31 -- ------------------------------------------------------------------
32 -- Concurrent Program for the gathering of data on Exchange Visitors
33 -- ------------------------------------------------------------------
34 PROCEDURE EV_Batch_Process(
35 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
36 retcode OUT NOCOPY NUMBER , -- Request standard return status
37 p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
38 p_org_id IN VARCHAR2,
39 p_dso_id IN VARCHAR2 DEFAULT NULL
40 );
41
42 -- ------------------------------------------------------------------
43 -- Concurrent Program for the gathering of data on Non Immigrant Students
44 -- ------------------------------------------------------------------
45 PROCEDURE NIMG_Batch_Process(
46 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
47 retcode OUT NOCOPY NUMBER , -- Request standard return status
48 p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
49 p_org_id IN VARCHAR2,
50 p_dso_id IN VARCHAR2 DEFAULT NULL
51 );
52
53 -- ------------------------------------------------------------------
54 -- Concurrent Program for the Deleting of unprocessed EV records.
55 -- ------------------------------------------------------------------
56 PROCEDURE EV_Purge_Batch (
57 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
58 retcode OUT NOCOPY NUMBER -- Request standard return status
59 );
60
61 -- ------------------------------------------------------------------
62 -- Concurrent Program for the Deleting of unprocessed Non immigrant records.
63 -- ------------------------------------------------------------------
64 PROCEDURE NIMG_Purge_Batch (
65 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
66 retcode OUT NOCOPY NUMBER -- Request standard return status
67 );
68
69 -- ------------------------------------------------------------------
70 -- Procedure for processing the transaction header.
71 -- ------------------------------------------------------------------
72 PROCEDURE process_trans_header (
73 p_BatchID IN NUMBER,
74 p_FileErrorCode IN VARCHAR2,
75 p_FileValidation IN VARCHAR2
76 );
77
78 -- ------------------------------------------------------------------
79 -- Procedure for processing transaction errors.
80 -- ------------------------------------------------------------------
81 PROCEDURE process_trans_errors (
82 p_BatchID IN NUMBER,
83 p_ErrorCode IN VARCHAR2,
84 p_ErrorMessage IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 -- ------------------------------------------------------------------
89 -- Procedure for processing Student return information.
90 -- ------------------------------------------------------------------
91 PROCEDURE process_student_record (
92 p_BatchID IN NUMBER,
93 p_sevisID IN VARCHAR2,
94 p_PersonID IN VARCHAR2,
95 p_Status IN VARCHAR2,
96 p_SEVIS_ErrorCode IN VARCHAR2,
97 p_SEVIS_ErrorElement IN VARCHAR2
98 );
99
100 -- ------------------------------------------------------------------
101 -- Procedure for processing dependent return information.
102 -- ------------------------------------------------------------------
103 PROCEDURE process_dep_record (
104 p_BatchID IN NUMBER,
105 p_DepPersonID IN NUMBER,
106 p_DepSevisID IN VARCHAR2,
107 p_PersonID IN VARCHAR2,
108 p_Status IN VARCHAR2,
109 p_SEVIS_ErrorCode IN VARCHAR2,
110 p_SEVIS_ErrorElement IN VARCHAR2
111 );
112
113
114 -- ------------------------------------------------------------------
115 -- Procedure for generating XML.
116 -- ------------------------------------------------------------------
117 PROCEDURE Generate_Batch_XML(
118 errbuf OUT NOCOPY VARCHAR2,
119 retcode OUT NOCOPY NUMBER ,
120 batch_id IN NUMBER
121 );
122
123 -- ------------------------------------------------------------------
124 -- Procedure for assigning new DSO.
125 -- ------------------------------------------------------------------
126 PROCEDURE Assign_DSO(
127 errbuf OUT NOCOPY VARCHAR2,
128 retcode OUT NOCOPY NUMBER ,
129 p_group_type IN VARCHAR2,
130 p_dummy_1 IN VARCHAR2,
131 p_dummy_2 IN VARCHAR2,
132 p_old_dso_id IN VARCHAR2 DEFAULT NULL,
133 p_group_id IN VARCHAR2 DEFAULT NULL,
134 p_new_dso_id IN VARCHAR2
135 );
136
137 END IGS_SV_BATCH_PROCESS_PKG;