DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on FND_DATE

Line 649: fnd_date.date_to_canonical(p_submission_start_date),

645: fnd_number.number_to_canonical(p_payroll_id),
646: fnd_number.number_to_canonical(p_organization_id),
647: fnd_number.number_to_canonical(p_assignment_set_id),
648: p_submission_period_status,
649: fnd_date.date_to_canonical(p_submission_start_date),
650: fnd_date.date_to_canonical(p_submission_end_date),
651: p_tax_office_name,
652: p_salary_payer_name,
653: p_salary_payer_address);

Line 650: fnd_date.date_to_canonical(p_submission_end_date),

646: fnd_number.number_to_canonical(p_organization_id),
647: fnd_number.number_to_canonical(p_assignment_set_id),
648: p_submission_period_status,
649: fnd_date.date_to_canonical(p_submission_start_date),
650: fnd_date.date_to_canonical(p_submission_end_date),
651: p_tax_office_name,
652: p_salary_payer_name,
653: p_salary_payer_address);
654: --

Line 693: submission_start_date = fnd_date.date_to_canonical(p_submission_start_date),

689: --
690: update pay_jp_isdf_pact_dml_v
691: set object_version_number = p_object_version_number,
692: submission_period_status = p_submission_period_status,
693: submission_start_date = fnd_date.date_to_canonical(p_submission_start_date),
694: submission_end_date = fnd_date.date_to_canonical(p_submission_end_date),
695: tax_office_name = p_tax_office_name,
696: salary_payer_name = p_salary_payer_name,
697: salary_payer_address = p_salary_payer_address

Line 694: submission_end_date = fnd_date.date_to_canonical(p_submission_end_date),

690: update pay_jp_isdf_pact_dml_v
691: set object_version_number = p_object_version_number,
692: submission_period_status = p_submission_period_status,
693: submission_start_date = fnd_date.date_to_canonical(p_submission_start_date),
694: submission_end_date = fnd_date.date_to_canonical(p_submission_end_date),
695: tax_office_name = p_tax_office_name,
696: salary_payer_name = p_salary_payer_name,
697: salary_payer_address = p_salary_payer_address
698: where row_id = l_rec.row_id;

Line 763: fnd_date.date_to_canonical(p_finalized_date),

759: p_effective_date,
760: p_action_information_category,
761: p_tax_type,
762: p_transaction_status,
763: fnd_date.date_to_canonical(p_finalized_date),
764: fnd_number.number_to_canonical(p_finalized_by),
765: p_user_comments,
766: p_admin_comments,
767: p_transfer_status,

Line 768: fnd_date.date_to_canonical(p_transfer_date),

764: fnd_number.number_to_canonical(p_finalized_by),
765: p_user_comments,
766: p_admin_comments,
767: p_transfer_status,
768: fnd_date.date_to_canonical(p_transfer_date),
769: fnd_date.date_to_canonical(p_expiry_date));
770: --
771: if g_debug then
772: hr_utility.set_location(l_proc,1000);

Line 769: fnd_date.date_to_canonical(p_expiry_date));

765: p_user_comments,
766: p_admin_comments,
767: p_transfer_status,
768: fnd_date.date_to_canonical(p_transfer_date),
769: fnd_date.date_to_canonical(p_expiry_date));
770: --
771: if g_debug then
772: hr_utility.set_location(l_proc,1000);
773: end if;

Line 811: finalized_date = fnd_date.date_to_canonical(p_finalized_date),

807: --
808: update pay_jp_isdf_assact_dml_v
809: set object_version_number = p_object_version_number,
810: transaction_status = p_transaction_status,
811: finalized_date = fnd_date.date_to_canonical(p_finalized_date),
812: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
813: user_comments = p_user_comments,
814: admin_comments = p_admin_comments,
815: transfer_status = p_transfer_status,

Line 816: transfer_date = fnd_date.date_to_canonical(p_transfer_date),

812: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
813: user_comments = p_user_comments,
814: admin_comments = p_admin_comments,
815: transfer_status = p_transfer_status,
816: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
817: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
818: where row_id = l_rec.row_id;
819: --
820: if g_debug then

Line 817: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

813: user_comments = p_user_comments,
814: admin_comments = p_admin_comments,
815: transfer_status = p_transfer_status,
816: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
817: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
818: where row_id = l_rec.row_id;
819: --
820: if g_debug then
821: hr_utility.set_location(l_proc,1000);

Line 1878: fnd_date.date_to_canonical(p_ins_period_start_date),

1874: p_pens_ins_class,
1875: p_pens_ins_company_code,
1876: p_ins_company_name,
1877: p_ins_type,
1878: fnd_date.date_to_canonical(p_ins_period_start_date),
1879: p_ins_period,
1880: p_contractor_name,
1881: p_beneficiary_name,
1882: p_beneficiary_relship,

Line 1930: ins_period_start_date = fnd_date.date_to_canonical(p_ins_period_start_date),

1926: set object_version_number = p_object_version_number,
1927: status = p_status,
1928: ins_company_name = p_ins_company_name,
1929: ins_type = p_ins_type,
1930: ins_period_start_date = fnd_date.date_to_canonical(p_ins_period_start_date),
1931: ins_period = p_ins_period,
1932: contractor_name = p_contractor_name,
1933: beneficiary_name = p_beneficiary_name,
1934: beneficiary_relship = p_beneficiary_relship,