DBA Data[Home] [Help]

PACKAGE: APPS.IGS_GE_PRC_TRANSFER

Source


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;