1 package PER_MM_POSITIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pemmv02t.pkh 115.0 99/07/18 14:02:16 porting ship $ */
3 --
4 --
5 procedure update_row
6 (p_select_position in varchar2,
7 p_default_from in varchar2,
8 p_deactivate_old_position in varchar2,
9 p_new_position_definition_id in number,
10 p_new_position_id in number,
11 p_target_job_id in number,
12 p_segment1 in varchar2,
13 p_segment2 in varchar2,
14 p_segment3 in varchar2,
15 p_segment4 in varchar2,
16 p_segment5 in varchar2,
17 p_segment6 in varchar2,
18 p_segment7 in varchar2,
19 p_segment8 in varchar2,
20 p_segment9 in varchar2,
21 p_segment10 in varchar2,
22 p_segment11 in varchar2,
23 p_segment12 in varchar2,
24 p_segment13 in varchar2,
25 p_segment14 in varchar2,
26 p_segment15 in varchar2,
27 p_segment16 in varchar2,
28 p_segment17 in varchar2,
29 p_segment18 in varchar2,
30 p_segment19 in varchar2,
31 p_segment20 in varchar2,
32 p_segment21 in varchar2,
33 p_segment22 in varchar2,
34 p_segment23 in varchar2,
35 p_segment24 in varchar2,
36 p_segment25 in varchar2,
37 p_segment26 in varchar2,
38 p_segment27 in varchar2,
39 p_segment28 in varchar2,
40 p_segment29 in varchar2,
41 p_segment30 in varchar2,
42 p_row_id in varchar2);
43 --
44 --
45 procedure load_rows
46 (p_mass_move_id in number,
47 p_business_group_id in number,
48 p_source_organization in varchar2,
49 p_session_date in date,
50 p_end_of_time in date,
51 p_position_name in varchar2,
52 p_job_name in varchar2,
53 p_attribute_category in varchar2,
54 p_attribute1 in varchar2,
55 p_attribute2 in varchar2,
56 p_attribute3 in varchar2,
57 p_attribute4 in varchar2,
58 p_attribute5 in varchar2,
59 p_attribute6 in varchar2,
60 p_attribute7 in varchar2,
61 p_attribute8 in varchar2,
62 p_attribute9 in varchar2,
63 p_attribute10 in varchar2,
64 p_attribute11 in varchar2,
65 p_attribute12 in varchar2,
66 p_attribute13 in varchar2,
67 p_attribute14 in varchar2,
68 p_attribute15 in varchar2,
69 p_attribute16 in varchar2,
70 p_attribute17 in varchar2,
71 p_attribute18 in varchar2,
72 p_attribute19 in varchar2,
73 p_attribute20 in varchar2);
74 --
75 --
76 procedure lock_row
77 (p_mass_move_id in number,
78 p_position_id in number,
79 p_select_position in varchar2,
80 p_default_from in varchar2,
81 p_deactivate_old_position in varchar2,
82 p_new_position_definition_id in number,
83 p_new_position_id in number,
84 p_target_job_id in number,
85 p_segment1 in varchar2,
86 p_segment2 in varchar2,
87 p_segment3 in varchar2,
88 p_segment4 in varchar2,
89 p_segment5 in varchar2,
90 p_segment6 in varchar2,
91 p_segment7 in varchar2,
92 p_segment8 in varchar2,
93 p_segment9 in varchar2,
94 p_segment10 in varchar2,
95 p_segment11 in varchar2,
96 p_segment12 in varchar2,
97 p_segment13 in varchar2,
98 p_segment14 in varchar2,
99 p_segment15 in varchar2,
100 p_segment16 in varchar2,
101 p_segment17 in varchar2,
102 p_segment18 in varchar2,
103 p_segment19 in varchar2,
104 p_segment20 in varchar2,
105 p_segment21 in varchar2,
106 p_segment22 in varchar2,
107 p_segment23 in varchar2,
108 p_segment24 in varchar2,
109 p_segment25 in varchar2,
110 p_segment26 in varchar2,
111 p_segment27 in varchar2,
112 p_segment28 in varchar2,
113 p_segment29 in varchar2,
114 p_segment30 in varchar2,
115 p_row_id in varchar2);
116 --
117 --
118 procedure chk_org
119 (p_new_organization_id in number,
120 p_new_position_definition_id in number);
121 --
122 --
123 procedure get_job
124 (p_new_position_definition_id in number,
125 p_organization_id out number,
126 p_new_position_id out number,
127 p_target_job_name out varchar2,
128 p_target_job_id out number,
129 p_target_job_definition_id out number);
130 --
131 procedure get_target_job
132 (p_new_job_id in number,
133 p_effective_date in date,
134 p_target_job_name out varchar2,
135 p_target_job_definition_id out number);
136 --
137
138 --
139 end PER_MM_POSITIONS_PKG;
140
[Home] [Help]