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);
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: --
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
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;
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,
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);
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;
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,
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
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);
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,
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,