1 package hrdpp_UPLOAD_SALARY_PROPOSAL as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:53
4 * Generated for API: HR_UPLOAD_PROPOSAL_API.UPLOAD_SALARY_PROPOSAL
5 */
6 --
7 g_generator_version constant varchar2(128) default '$Revision: 120.4 $';
8 --
9
10 function dc(p in date) return varchar2;
11 pragma restrict_references(dc,WNDS);
12
13 function d(p in varchar2) return date;
14 pragma restrict_references(d,WNDS);
15 function n(p in varchar2) return number;
16 pragma restrict_references(n,WNDS);
17 function dd(p in date,i in varchar2) return varchar2;
18 pragma restrict_references(dd,WNDS);
19 function nd(p in number,i in varchar2) return varchar2;
20 pragma restrict_references(nd,WNDS);
21 --
22 procedure insert_batch_lines
23 (p_batch_id in number
24 ,p_data_pump_batch_line_id in number default null
25 ,p_data_pump_business_grp_name in varchar2 default null
26 ,p_user_sequence in number default null
27 ,p_link_value in number default null
28 ,P_CHANGE_DATE in date
29 ,P_PROPOSED_SALARY in number default null
30 ,P_PROPOSAL_REASON in varchar2 default null
31 ,P_NEXT_SAL_REVIEW_DATE in date default null
32 ,P_FORCED_RANKING in number default null
33 ,P_DATE_TO in date default null
34 ,P_PAY_PROPOSAL_ID in number
35 ,P_OBJECT_VERSION_NUMBER in number
36 ,P_COMPONENT_REASON_1 in varchar2
37 ,P_CHANGE_AMOUNT_1 in number default null
38 ,P_CHANGE_PERCENTAGE_1 in number default null
39 ,P_APPROVED_1 in varchar2
40 ,P_COMPONENT_ID_1 in number
41 ,P_PPC_OBJECT_VERSION_NUMBER_1 in number
42 ,P_COMPONENT_REASON_2 in varchar2
43 ,P_CHANGE_AMOUNT_2 in number default null
44 ,P_CHANGE_PERCENTAGE_2 in number default null
45 ,P_APPROVED_2 in varchar2
46 ,P_COMPONENT_ID_2 in number
47 ,P_PPC_OBJECT_VERSION_NUMBER_2 in number
48 ,P_COMPONENT_REASON_3 in varchar2
49 ,P_CHANGE_AMOUNT_3 in number default null
50 ,P_CHANGE_PERCENTAGE_3 in number default null
51 ,P_APPROVED_3 in varchar2
52 ,P_COMPONENT_ID_3 in number
53 ,P_PPC_OBJECT_VERSION_NUMBER_3 in number
54 ,P_COMPONENT_REASON_4 in varchar2
55 ,P_CHANGE_AMOUNT_4 in number default null
56 ,P_CHANGE_PERCENTAGE_4 in number default null
57 ,P_APPROVED_4 in varchar2
58 ,P_COMPONENT_ID_4 in number
59 ,P_PPC_OBJECT_VERSION_NUMBER_4 in number
60 ,P_COMPONENT_REASON_5 in varchar2
61 ,P_CHANGE_AMOUNT_5 in number default null
62 ,P_CHANGE_PERCENTAGE_5 in number default null
63 ,P_APPROVED_5 in varchar2
64 ,P_COMPONENT_ID_5 in number
65 ,P_PPC_OBJECT_VERSION_NUMBER_5 in number
66 ,P_COMPONENT_REASON_6 in varchar2
67 ,P_CHANGE_AMOUNT_6 in number default null
68 ,P_CHANGE_PERCENTAGE_6 in number default null
69 ,P_APPROVED_6 in varchar2
70 ,P_COMPONENT_ID_6 in number
71 ,P_PPC_OBJECT_VERSION_NUMBER_6 in number
72 ,P_COMPONENT_REASON_7 in varchar2
73 ,P_CHANGE_AMOUNT_7 in number default null
74 ,P_CHANGE_PERCENTAGE_7 in number default null
75 ,P_APPROVED_7 in varchar2
76 ,P_COMPONENT_ID_7 in number
77 ,P_PPC_OBJECT_VERSION_NUMBER_7 in number
78 ,P_COMPONENT_REASON_8 in varchar2
79 ,P_CHANGE_AMOUNT_8 in number default null
80 ,P_CHANGE_PERCENTAGE_8 in number default null
81 ,P_APPROVED_8 in varchar2
82 ,P_COMPONENT_ID_8 in number
83 ,P_PPC_OBJECT_VERSION_NUMBER_8 in number
84 ,P_COMPONENT_REASON_9 in varchar2
85 ,P_CHANGE_AMOUNT_9 in number default null
86 ,P_CHANGE_PERCENTAGE_9 in number default null
87 ,P_APPROVED_9 in varchar2
88 ,P_COMPONENT_ID_9 in number
89 ,P_PPC_OBJECT_VERSION_NUMBER_9 in number
90 ,P_COMPONENT_REASON_10 in varchar2
91 ,P_CHANGE_AMOUNT_10 in number default null
92 ,P_CHANGE_PERCENTAGE_10 in number default null
93 ,P_APPROVED_10 in varchar2
94 ,P_COMPONENT_ID_10 in number
95 ,P_PPC_OBJECT_VERSION_NUMBER_10 in number
96 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
97 ,P_ATTRIBUTE1 in varchar2 default null
98 ,P_ATTRIBUTE2 in varchar2 default null
99 ,P_ATTRIBUTE3 in varchar2 default null
100 ,P_ATTRIBUTE4 in varchar2 default null
101 ,P_ATTRIBUTE5 in varchar2 default null
102 ,P_ATTRIBUTE6 in varchar2 default null
103 ,P_ATTRIBUTE7 in varchar2 default null
104 ,P_ATTRIBUTE8 in varchar2 default null
105 ,P_ATTRIBUTE9 in varchar2 default null
106 ,P_ATTRIBUTE10 in varchar2 default null
107 ,P_ATTRIBUTE11 in varchar2 default null
108 ,P_ATTRIBUTE12 in varchar2 default null
109 ,P_ATTRIBUTE13 in varchar2 default null
110 ,P_ATTRIBUTE14 in varchar2 default null
111 ,P_ATTRIBUTE15 in varchar2 default null
112 ,P_ATTRIBUTE16 in varchar2 default null
113 ,P_ATTRIBUTE17 in varchar2 default null
114 ,P_ATTRIBUTE18 in varchar2 default null
115 ,P_ATTRIBUTE19 in varchar2 default null
116 ,P_ATTRIBUTE20 in varchar2 default null
117 ,P_ASSIGNMENT_USER_KEY in varchar2);
118 --
119 procedure call
120 (p_business_group_id in number,
121 p_batch_line_id in number);
122 end hrdpp_UPLOAD_SALARY_PROPOSAL;
[Home] [Help]