DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_UPLOAD_PROPOSAL_BK1

Source


1 package body HR_UPLOAD_PROPOSAL_BK1 as
2 /* $Header: hrpypapi.pkb 120.30.12010000.13 2009/01/16 09:51:09 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:08 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPLOAD_SALARY_PROPOSAL_A
6 (P_CHANGE_DATE in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_ASSIGNMENT_ID in NUMBER
9 ,P_PROPOSED_SALARY in NUMBER
10 ,P_PROPOSAL_REASON in VARCHAR2
11 ,P_NEXT_SAL_REVIEW_DATE in DATE
12 ,P_FORCED_RANKING in NUMBER
13 ,P_DATE_TO in DATE
14 ,P_PAY_PROPOSAL_ID in NUMBER
15 ,P_OBJECT_VERSION_NUMBER in NUMBER
16 ,P_COMPONENT_REASON_1 in VARCHAR2
17 ,P_CHANGE_AMOUNT_1 in NUMBER
18 ,P_CHANGE_PERCENTAGE_1 in NUMBER
19 ,P_APPROVED_1 in VARCHAR2
20 ,P_COMPONENT_ID_1 in NUMBER
21 ,P_PPC_OBJECT_VERSION_NUMBER_1 in NUMBER
22 ,P_COMPONENT_REASON_2 in VARCHAR2
23 ,P_CHANGE_AMOUNT_2 in NUMBER
24 ,P_CHANGE_PERCENTAGE_2 in NUMBER
25 ,P_APPROVED_2 in VARCHAR2
26 ,P_COMPONENT_ID_2 in NUMBER
27 ,P_PPC_OBJECT_VERSION_NUMBER_2 in NUMBER
28 ,P_COMPONENT_REASON_3 in VARCHAR2
29 ,P_CHANGE_AMOUNT_3 in NUMBER
30 ,P_CHANGE_PERCENTAGE_3 in NUMBER
31 ,P_APPROVED_3 in VARCHAR2
32 ,P_COMPONENT_ID_3 in NUMBER
33 ,P_PPC_OBJECT_VERSION_NUMBER_3 in NUMBER
34 ,P_COMPONENT_REASON_4 in VARCHAR2
35 ,P_CHANGE_AMOUNT_4 in NUMBER
36 ,P_CHANGE_PERCENTAGE_4 in NUMBER
37 ,P_APPROVED_4 in VARCHAR2
38 ,P_COMPONENT_ID_4 in NUMBER
39 ,P_PPC_OBJECT_VERSION_NUMBER_4 in NUMBER
40 ,P_COMPONENT_REASON_5 in VARCHAR2
41 ,P_CHANGE_AMOUNT_5 in NUMBER
42 ,P_CHANGE_PERCENTAGE_5 in NUMBER
43 ,P_APPROVED_5 in VARCHAR2
44 ,P_COMPONENT_ID_5 in NUMBER
45 ,P_PPC_OBJECT_VERSION_NUMBER_5 in NUMBER
46 ,P_COMPONENT_REASON_6 in VARCHAR2
47 ,P_CHANGE_AMOUNT_6 in NUMBER
48 ,P_CHANGE_PERCENTAGE_6 in NUMBER
49 ,P_APPROVED_6 in VARCHAR2
50 ,P_COMPONENT_ID_6 in NUMBER
51 ,P_PPC_OBJECT_VERSION_NUMBER_6 in NUMBER
52 ,P_COMPONENT_REASON_7 in VARCHAR2
53 ,P_CHANGE_AMOUNT_7 in NUMBER
54 ,P_CHANGE_PERCENTAGE_7 in NUMBER
55 ,P_APPROVED_7 in VARCHAR2
56 ,P_COMPONENT_ID_7 in NUMBER
57 ,P_PPC_OBJECT_VERSION_NUMBER_7 in NUMBER
58 ,P_COMPONENT_REASON_8 in VARCHAR2
59 ,P_CHANGE_AMOUNT_8 in NUMBER
60 ,P_CHANGE_PERCENTAGE_8 in NUMBER
61 ,P_APPROVED_8 in VARCHAR2
62 ,P_COMPONENT_ID_8 in NUMBER
63 ,P_PPC_OBJECT_VERSION_NUMBER_8 in NUMBER
64 ,P_COMPONENT_REASON_9 in VARCHAR2
65 ,P_CHANGE_AMOUNT_9 in NUMBER
66 ,P_CHANGE_PERCENTAGE_9 in NUMBER
67 ,P_APPROVED_9 in VARCHAR2
68 ,P_COMPONENT_ID_9 in NUMBER
69 ,P_PPC_OBJECT_VERSION_NUMBER_9 in NUMBER
70 ,P_COMPONENT_REASON_10 in VARCHAR2
71 ,P_CHANGE_AMOUNT_10 in NUMBER
72 ,P_CHANGE_PERCENTAGE_10 in NUMBER
73 ,P_APPROVED_10 in VARCHAR2
74 ,P_COMPONENT_ID_10 in NUMBER
75 ,P_PPC_OBJECT_VERSION_NUMBER_10 in NUMBER
76 ,P_PYP_PROPOSED_SAL_WARNING in BOOLEAN
77 ,P_ADDITIONAL_COMP_WARNING in BOOLEAN
78 )is
79 begin
80 hr_utility.set_location('Entering: HR_UPLOAD_PROPOSAL_BK1.UPLOAD_SALARY_PROPOSAL_A', 10);
81 hr_utility.set_location(' Leaving: HR_UPLOAD_PROPOSAL_BK1.UPLOAD_SALARY_PROPOSAL_A', 20);
82 end UPLOAD_SALARY_PROPOSAL_A;
83 procedure UPLOAD_SALARY_PROPOSAL_B
84 (P_CHANGE_DATE in DATE
85 ,P_BUSINESS_GROUP_ID in NUMBER
86 ,P_ASSIGNMENT_ID in NUMBER
87 ,P_PROPOSED_SALARY in NUMBER
88 ,P_PROPOSAL_REASON in VARCHAR2
89 ,P_NEXT_SAL_REVIEW_DATE in DATE
90 ,P_FORCED_RANKING in NUMBER
91 ,P_DATE_TO in DATE
92 ,P_PAY_PROPOSAL_ID in NUMBER
93 ,P_OBJECT_VERSION_NUMBER in NUMBER
94 ,P_COMPONENT_REASON_1 in VARCHAR2
95 ,P_CHANGE_AMOUNT_1 in NUMBER
96 ,P_CHANGE_PERCENTAGE_1 in NUMBER
97 ,P_APPROVED_1 in VARCHAR2
98 ,P_COMPONENT_ID_1 in NUMBER
99 ,P_PPC_OBJECT_VERSION_NUMBER_1 in NUMBER
100 ,P_COMPONENT_REASON_2 in VARCHAR2
101 ,P_CHANGE_AMOUNT_2 in NUMBER
102 ,P_CHANGE_PERCENTAGE_2 in NUMBER
103 ,P_APPROVED_2 in VARCHAR2
104 ,P_COMPONENT_ID_2 in NUMBER
105 ,P_PPC_OBJECT_VERSION_NUMBER_2 in NUMBER
106 ,P_COMPONENT_REASON_3 in VARCHAR2
107 ,P_CHANGE_AMOUNT_3 in NUMBER
108 ,P_CHANGE_PERCENTAGE_3 in NUMBER
109 ,P_APPROVED_3 in VARCHAR2
110 ,P_COMPONENT_ID_3 in NUMBER
111 ,P_PPC_OBJECT_VERSION_NUMBER_3 in NUMBER
112 ,P_COMPONENT_REASON_4 in VARCHAR2
113 ,P_CHANGE_AMOUNT_4 in NUMBER
114 ,P_CHANGE_PERCENTAGE_4 in NUMBER
115 ,P_APPROVED_4 in VARCHAR2
116 ,P_COMPONENT_ID_4 in NUMBER
117 ,P_PPC_OBJECT_VERSION_NUMBER_4 in NUMBER
118 ,P_COMPONENT_REASON_5 in VARCHAR2
119 ,P_CHANGE_AMOUNT_5 in NUMBER
120 ,P_CHANGE_PERCENTAGE_5 in NUMBER
121 ,P_APPROVED_5 in VARCHAR2
122 ,P_COMPONENT_ID_5 in NUMBER
123 ,P_PPC_OBJECT_VERSION_NUMBER_5 in NUMBER
124 ,P_COMPONENT_REASON_6 in VARCHAR2
125 ,P_CHANGE_AMOUNT_6 in NUMBER
126 ,P_CHANGE_PERCENTAGE_6 in NUMBER
127 ,P_APPROVED_6 in VARCHAR2
128 ,P_COMPONENT_ID_6 in NUMBER
129 ,P_PPC_OBJECT_VERSION_NUMBER_6 in NUMBER
130 ,P_COMPONENT_REASON_7 in VARCHAR2
131 ,P_CHANGE_AMOUNT_7 in NUMBER
132 ,P_CHANGE_PERCENTAGE_7 in NUMBER
133 ,P_APPROVED_7 in VARCHAR2
134 ,P_COMPONENT_ID_7 in NUMBER
135 ,P_PPC_OBJECT_VERSION_NUMBER_7 in NUMBER
136 ,P_COMPONENT_REASON_8 in VARCHAR2
137 ,P_CHANGE_AMOUNT_8 in NUMBER
138 ,P_CHANGE_PERCENTAGE_8 in NUMBER
139 ,P_APPROVED_8 in VARCHAR2
140 ,P_COMPONENT_ID_8 in NUMBER
141 ,P_PPC_OBJECT_VERSION_NUMBER_8 in NUMBER
142 ,P_COMPONENT_REASON_9 in VARCHAR2
143 ,P_CHANGE_AMOUNT_9 in NUMBER
144 ,P_CHANGE_PERCENTAGE_9 in NUMBER
145 ,P_APPROVED_9 in VARCHAR2
146 ,P_COMPONENT_ID_9 in NUMBER
147 ,P_PPC_OBJECT_VERSION_NUMBER_9 in NUMBER
148 ,P_COMPONENT_REASON_10 in VARCHAR2
149 ,P_CHANGE_AMOUNT_10 in NUMBER
150 ,P_CHANGE_PERCENTAGE_10 in NUMBER
151 ,P_APPROVED_10 in VARCHAR2
152 ,P_COMPONENT_ID_10 in NUMBER
153 ,P_PPC_OBJECT_VERSION_NUMBER_10 in NUMBER
154 )is
155 begin
156 hr_utility.set_location('Entering: HR_UPLOAD_PROPOSAL_BK1.UPLOAD_SALARY_PROPOSAL_B', 10);
157 hr_utility.set_location(' Leaving: HR_UPLOAD_PROPOSAL_BK1.UPLOAD_SALARY_PROPOSAL_B', 20);
158 end UPLOAD_SALARY_PROPOSAL_B;
159 end HR_UPLOAD_PROPOSAL_BK1;