1 Package ghr_pdi_bk2 AUTHID CURRENT_USER as
2 /* $Header: ghpdiapi.pkh 120.1 2005/10/02 01:58:16 aroussel $ */
3 --
4 --
5 -- update_pdi_b
6 --
7 Procedure update_pdi_b (
8 p_position_description_id IN number,
9 p_routing_grp_id IN number,
10 p_date_from IN date,
11 p_date_to IN date,
12 p_opm_cert_num IN varchar2,
13 p_flsa IN varchar2,
14 p_financial_statement IN varchar2,
15 p_subject_to_ia_action IN varchar2,
16 p_position_status IN number,
17 p_position_is IN varchar2,
18 p_position_sensitivity IN varchar2,
19 p_competitive_level IN varchar2,
20 p_pd_remarks IN varchar2,
21 p_position_class_std IN varchar2,
22 p_category IN varchar2,
23 p_career_ladder IN varchar2,
24 p_supervisor_name in varchar2,
25 p_supervisor_title in varchar2,
26 p_supervisor_date in date,
27 p_manager_name in varchar2,
28 p_manager_title in varchar2,
29 p_manager_date in date,
30 p_classifier_name in varchar2,
31 p_classifier_title in varchar2,
32 p_classifier_date in date,
33 p_attribute_category in varchar2,
34 p_attribute1 in varchar2,
35 p_attribute2 in varchar2,
36 p_attribute3 in varchar2,
37 p_attribute4 in varchar2,
38 p_attribute5 in varchar2,
39 p_attribute6 in varchar2,
40 p_attribute7 in varchar2,
41 p_attribute8 in varchar2,
42 p_attribute9 in varchar2,
43 p_attribute10 in varchar2,
44 p_attribute11 in varchar2,
45 p_attribute12 in varchar2,
46 p_attribute13 in varchar2,
47 p_attribute14 in varchar2,
48 p_attribute15 in varchar2,
49 p_attribute16 in varchar2,
50 p_attribute17 in varchar2,
51 p_attribute18 in varchar2,
52 p_attribute19 in varchar2,
53 p_attribute20 in varchar2,
54 p_business_group_id in number,
55 p_u_approved_flag in varchar2,
56 p_u_user_name_acted_on in varchar2,
57 p_u_action_taken in varchar2,
58 p_i_user_name_routed_to in varchar2,
59 p_i_groupbox_id in number,
60 p_i_routing_list_id in number,
61 p_i_routing_seq_number in number,
62 p_u_pdh_object_version_number in number,
63 p_i_pd_routing_history_id in number,
64 p_i_pdh_object_version_number in number,
65 p_pdi_object_version_number in number
66 );
67 --
68 -- update_pdi_a
69 --
70 Procedure update_pdi_a (
71 p_position_description_id IN number,
72 p_routing_grp_id IN number,
73 p_date_from IN date,
74 p_date_to IN date,
75 p_opm_cert_num IN varchar2,
76 p_flsa IN varchar2,
77 p_financial_statement IN varchar2,
78 p_subject_to_ia_action IN varchar2,
79 p_position_status IN number,
80 p_position_is IN varchar2,
81 p_position_sensitivity IN varchar2,
82 p_competitive_level IN varchar2,
83 p_pd_remarks IN varchar2,
84 p_position_class_std IN varchar2,
85 p_category IN varchar2,
86 p_career_ladder IN varchar2,
87 p_supervisor_name in varchar2,
88 p_supervisor_title in varchar2,
89 p_supervisor_date in date,
90 p_manager_name in varchar2,
91 p_manager_title in varchar2,
92 p_manager_date in date,
93 p_classifier_name in varchar2,
94 p_classifier_title in varchar2,
95 p_classifier_date in date,
96 p_attribute_category in varchar2,
97 p_attribute1 in varchar2,
98 p_attribute2 in varchar2,
99 p_attribute3 in varchar2,
100 p_attribute4 in varchar2,
101 p_attribute5 in varchar2,
102 p_attribute6 in varchar2,
103 p_attribute7 in varchar2,
104 p_attribute8 in varchar2,
105 p_attribute9 in varchar2,
106 p_attribute10 in varchar2,
107 p_attribute11 in varchar2,
108 p_attribute12 in varchar2,
109 p_attribute13 in varchar2,
110 p_attribute14 in varchar2,
111 p_attribute15 in varchar2,
112 p_attribute16 in varchar2,
113 p_attribute17 in varchar2,
114 p_attribute18 in varchar2,
115 p_attribute19 in varchar2,
116 p_attribute20 in varchar2,
117 p_business_group_id in number,
118 p_u_approved_flag in varchar2,
119 p_u_user_name_acted_on in varchar2,
120 p_u_action_taken in varchar2,
121 p_i_user_name_routed_to in varchar2,
122 p_i_groupbox_id in number,
123 p_i_routing_list_id in number,
124 p_i_routing_seq_number in number,
125 p_u_pdh_object_version_number in number,
126 p_i_pd_routing_history_id in number,
127 p_i_pdh_object_version_number in number,
128 p_pdi_object_version_number in number
129 );
130
131 end ghr_pdi_bk2;
[Home] [Help]