1 PACKAGE pqp_log_alien_data_changes AS
2 /* $Header: pquslapc.pkh 120.0 2005/05/29 02:13:38 appldev noship $*/
3 -----------------------------------------------------------------------------
4 -- CHECK_FOR_CHANGES
5 -----------------------------------------------------------------------------
6 PROCEDURE check_for_changes (p_assignment_id in number
7 ,p_person_id in number
8 ,p_effective_date in date
9 ,p_new_value_char1 in varchar2 default null
10 ,p_old_value_char1 in varchar2 default null
11 ,p_new_value_char2 in varchar2 default null
12 ,p_old_value_char2 in varchar2 default null
13 ,p_new_value_char3 in varchar2 default null
14 ,p_old_value_char3 in varchar2 default null
15 ,p_new_value_char4 in varchar2 default null
16 ,p_old_value_char4 in varchar2 default null
17 ,p_new_value_char5 in varchar2 default null
18 ,p_old_value_char5 in varchar2 default null
19 ,p_new_value_char6 in varchar2 default null
20 ,p_old_value_char6 in varchar2 default null
21 ,p_new_value_char7 in varchar2 default null
22 ,p_old_value_char7 in varchar2 default null
23 ,p_new_value_char8 in varchar2 default null
24 ,p_old_value_char8 in varchar2 default null
25 ,p_new_value_char9 in varchar2 default null
26 ,p_old_value_char9 in varchar2 default null
27 ,p_new_value_char10 in varchar2 default null
28 ,p_old_value_char10 in varchar2 default null
29 ,p_new_value_date1 in date default null
30 ,p_old_value_date1 in date default null
31 ,p_new_value_date2 in date default null
32 ,p_old_value_date2 in date default null);
33 -- procedrue to check for changes in values and calls the log events
34 -- procedure
35 -----------------------------------------------------------------------------
36 -- ALIEN_ELEMENT_CHECK
37 -----------------------------------------------------------------------------
38 PROCEDURE alien_element_check (p_assignment_id in number
39 ,p_effective_date in date
40 ,p_element_link_id in number );
41 --
42 -- we need to log the event when a employee gets a alien earnings. This
43 -- procedure checks this and calls the log_events procedure.
44 --
45 -----------------------------------------------------------------------------
46 -- PERSON_LEVEL_CHECK
47 -----------------------------------------------------------------------------
48 PROCEDURE person_level_check
49 (p_person_id in number
50 ,p_table_name in varchar2
51 ,p_effective_date in date default NULL
52 ,p_new_value_char1 in varchar2 default null
53 ,p_old_value_char1 in varchar2 default null
54 ,p_new_value_char2 in varchar2 default null
55 ,p_old_value_char2 in varchar2 default null
56 ,p_new_value_char3 in varchar2 default null
57 ,p_old_value_char3 in varchar2 default null
58 ,p_new_value_char4 in varchar2 default null
59 ,p_old_value_char4 in varchar2 default null
60 ,p_new_value_char5 in varchar2 default null
61 ,p_old_value_char5 in varchar2 default null
62 ,p_new_value_char6 in varchar2 default null
63 ,p_old_value_char6 in varchar2 default null
64 ,p_new_value_char7 in varchar2 default null
65 ,p_old_value_char7 in varchar2 default null
66 ,p_new_value_char8 in varchar2 default null
67 ,p_old_value_char8 in varchar2 default null
68 ,p_new_value_char9 in varchar2 default null
69 ,p_old_value_char9 in varchar2 default null
70 ,p_new_value_char10 in varchar2 default null
71 ,p_old_value_char10 in varchar2 default null
72 ,p_new_value_date1 in date default null
73 ,p_old_value_date1 in date default null
74 ,p_new_value_date2 in date default null
75 ,p_old_value_date2 in date default null);
76 --
77 -- called by all person level triggers, gets the assignment and checks
78 -- for changes before logging
79 --
80 -----------------------------------------------------------------------------
81 -- LOG_EVENTS
82 -----------------------------------------------------------------------------
83 PROCEDURE log_events (p_assignment_id in number
84 ,p_effective_date in date );
85 --
86 -- Procedure to check whether the event is already logged, if not it logs
87 -- the event in the table pay_process_events.
88 --
89 -----------------------------------------------------------------------------
90 -- LOG_EXTRA_INFO_CHANGES
91 -----------------------------------------------------------------------------
92 PROCEDURE log_pei_insert_changes
93 (p_person_id in number
94 ,p_information_type in varchar2
95 ,p_pei_information5 in varchar2
96 ,p_pei_information6 in varchar2
97 ,p_pei_information7 in varchar2
98 ,p_pei_information8 in varchar2
99 ,p_pei_information9 in varchar2
100 ,p_pei_information10 in varchar2
101 ,p_pei_information11 in varchar2
102 ,p_pei_information12 in varchar2
103 ,p_pei_information13 in varchar2 );
104 --
105 -- Procedure which will be called by the PER_PEOPLE_EXTRA_INFO API USER
106 -- HOOKS to check whether the event is already logged.
107 -- Legislative user hook is used due to mutating table problem for
108 -- dynamic triggers on this table.
109 --
110 PROCEDURE log_pei_update_changes
111 (p_person_id in number
112 ,p_information_type in varchar2
113 ,p_information_type_o in varchar2
114 ,p_pei_information5 in varchar2
115 ,p_pei_information5_o in varchar2
116 ,p_pei_information6 in varchar2
117 ,p_pei_information6_o in varchar2
118 ,p_pei_information7 in varchar2
119 ,p_pei_information7_o in varchar2
120 ,p_pei_information8 in varchar2
121 ,p_pei_information8_o in varchar2
122 ,p_pei_information9 in varchar2
123 ,p_pei_information9_o in varchar2
124 ,p_pei_information10 in varchar2
125 ,p_pei_information10_o in varchar2
126 ,p_pei_information11 in varchar2
127 ,p_pei_information11_o in varchar2
128 ,p_pei_information12 in varchar2
129 ,p_pei_information12_o in varchar2
130 ,p_pei_information13 in varchar2
131 ,p_pei_information13_o in varchar2 );
132 --
133 -- Procedure which will be called by the PER_PEOPLE_EXTRA_INFO API USER
134 -- HOOKS to check whether the event is already logged.
135 --
136 -------------------------------
137 END pqp_log_alien_data_changes;