DBA Data[Home] [Help]

PACKAGE: APPS.HR_USER_ACCT_EMP_EXTRACT

Source


1 PACKAGE HR_USER_ACCT_EMP_EXTRACT AUTHID CURRENT_USER AS
2 /* $Header: hrempext.pkh 120.0.12020000.1 2012/06/28 23:52:26 appldev ship $*/
3 --
4 --
5 -- |--------------------------------------------------------------------------|
6 -- |--< PRIVATE GLOBAL VARIABLES >--------------------------------------------|
7 -- |--------------------------------------------------------------------------|
8 
9 --
10 /*
11 ||===========================================================================
12 || PROCEDURE: run_process
13 ||----------------------------------------------------------------------------
14 ||
15 || Description:
16 ||     This procedure is invoked by Concurrent Manager to extract
17 ||     employees based on input parameters passed.
18 ||
19 || Pre-Conditions:
20 ||     Employee Data must exist on the database.
21 ||
22 || Input Parameters:
23 ||
24 || Output Parameters:
25 ||
26 || In out nocopy Parameters:
27 ||
28 || Post Success:
29 ||      Selected employees are written to hr_pump_batch_lines table.
30 ||
31 || Post Failure:
32 ||     Raise exception.
33 ||
34 || Access Status:
35 ||     Public
36 ||
37 ||=============================================================================
38 */
39   PROCEDURE run_process (
40      errbuf                     out nocopy varchar2
41     ,retcode                    out nocopy number
42     ,p_batch_name               in hr_pump_batch_headers.batch_name%TYPE
43     ,p_date_from                in varchar2 default null
44     ,p_date_to                  in varchar2 default null
45     ,p_business_group_id        in per_all_people_f.business_group_id%type
46     ,p_single_org_id            in per_organization_units.organization_id%type
47                                    default null
48     ,p_organization_structure_id in
49                    per_organization_structures.organization_structure_id%type
50                                    default null
51     ,p_org_structure_version_id in
52                    per_org_structure_versions.org_structure_version_id%type
53                                    default null
54     ,p_parent_org_id            in per_organization_units.organization_id%type
55                                    default null
56     ,p_run_type                 in varchar2
57   );
58 --
59 --
60 END HR_USER_ACCT_EMP_EXTRACT;