1 Package pay_us_def_comp_457 AUTHID CURRENT_USER as
2 /* $Header: py457rol.pkh 115.4 2002/12/31 20:54:41 tmehra ship $ */
3 --+
4 -- ----------------------------------------------------------------------------+
5 -- |---------------------------------< upd >----------------------------------|
6 -- ----------------------------------------------------------------------------+
7 -- {Start Of Comments}
8 --+
9 -- Description:
10 -- This procedure finds out all the valid persons that have or should
11 -- have records for 457.
12 --+
13 -- Prerequisites:
14 -- The main parameters to the business process have to be in the record
15 -- format.
16 --+
17 -- In Parameters:
18 --+
19 -- Post Success:
20 -- The specified row will be fully validated and updated for the specified
21 -- entity without being committed.
22 --+
23 -- Post Failure:
24 -- If an error has occurred, an error message will be supplied with the work
25 -- rolled back.
26 --+
27 -- Developer Implementation Notes:
28 -- None.
29 --+
30 -- Access Status:
31 -- Internal Development Use Only.
32 --+
33 -- {End Of Comments}
34 TYPE g_rec_type IS RECORD
35 (
36 person_id per_all_assignments_f.person_id%TYPE ,
37 tax_unit_id NUMBER ,
38 full_name per_all_people_f.full_name%TYPE ,
39 assignment_id per_assignments_f.assignment_id%TYPE ,
40 element_link_id pay_element_entries_f.element_link_id%TYPE ,
41 element_name pay_element_types_f.element_name%TYPE ,
42 business_group_id per_assignments_f.business_group_id%TYPE ,
43 element_information1 pay_element_types_f.element_information1%TYPE ,
44 effective_end_date VARCHAR2(11)
45 );
46 --+
47 -- ----------------------------------------------------------------------------+
48 -- | Global Definitions - Internal Development Use Only |
49 -- ----------------------------------------------------------------------------+
50 --+
51 g_old_rec g_rec_type; -- Global record definition
52
53 PROCEDURE rollover_process
54 (
55 errbuf OUT NOCOPY VARCHAR2 ,
56 retcode OUT NOCOPY NUMBER ,
57 p_year IN NUMBER ,
58 p_gre_id IN NUMBER DEFAULT NULL ,
59 p_person_id IN NUMBER DEFAULT NULL ,
60 p_override_mode IN VARCHAR2 DEFAULT 'NO'
61 );
62 END pay_us_def_comp_457;