DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on FND_DATE

Line 568: fnd_date.date_to_canonical(p_submission_start_date),

564: fnd_number.number_to_canonical(p_payroll_id),
565: fnd_number.number_to_canonical(p_organization_id),
566: fnd_number.number_to_canonical(p_assignment_set_id),
567: p_submission_period_status,
568: fnd_date.date_to_canonical(p_submission_start_date),
569: fnd_date.date_to_canonical(p_submission_end_date),
570: p_tax_office_name,
571: p_salary_payer_name,
572: p_salary_payer_address);

Line 569: fnd_date.date_to_canonical(p_submission_end_date),

565: fnd_number.number_to_canonical(p_organization_id),
566: fnd_number.number_to_canonical(p_assignment_set_id),
567: p_submission_period_status,
568: fnd_date.date_to_canonical(p_submission_start_date),
569: fnd_date.date_to_canonical(p_submission_end_date),
570: p_tax_office_name,
571: p_salary_payer_name,
572: p_salary_payer_address);
573: --

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

608: --
609: update pay_jp_isdf_pact_dml_v
610: set object_version_number = p_object_version_number,
611: submission_period_status = p_submission_period_status,
612: submission_start_date = fnd_date.date_to_canonical(p_submission_start_date),
613: submission_end_date = fnd_date.date_to_canonical(p_submission_end_date),
614: tax_office_name = p_tax_office_name,
615: salary_payer_name = p_salary_payer_name,
616: salary_payer_address = p_salary_payer_address

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

609: update pay_jp_isdf_pact_dml_v
610: set object_version_number = p_object_version_number,
611: submission_period_status = p_submission_period_status,
612: submission_start_date = fnd_date.date_to_canonical(p_submission_start_date),
613: submission_end_date = fnd_date.date_to_canonical(p_submission_end_date),
614: tax_office_name = p_tax_office_name,
615: salary_payer_name = p_salary_payer_name,
616: salary_payer_address = p_salary_payer_address
617: where row_id = l_rec.row_id;

Line 682: fnd_date.date_to_canonical(p_finalized_date),

678: p_effective_date,
679: p_action_information_category,
680: p_tax_type,
681: p_transaction_status,
682: fnd_date.date_to_canonical(p_finalized_date),
683: fnd_number.number_to_canonical(p_finalized_by),
684: p_user_comments,
685: p_admin_comments,
686: p_transfer_status,

Line 687: fnd_date.date_to_canonical(p_transfer_date),

683: fnd_number.number_to_canonical(p_finalized_by),
684: p_user_comments,
685: p_admin_comments,
686: p_transfer_status,
687: fnd_date.date_to_canonical(p_transfer_date),
688: fnd_date.date_to_canonical(p_expiry_date));
689: --
690: if g_debug then
691: hr_utility.set_location(l_proc,1000);

Line 688: fnd_date.date_to_canonical(p_expiry_date));

684: p_user_comments,
685: p_admin_comments,
686: p_transfer_status,
687: fnd_date.date_to_canonical(p_transfer_date),
688: fnd_date.date_to_canonical(p_expiry_date));
689: --
690: if g_debug then
691: hr_utility.set_location(l_proc,1000);
692: end if;

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

726: --
727: update pay_jp_isdf_assact_dml_v
728: set object_version_number = p_object_version_number,
729: transaction_status = p_transaction_status,
730: finalized_date = fnd_date.date_to_canonical(p_finalized_date),
731: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
732: user_comments = p_user_comments,
733: admin_comments = p_admin_comments,
734: transfer_status = p_transfer_status,

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

731: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
732: user_comments = p_user_comments,
733: admin_comments = p_admin_comments,
734: transfer_status = p_transfer_status,
735: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
736: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
737: where row_id = l_rec.row_id;
738: --
739: if g_debug then

Line 736: expiry_date = fnd_date.date_to_canonical(p_expiry_date)

732: user_comments = p_user_comments,
733: admin_comments = p_admin_comments,
734: transfer_status = p_transfer_status,
735: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
736: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
737: where row_id = l_rec.row_id;
738: --
739: if g_debug then
740: hr_utility.set_location(l_proc,1000);

Line 1485: fnd_date.date_to_canonical(p_ins_period_start_date),

1481: p_pens_ins_class,
1482: p_pens_ins_company_code,
1483: p_ins_company_name,
1484: p_ins_type,
1485: fnd_date.date_to_canonical(p_ins_period_start_date),
1486: p_ins_period,
1487: p_contractor_name,
1488: p_beneficiary_name,
1489: p_beneficiary_relship,

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

1531: set object_version_number = p_object_version_number,
1532: status = p_status,
1533: ins_company_name = p_ins_company_name,
1534: ins_type = p_ins_type,
1535: ins_period_start_date = fnd_date.date_to_canonical(p_ins_period_start_date),
1536: ins_period = p_ins_period,
1537: contractor_name = p_contractor_name,
1538: beneficiary_name = p_beneficiary_name,
1539: beneficiary_relship = p_beneficiary_relship,