PACKAGE: APPS.IGS_SV_UTIL

Source

1 PACKAGE IGS_SV_UTIL AS
2 /* $Header: IGSSV02S.pls 120.1 2006/04/27 22:19:21 prbhardw noship $ */
3 
4 /******************************************************************
5 
6     Copyright (c) 2006 Oracle Corporation, Redwood Shores, CA, USA
7                          All rights reserved.
8 
9  Created By         : SreeKrishna Vadde
10 
11  Date Created By    : Wednesday, January 04, 2006
12 
13  Purpose            : This  is a utility package for all sevis related operations
14 
15 
16  remarks            : None
17 
18  Change History
19 
20 Who                   When           What
21 -----------------------------------------------------------
22 ******************************************************************/
23    TYPE bath_crsr IS REF CURSOR;
24 
25    PROCEDURE get_prev_btch_dtls (
26       p_key_code            IN       VARCHAR2,
27       p_person_id           IN       NUMBER,
28       p_cur_batch_id        IN       NUMBER,
29       p_extra_param         IN       VARCHAR2,
30       x_prev_batch_id       OUT  NOCOPY    NUMBER,
31       x_prev_btch_prcs_dt   OUT  NOCOPY    DATE
32    );
33 
34    PROCEDURE get_tbl_extra_params (
35       p_key_code       IN       VARCHAR2,
36       p_extra_param    IN       VARCHAR2,
37       x_tbl_name       OUT   NOCOPY   VARCHAR2,
38       x_extra_critra   OUT  NOCOPY    VARCHAR2
39    );
40 
41    FUNCTION ismutuallyexclusive (
42       p_person_id          NUMBER,
43       p_batch_id           NUMBER,
44       p_operation          VARCHAR2,
45       p_information_type   VARCHAR2
46    )
47       RETURN BOOLEAN;
48 
49    PROCEDURE change_record_status (
50       p_person_id     IN   NUMBER,
51       p_batch_id      IN   NUMBER,
52       p_info_key      IN   VARCHAR2,
53       p_extra_param   IN   VARCHAR2,
54       P_CHANGE_DATA   IN   VARCHAR2,
55       p_summary_id    IN   NUMBER
56    );
57    FUNCTION GET_BTCH_PROCESS_DT(
58       p_person_id igs_sv_prgms_info.person_id%TYPE,
59       --p_auth_reason igs_sv_prgms_info.authorization_reason%TYPE
60       p_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE
61  ) RETURN DATE;
62 
63  FUNCTION open_new_batch(p_person_id number, p_batch_id number, p_caller varchar2)
64  return number ;
65 
66  PROCEDURE create_Person_Rec(
67        p_person_id NUMBER,
68        p_old_batch_id NUMBER,
69        p_new_batch_id NUMBER);
70 
71 PROCEDURE GET_PROGRAM_DATES (
72       p_person_id IN igs_pe_nonimg_form.person_id%TYPE,
73       p_prgm_end_date OUT NOCOPY   igs_pe_nonimg_form.prgm_end_date%TYPE,
74       p_prgm_start_date OUT NOCOPY igs_pe_nonimg_form.prgm_start_date%TYPE
75  );
76 
77 END igs_sv_util;