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