1 package ben_per_asg_eit_ler AUTHID CURRENT_USER AS
2 /* $Header: beeittrg.pkh 120.0.12020000.1 2013/01/10 12:22:15 usaraswa noship $ */
3 --
4 /*
5 +========================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +========================================================================+
10 */
11 /*
12 Purpose
13 This package is used to Create Life events based on the tables
14 per_people_extra_info , per_assignment_extra_info
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 10-Jan-2013 usaraswa 120.0 Initial Version
19 */
20 -----------------------------------------------------------------------------------------
21
22 type g_per_ler_rec is record
23 (
24 PERSON_EXTRA_INFO_ID NUMBER,
25 PERSON_ID NUMBER,
26 INFORMATION_TYPE VARCHAR2(40)
27 );
28
29 type g_asg_ler_rec is record
30 (
31 ASSIGNMENT_EXTRA_INFO_ID NUMBER,
32 ASSIGNMENT_ID NUMBER,
33 INFORMATION_TYPE VARCHAR2(40)
34 );
35
36 procedure ler_per_chk(p_old IN g_per_ler_rec
37 ,p_new IN g_per_ler_rec
38 ,p_mode in varchar2
39 ,p_effective_date in date default null);
40
41 procedure ler_asg_chk(p_old IN g_asg_ler_rec
42 ,p_new IN g_asg_ler_rec
43 ,p_mode in varchar2
44 ,p_effective_date in date default null );
45
46 procedure create_ler_per (p_person_extra_info_id In number
47 ,p_person_id in number
48 ,p_INFORMATION_TYPE in per_people_extra_info.information_type%TYPE);
49
50 procedure update_ler_per (p_person_extra_info_id In number);
51
52 procedure delete_ler_per (p_person_extra_info_id In number);
53
54 procedure create_ler_asg (p_assignment_extra_info_id In number
55 ,p_assignment_id in number
56 ,p_INFORMATION_TYPE in varchar2);
57
58 procedure update_ler_asg (p_assignment_extra_info_id In number);
59
60 procedure delete_ler_asg (p_assignment_extra_info_id In number);
61 end ben_per_asg_eit_ler;