[Home] [Help]
PACKAGE: APPS.PER_ZA_WSP_LOOKUP
Source
1 package PER_ZA_WSP_LOOKUP AUTHID CURRENT_USER AS
2 /* $Header: perzawsp.pkh 120.1.12010000.1 2008/07/28 05:54:26 appldev ship $ */
3
4 Procedure wsp_lookup_values
5 (errbuf out nocopy varchar2,
6 retcode out nocopy number,
7 p_syncronise in varchar2,
8 p_year in number,
9 P_mode in varchar2,
10 p_from_year in number,
11 p_plan_trng_ind in varchar2);
12
13
14 Procedure LOOKUP_VAL_INSERT_ROW
15 ( P_LOOKUP_TYPE in varchar2
16 , P_LOOKUP_CODE in varchar2
17 , P_ATTRIBUTE1 in varchar2
18 , P_ATTRIBUTE2 in varchar2
19 , P_ATTRIBUTE3 in varchar2
20 , P_ATTRIBUTE4 in varchar2
21 , P_ATTRIBUTE5 in varchar2
22 , P_ATTRIBUTE6 in varchar2
23 , P_ATTRIBUTE7 in varchar2
24 , P_ATTRIBUTE8 in varchar2
25 , P_ATTRIBUTE9 in varchar2
26 , P_ATTRIBUTE10 in varchar2
27 , P_ATTRIBUTE11 in varchar2
28 , P_ATTRIBUTE12 in varchar2
29 , P_ATTRIBUTE13 in varchar2
30 , P_ATTRIBUTE14 in varchar2
31 , P_ATTRIBUTE15 in varchar2
32 , P_ENABLED_FLAG in varchar2
33 , P_MEANING in varchar2
34 , P_DESCRIPTION in varchar2
35 , P_START_DATE_ACTIVE in varchar2
36 , P_END_DATE_ACTIVE in varchar2
37 );
38
39 Procedure create_lookup_values
40 (errbuf out nocopy varchar2,
41 retcode out nocopy number,
42 p_year in number,
43 p_plan_trng_ind in varchar2,
44 p_del_mode in varchar2);
45
46 Procedure refresh_lookup_values
47 (errbuf out nocopy varchar2,
48 retcode out nocopy number,
49 p_year in number,
50 p_plan_trng_ind in varchar2);
51
52 Procedure copy_lookup_values
53 (errbuf out nocopy varchar2,
54 retcode out nocopy number,
55 p_year in number,
56 P_from_year in number,
57 p_plan_trng_ind in varchar2);
58
59 Procedure copy_plan_2_trining
60 (errbuf out nocopy varchar2,
61 retcode out nocopy number,
62 p_year in number,
63 P_from_year in number);
64
65 function vs_wsp_c_yr
66 (
67 p_lookup_code in varchar2
68 ,p_lookup_type in varchar2
69 ) return varchar2;
70
71
72 end PER_ZA_WSP_LOOKUP;