1 PACKAGE IGS_GE_PRC_TRANSFER AUTHID CURRENT_USER AS
2 /* $Header: IGSGE07S.pls 115.6 2002/11/29 00:32:40 nsidana ship $ */
3 --
4 --
5 /* Bug 1956374
6 Who msrinivi
7 What duplicate removal Rremoved genp_prc_clear_rowid,genp_set_row_id
8 */
9 cst_home_location_type VARCHAR2(10) DEFAULT 'HOME';
10 cst_term_location_type VARCHAR2(10) DEFAULT 'TERM';
11 --
12 --
13 TYPE t_pe_rowids IS TABLE OF
14 ROWID
15 INDEX BY BINARY_INTEGER;
16 --
17 --
18 gt_rowid_table t_pe_rowids;
19 --
20 --
21 gt_empty_table t_pe_rowids;
22 --
23 --
24 gv_table_index BINARY_INTEGER;
25 --
26 -- To get the alternate person ids for the data transfer mechanism.
27 FUNCTION GENP_GET_ALT_PE_ID(
28 p_person_id IN NUMBER ,
29 p_person_id_type IN VARCHAR2 )
30 RETURN VARCHAR2;
31 PRAGMA RESTRICT_REFERENCES (genp_get_alt_pe_id,WNDS);
32
33 --
34 -- To get the person statistics location description for the data transf.
35 FUNCTION GENP_GET_PS_LOCATION(
36 p_person_id IN NUMBER ,
37 p_start_dt IN DATE ,
38 p_location_type IN VARCHAR2 )
39 RETURN VARCHAR2;
40 PRAGMA RESTRICT_REFERENCES (genp_get_ps_location,WNDS);
41
42 --
43 -- To insert data transfer IGS_PE_STD_TODO entries
44 PROCEDURE GENP_INS_TRNSFR_TODO(
45 p_person_id IN NUMBER ,
46 p_s_student_todo_type IN VARCHAR2 ,
47 p_todo_dt IN DATE )
48 ;
49 --
50 -- Process PE rowids in a PL/SQL TABLE for the current commit.
51 FUNCTION genp_prc_pe_rowids(
52 p_inserting IN BOOLEAN ,
53 p_updating IN BOOLEAN ,
54 p_deleting IN BOOLEAN ,
55 p_message_name IN OUT NOCOPY VARCHAR2 )
56 RETURN BOOLEAN;
57
58 END IGS_GE_PRC_TRANSFER;