PACKAGE: APPS.IGS_EN_SEVIS

Source

1 PACKAGE igs_en_sevis AS
2 /* $Header: IGSEN97S.pls 120.1 2006/05/02 01:46:19 amuthu noship $ */
3 
4 FUNCTION enrf_chk_sevis_auth_req (
5         p_person_id    NUMBER,
6         p_cal_type VARCHAR2,
7         p_ci_sequence_number NUMBER,
8         p_elgb_step VARCHAR2)
9 RETURN BOOLEAN ;
10 
11 PROCEDURE stud_ret_to_ft_load (
12         p_begin_cal_inst  IN  VARCHAR2,
13         p_return_cal_inst IN  VARCHAR2,
14         p_log_creation_dt OUT NOCOPY DATE );
15 
16 FUNCTION enrf_get_sevis_auth_details(
17         p_person_id       IN  NUMBER,
18         p_auth_code       OUT NOCOPY VARCHAR2,
19         p_auth_start_dt   OUT NOCOPY DATE,
20         p_auth_end_dt     OUT NOCOPY DATE,
21         p_comments        OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN ;
23 
24 FUNCTION enrf_get_ret_ft_note_details(
25         p_person_id     IN  NUMBER,
26         p_note_text     OUT NOCOPY VARCHAR2,
27         p_note_start_dt OUT NOCOPY DATE,
28         p_note_end_dt   OUT NOCOPY DATE,
29         p_note_type     OUT NOCOPY VARCHAR2 )
30 RETURN BOOLEAN ;
31 
32 FUNCTION get_visa_type(p_person_id    IN NUMBER,
33                        p_no_of_months OUT NOCOPY NUMBER ) RETURN VARCHAR2;
34 
35 FUNCTION is_auth_rec_duration_exceeds(
36                                      p_person_id     IN NUMBER,
37                                       p_start_date   IN  DATE,
38                                       p_end_date     IN  DATE,
39                                       p_no_of_months OUT NOCOPY NUMBER)  RETURN BOOLEAN;
40 
41 PROCEDURE create_auth_cal_row (
42       p_sevis_authorization_code          IN VARCHAR2,
43       p_start_dt                          IN DATE,
44       p_end_dt                            IN DATE,
45       p_comments                          IN VARCHAR2,
46       p_sevis_auth_id                     IN OUT NOCOPY NUMBER,
47       p_sevis_authorization_no            IN OUT NOCOPY NUMBER,
48       p_person_id                         IN NUMBER,
49       p_cal_type                          IN VARCHAR2,
50       p_ci_sequence_number                IN NUMBER,
51       p_cancel_flag                       IN VARCHAR2);
52 
53 PROCEDURE enrp_sevis_auth_dflt_dt(p_person_id          IN NUMBER,
54                                   p_cal_type           IN VARCHAR2,
55                                   p_ci_sequence_number IN NUMBER,
56                                   p_dflt_auth_start_dt OUT NOCOPY DATE,
57                                   p_dflt_auth_end_dt   OUT NOCOPY DATE);
58 
59 FUNCTION is_auth_records_overlap(P_PERSON_ID IN NUMBER) RETURN BOOLEAN ;
60 
61 END igs_en_sevis;