1 PACKAGE per_us_eth_orig_mig_pkg AUTHID CURRENT_USER AS
2 /* $Header: peusethmig.pkh 120.1 2011/08/10 11:49:13 nkjaladi noship $ */
3
4 /******************************************************************************
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : per_us_eth_orig_mig_pkg
22
23 Description : This package is called by a concurrent program.
24 In this package we migrate ethnic origin data from
25 per_all_people_f to New EIT.
26
27 Change List
28 -----------
29 Date Name Ver Bug No Description
30 ----------- -------- ------- --------- -------------------------------
31 31-Mar-2011 NKJALADI 115.0 1173960 Created.
32 08-Aug-2011 nkjaladi 115.1 12839027 Added new procedure
33 irc_upgrade_ethnic_origin
34 ******************************************************************************/
35
36 PROCEDURE upgrade_ethnic_origin (p_person_id in number);
37
38 PROCEDURE qual_pers_upg(p_object_id varchar2,
39 p_qualified out nocopy varchar2);
40
41 PROCEDURE irc_upgrade_ethnic_origin (p_person_id in number
42 ,p_eit_override_flag in varchar2);
43
44 END per_us_eth_orig_mig_pkg;