[Home] [Help]
PACKAGE: APPS.PER_ZA_WSP_ARCHIVE_PKG
Source
1 package PER_ZA_WSP_ARCHIVE_PKG as
2 /* $Header: perzawspa.pkh 120.0.12000000.2 2007/06/20 11:42:28 amahanty noship $ */
3
4 /*+======================================================================+
5 | Copyright (c) 2002 Oracle Corporation |
6 | All rights reserved. |
7 +======================================================================+
8 SQL Script File name : perzawspa.pkh
9 Description : This sql script seeds the Package Header that
10 creates the Workplace Skills Plan Archive code
11
12 Change List:
13 ------------
14
15 Name Date Version Bug Text
16 -------------- ----------- ------- ------ ----------------------------
17 A Mahanty 11-DEC-2006 115.0 First created
18 A Mahanty 19-Feb-2007 115.1 Removed gscc errors
19 A Mahanty 22-Feb-2007 115.2 Added get_parameter
20 ========================================================================
21 */
22
23 procedure range_cursor
24 (
25 pactid in number,
26 sqlstr out nocopy varchar2
27 );
28
29 procedure action_creation
30 (
31 pactid in number,
32 stperson in number,
33 endperson in number,
34 chunk in number
35 );
36
37 procedure archive_init
38 (
39 pactid in number
40 );
41
42 procedure archive_data
43 (
44 p_assactid in number,
45 p_effective_date in date
46 );
47
48 function get_occupational_category
49 (
50 p_report_date in per_all_assignments_f.effective_end_date%type,
51 p_assignment_id in per_all_assignments_f.assignment_id%type,
52 p_job_id in per_all_assignments_f.job_id%type,
53 p_grade_id in per_all_assignments_f.grade_id%type,
54 p_position_id in per_all_assignments_f.position_id%type,
55 p_business_group_id in per_all_assignments_f.business_group_id%type
56 ) return varchar2 ;
57
58 function get_parameter
59 (
60 name in varchar2,
61 parameter_list in varchar2
62 ) return varchar2;
63
64 end PER_ZA_WSP_ARCHIVE_PKG;