DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on FND_DATE

Line 480: now := fnd_date.date_to_canonical (SYSDATE);

476: WHERE payroll_action_id = l_payroll_action_id;
477: --
478: hr_utility.set_location ('arch_report_header',115);
479: --
480: now := fnd_date.date_to_canonical (SYSDATE);
481: title := centre ('ARCHIVE DIFFERENCES REPORT',100);
482: --
483: arch_output (title || LPAD(now,100-LENGTH(title)));
484: arch_output (centre('==========================',100));

Line 487: arch_output ('Effective Date: ' || fnd_date.date_to_canonical(l_effective_date

483: arch_output (title || LPAD(now,100-LENGTH(title)));
484: arch_output (centre('==========================',100));
485: arch_output ('');
486: arch_output ('Payroll Action ID: ' || l_payroll_action_id);
487: arch_output ('Effective Date: ' || fnd_date.date_to_canonical(l_effective_date
488: ));
489: arch_output ('Report Type: ' || l_report_type);
490: arch_output ('State: ' || l_state);
491: arch_output ('Period: ' || period);

Line 779: -- result := TO_CHAR (fnd_date.canonical_to_date(result));

775: -- Ensure date is in correct format
776: --------------------------------------------------------------------------------
777: -- Commented it out because run_db_item already returns date in proper format.
778: -- IF l_employer_dbis.data_type(i) = 'D' THEN
779: -- result := TO_CHAR (fnd_date.canonical_to_date(result));
780: -- END IF;
781: --
782: --------------------------------------------------------------------------------
783: -- Store data

Line 853: fnd_date.date_to_canonical(employee_row.date_earned));

849: -- Setup contexts
850: --------------------------------------------------------------------------------
851: pay_balance_pkg.set_context ('ASSIGNMENT_ID',employee_row.assignment_id);
852: pay_balance_pkg.set_context ('DATE_EARNED',
853: fnd_date.date_to_canonical(employee_row.date_earned));
854: pay_balance_pkg.set_context ('TAX_UNIT_ID',employee_row.tax_unit_id);
855: --
856: IF l_effective_date > employee_row.date_earned THEN
857: SELECT MAX(assignment_action_id)

Line 911: -- result := TO_CHAR (fnd_date.canonical_to_date(result));

907: -- Ensure date is in correct format
908: --------------------------------------------------------------------------------
909: -- Commented it out because run_db_item already returns date in proper format.
910: -- IF l_assignment_dbis.data_type(i) = 'D' THEN
911: -- result := TO_CHAR (fnd_date.canonical_to_date(result));
912: -- END IF;
913: --
914: hr_utility.trace ('** Assignments loop ** ' ||
915: l_assignment_dbis.item_name(i) || ' = ' || result);