DBA Data[Home] [Help]

APPS.PAY_VOID_REVERSAL_PKG dependencies on FND_DATE

Line 228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));

224:
225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);

Line 241: -- fnd_date.date_to_canonical(to_date(p_effective_date,'DD-MM-YYYY'))

237:
238:
239: -- Derive the values before
240: -- use this for date conversion
241: -- fnd_date.date_to_canonical(to_date(p_effective_date,'DD-MM-YYYY'))
242: -- use this for number conversion
243: -- to_number(check_details_rec.start_cheque_number,'9999999999999999')
244:
245: l_request_id := fnd_request.submit_request (

Line 249: start_time => fnd_date.date_to_canonical(sysdate),

245: l_request_id := fnd_request.submit_request (
246: application => 'PAY',
247: program => 'US_CHECK_OVERRIDE_PAYMENT',
248: description => null,
249: start_time => fnd_date.date_to_canonical(sysdate),
250: sub_request => null,
251: argument1 => 'CHEQUE', -- Process Name
252: argument2 => check_details_rec.payroll_id, -- Payroll
253: argument3 => check_details_rec.consolidation_set_id, --Consolidation Set

Line 254: argument4 => fnd_date.date_to_canonical(check_details_rec.start_date), -- Start Date

250: sub_request => null,
251: argument1 => 'CHEQUE', -- Process Name
252: argument2 => check_details_rec.payroll_id, -- Payroll
253: argument3 => check_details_rec.consolidation_set_id, --Consolidation Set
254: argument4 => fnd_date.date_to_canonical(check_details_rec.start_date), -- Start Date
255: argument5 => fnd_date.date_to_canonical(to_date(p_end_date,l_format)), -- End Date
256: argument6 => check_details_rec.payment_type_id, -- Payment Type Default = CHECK
257: argument7 => check_details_rec.org_payment_method_id, -- Payment Method
258: argument8 => check_details_rec.cheque_procedure, -- Sort Sequence

Line 255: argument5 => fnd_date.date_to_canonical(to_date(p_end_date,l_format)), -- End Date

251: argument1 => 'CHEQUE', -- Process Name
252: argument2 => check_details_rec.payroll_id, -- Payroll
253: argument3 => check_details_rec.consolidation_set_id, --Consolidation Set
254: argument4 => fnd_date.date_to_canonical(check_details_rec.start_date), -- Start Date
255: argument5 => fnd_date.date_to_canonical(to_date(p_end_date,l_format)), -- End Date
256: argument6 => check_details_rec.payment_type_id, -- Payment Type Default = CHECK
257: argument7 => check_details_rec.org_payment_method_id, -- Payment Method
258: argument8 => check_details_rec.cheque_procedure, -- Sort Sequence
259: argument9 => check_details_rec.cheque_report, -- Check Style

Line 263: argument13 => fnd_date.date_to_canonical(to_date(p_overriding_check_date,l_format)), -- Overriding Cheque Date

259: argument9 => check_details_rec.cheque_report, -- Check Style
260: argument10 => to_number(p_start_check_number,'99999999999999999'), -- Start Check Number
261: argument11 => null, -- End Check Number
262: argument12 => null, -- Action Parameter Group
263: argument13 => fnd_date.date_to_canonical(to_date(p_overriding_check_date,l_format)), -- Overriding Cheque Date
264: argument14 => l_asg_set_id, -- Assignment Set,
265: argument15 => 'CHQVNR' -- tell cheque writer its being called from VnR
266: );
267:

Line 400: start_time => fnd_date.date_to_canonical(sysdate),

396: l_request_id := fnd_request.submit_request (
397: application => 'PAY',
398: program => 'PYVDUSPY',
399: description => null,
400: start_time => fnd_date.date_to_canonical(sysdate),
401: sub_request => null,
402: argument1 => l_payroll_action_id, -- Payroll Action Id
403: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- Effective Date
404: argument3 => p_reason, -- Reason

Line 403: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- Effective Date

399: description => null,
400: start_time => fnd_date.date_to_canonical(sysdate),
401: sub_request => null,
402: argument1 => l_payroll_action_id, -- Payroll Action Id
403: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- Effective Date
404: argument3 => p_reason, -- Reason
405: argument4 => to_number(l_start_cheque_number,'9999999999999999'), -- Start Check Number
406: argument5 => to_number(l_start_cheque_number,'9999999999999999') -- End check number
407: );

Line 502: start_time => fnd_date.date_to_canonical(sysdate),

498: l_request_id := fnd_request.submit_request (
499: application => 'PAY',
500: program => 'PYEXMNPT',
501: description => null,
502: start_time => fnd_date.date_to_canonical(sysdate),
503: sub_request => null,
504: argument1 => l_payroll_id, -- payroll_id
505: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date
506: argument3 => l_prepayment_asg_action, -- assignment_action_id for pre payments

Line 505: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date

501: description => null,
502: start_time => fnd_date.date_to_canonical(sysdate),
503: sub_request => null,
504: argument1 => l_payroll_id, -- payroll_id
505: argument2 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date
506: argument3 => l_prepayment_asg_action, -- assignment_action_id for pre payments
507: argument4 => l_assignment_id, -- assignment_id
508: argument5 => p_comments, -- comments
509: argument6 => l_serial_number, -- serial number

Line 649: start_time => fnd_date.date_to_canonical(sysdate),

645: l_request_id := fnd_request.submit_request (
646: application => 'PAY',
647: program => 'PYREVPAY',
648: description => null,
649: start_time => fnd_date.date_to_canonical(sysdate),
650: sub_request => null,
651: argument1 => 'V', -- action_type
652: argument2 => payroll_action_rec.business_group_id, -- business_group_id
653: argument3 => payroll_action_rec.consolidation_set_id, -- consolidation_set_id

Line 657: argument7 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date

653: argument3 => payroll_action_rec.consolidation_set_id, -- consolidation_set_id
654: argument4 => payroll_action_rec.payroll_id, -- payroll_id
655: argument5 => payroll_action_rec.action_population_status, -- action_population_status
656: argument6 => payroll_action_rec.action_status, -- action_status
657: argument7 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date
658: argument8 => l_payroll_run_asg_action -- assignment_action_id for payroll run
659: );
660: hr_utility.set_location(l_proc, 30);
661: end if;