APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PAY_BALANCE_BATCH_HEADERS

Line 100: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;

96: p_batch_status in varchar2 default 'U',
97: p_batch_id out nocopy number ) is
98:
99: l_bg_name per_business_groups.name%TYPE;
100: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;
101:
102: l_new_header_id number;
103:
104: Begin

Line 121: from pay_balance_batch_headers

117:
118:
119: hr_utility.trace('l_batch_name, before selecting' || l_batch_name);
120: select batch_name into l_batch_name
121: from pay_balance_batch_headers
122: where upper(batch_name) = upper(p_batch_name)
123: and business_group_id = p_business_group_id;
124:
125: hr_utility.trace('l_batch_name, after selecting' || l_batch_name);

Line 158: insert into pay_balance_batch_headers

154: from dual;
155:
156: -- create batch header
157:
158: insert into pay_balance_batch_headers
159: (batch_id,
160: batch_name,
161: business_group_id,
162: batch_status,

Line 170: values (p_batch_id, --pay_balance_batch_headers_s.nextval,

166: payroll_id,
167: payroll_name,
168: upload_date,
169: batch_type)
170: values (p_batch_id, --pay_balance_batch_headers_s.nextval,
171: p_batch_name,
172: p_business_group_id,
173: 'U', -- Unprocessed
174: p_batch_reference,

Line 192: l_batch_status pay_balance_batch_headers.batch_status%TYPE;

188: p_batch_reference in varchar2 default hr_api.g_varchar2,
189: p_batch_source in varchar2 default hr_api.g_varchar2,
190: p_batch_status in varchar2 default hr_api.g_varchar2) is
191:
192: l_batch_status pay_balance_batch_headers.batch_status%TYPE;
193: l_bg_name per_business_groups.name%TYPE;
194: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;
195:
196:

Line 194: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;

190: p_batch_status in varchar2 default hr_api.g_varchar2) is
191:
192: l_batch_status pay_balance_batch_headers.batch_status%TYPE;
193: l_bg_name per_business_groups.name%TYPE;
194: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;
195:
196:
197: Begin
198:

Line 211: FROM pay_balance_batch_headers

207: -- Bug: 5226336
208:
209: SELECT batch_status, business_group_name
210: INTO l_batch_status, l_bg_name
211: FROM pay_balance_batch_headers
212: WHERE batch_id = p_batch_id;
213:
214: hr_utility.trace('l_batch_status: ' || l_batch_status);
215: hr_utility.trace('l_bg_name: ' || l_bg_name);

Line 219: FROM pay_balance_batch_headers

215: hr_utility.trace('l_bg_name: ' || l_bg_name);
216:
217: SELECT batch_name
218: INTO l_batch_name
219: FROM pay_balance_batch_headers
220: WHERE upper(batch_name) = upper(p_batch_name)
221: AND business_group_name = l_bg_name;
222:
223: IF l_batch_name is not null THEN

Line 251: UPDATE pay_balance_batch_headers

247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);
250:
251: UPDATE pay_balance_batch_headers
252: SET batch_name = p_batch_name,
253: batch_reference = p_batch_reference,
254: batch_source = p_batch_source
255: WHERE batch_id = p_batch_id;

Line 262: hr_utility.trace('Exception: unable to update pay_balance_batch_headers table.');

258:
259: EXCEPTION
260:
261: WHEN OTHERS THEN
262: hr_utility.trace('Exception: unable to update pay_balance_batch_headers table.');
263: hr_utility.raise_error;
264: END;
265: END IF;
266: