1 package PER_PTU_DFF_MIG AS
2 /* $Header: peptumig.pkh 120.0 2005/05/31 15:57:15 appldev noship $ */
3 --
4 -- Globals to hold concurrent request WHO column information.
5 --
6 g_request_id number(15);
7 g_program_application_id number(15);
8 g_program_id number(15);
9 g_update_date date;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |---------------------------< initialization >-----------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- Description:
16 --
17 -- This process is called for each slave process to perform standard
18 -- initialization.
19 --
20 -- Notes :
21 --
22 procedure initialization(p_payroll_action_id in number);
23 --
24 -- ----------------------------------------------------------------------------
25 -- |--------------------------< submit_migration >----------------------------|
26 -- ----------------------------------------------------------------------------
27 --
28 -- Descripton :
29 --
30 -- The procedure is a main procedure called by the concurent
31 -- program Migrate PTU Specific Person DFF Data to PTU DFF.
32 --
33 PROCEDURE submit_migration(errbuf out NOCOPY varchar2,
34 retcode out NOCOPY number,
35 p_business_group_id number
36 --p_report_mode varchar2
37 );
38 --
39 -- ----------------------------------------------------------------------------
40 -- |----------------------------< range_cursor >------------------------------|
41 -- ----------------------------------------------------------------------------
42 --
43 -- Descripton :
44 --
45 -- The procedure contains the cursor definition required to populate the
46 -- PAY_POPULATION_RANGES table.
47 -- This routine is called from PYUGEN. It returns a SQL select used
48 -- to identify the people who need to be processed.
49 --
50 PROCEDURE range_cursor (pactid in number,
51 sqlstr out NOCOPY varchar2);
52 --
53 -- ----------------------------------------------------------------------------
54 -- |--------------------------< action_creation >-----------------------------|
55 -- ----------------------------------------------------------------------------
56 --
57 -- Descripton :
58 --
59 -- This routine is called to create assignment actions in
60 -- PAY_ASSIGNMENT_ACTIONS table for each person to be processed by PYUGEN.
61 --
62 PROCEDURE action_creation(pactid in number,
63 stperson in number,
64 endperson in number,
65 chunk in number);
66 --
67 -- ----------------------------------------------------------------------------
68 -- |----------------------------< archive_data >------------------------------|
69 -- ----------------------------------------------------------------------------
70 --
71 -- Descripton :
72 --
73 -- This procedure contains the code required to process each record within
74 -- the PAY_ASSIGNMENT_ACTIONS table.
75 -- The procedure will perform the actual migration.
76 --
77 PROCEDURE archive_data (p_assactid in number,
78 p_effective_date in date);
79 --
80 -- ----------------------------------------------------------------------------
81 -- |--------------------------< deinitialization >----------------------------|
82 -- ----------------------------------------------------------------------------
83 --
84 -- Descripton :
85 --
86 -- This procedure is used to update the migration status in
87 -- user table PER_PTU_DFF_MAPPING_HEADERS and then remove the assignment
88 -- actions for this run by calling pay_archive.standard_deinit.
89 --
90 PROCEDURE deinitialization(pactid in number);
91 --
92 -- ----------------------------------------------------------------------------
93 -- |-------------------------< submit_perDFFpurge >---------------------------|
94 -- ----------------------------------------------------------------------------
95 --
96 -- Descripton :
97 --
98 -- Procedure to purge the migrated Person DFF data. This procedure is called
99 -- by the concurrent program Purge Migrated Person DFF Data.
100 --
101 PROCEDURE submit_perDFFpurge(errbuf out NOCOPY varchar2,
102 retcode out NOCOPY number,
103 p_purge_scope VARCHAR2,
104 p_context VARCHAR2);
105 --
106 -- ----------------------------------------------------------------------------
107 -- |----------------------< populate_mapping_tables >-------------------------|
108 -- ----------------------------------------------------------------------------
109 --
110 -- Description :
111 --
112 -- This procedure is used to populate the mapping tables for the first time.
113 -- This procedure is called from the mapping form.
114 --
115 procedure populate_mapping_tables;
116 --
117 END;