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