[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;