DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  select pay_action_information_s.nextval
  into   l_action_information_id
  from   dual;
Line: 47

  select *
  into   p_rec
  from   pay_jp_isdf_pact_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 67

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 87

  select *
  into   p_rec
  from   pay_jp_isdf_assact_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 107

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 127

  select *
  into   p_rec
  from   pay_jp_isdf_emp_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 147

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 167

  select *
  into   p_rec
  from   pay_jp_isdf_entry_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 187

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 207

  select *
  into   p_rec
  from   pay_jp_isdf_calc_dct_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 227

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 247

  select *
  into   p_rec
  from   pay_jp_isdf_calc_dct_v2
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 267

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 287

  select *
  into   p_rec
  from   pay_jp_isdf_life_gen_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 307

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 327

  select *
  into   p_rec
  from   pay_jp_isdf_care_med_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 347

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 368

  select *
  into   p_rec
  from   pay_jp_isdf_life_pens_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 388

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 408

  select *
  into   p_rec
  from   pay_jp_isdf_nonlife_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 428

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 448

  select *
  into   p_rec
  from   pay_jp_isdf_social_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 468

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 488

  select *
  into   p_rec
  from   pay_jp_isdf_mutual_aid_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 508

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 528

  select *
  into   p_rec
  from   pay_jp_isdf_spouse_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 548

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 568

  select *
  into   p_rec
  from   pay_jp_isdf_spouse_inc_v
  where  action_information_id = p_action_information_id
  for update nowait;
Line: 588

    fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
Line: 622

  insert into pay_jp_isdf_pact_dml_v(
    action_information_id,
    object_version_number,
    payroll_action_id,
    action_context_type,
    effective_date,
    action_information_category,
    payroll_id,
    organization_id,
    assignment_set_id,
    submission_period_status,
    submission_start_date,
    submission_end_date,
    tax_office_name,
    salary_payer_name,
    salary_payer_address)
  values(
    p_action_information_id,
    p_object_version_number,
    p_payroll_action_id,
    p_action_context_type,
    p_effective_date,
    p_action_information_category,
    fnd_number.number_to_canonical(p_payroll_id),
    fnd_number.number_to_canonical(p_organization_id),
    fnd_number.number_to_canonical(p_assignment_set_id),
    p_submission_period_status,
    fnd_date.date_to_canonical(p_submission_start_date),
    fnd_date.date_to_canonical(p_submission_end_date),
    p_tax_office_name,
    p_salary_payer_name,
    p_salary_payer_address);
Line: 664

procedure update_pact(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_submission_period_status    in varchar2,
  p_submission_start_date       in date,
  p_submission_end_date         in date,
  p_tax_office_name             in varchar2,
  p_salary_payer_name           in varchar2,
  p_salary_payer_address        in varchar2)
is
  l_rec  pay_jp_isdf_pact_v%rowtype;
Line: 675

  l_proc varchar2(80) := c_package||'update_pact';
Line: 690

  update pay_jp_isdf_pact_dml_v
  set    object_version_number    = p_object_version_number,
         submission_period_status = p_submission_period_status,
         submission_start_date    = fnd_date.date_to_canonical(p_submission_start_date),
         submission_end_date      = fnd_date.date_to_canonical(p_submission_end_date),
         tax_office_name          = p_tax_office_name,
         salary_payer_name        = p_salary_payer_name,
         salary_payer_address     = p_salary_payer_address
  where  row_id = l_rec.row_id;
Line: 704

end update_pact;
Line: 736

  insert into pay_jp_isdf_assact_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    tax_type,
    transaction_status,
    finalized_date,
    finalized_by,
    user_comments,
    admin_comments,
    transfer_status,
    transfer_date,
    expiry_date)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_tax_type,
    p_transaction_status,
    fnd_date.date_to_canonical(p_finalized_date),
    fnd_number.number_to_canonical(p_finalized_by),
    p_user_comments,
    p_admin_comments,
    p_transfer_status,
    fnd_date.date_to_canonical(p_transfer_date),
    fnd_date.date_to_canonical(p_expiry_date));
Line: 780

procedure update_assact(
  p_action_information_id in number,
  p_object_version_number in out nocopy number,
  p_transaction_status    in varchar2,
  p_finalized_date        in date,
  p_finalized_by          in number,
  p_user_comments         in varchar2,
  p_admin_comments        in varchar2,
  p_transfer_status       in varchar2,
  p_transfer_date         in date,
  p_expiry_date           in date)
is
  l_rec  pay_jp_isdf_assact_v%rowtype;
Line: 793

  l_proc varchar2(80) := c_package||'update_assact';
Line: 808

  update pay_jp_isdf_assact_dml_v
  set    object_version_number = p_object_version_number,
         transaction_status    = p_transaction_status,
         finalized_date        = fnd_date.date_to_canonical(p_finalized_date),
         finalized_by          = fnd_number.number_to_canonical(p_finalized_by),
         user_comments         = p_user_comments,
         admin_comments        = p_admin_comments,
         transfer_status       = p_transfer_status,
         transfer_date         = fnd_date.date_to_canonical(p_transfer_date),
         expiry_date           = fnd_date.date_to_canonical(p_expiry_date)
  where  row_id = l_rec.row_id;
Line: 824

end update_assact;
Line: 854

  insert into pay_jp_isdf_emp_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    employee_number,
    last_name_kana,
    first_name_kana,
    last_name,
    first_name,
    postal_code,
    address)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_employee_number,
    p_last_name_kana,
    p_first_name_kana,
    p_last_name,
    p_first_name,
    p_postal_code,
    p_address);
Line: 894

procedure update_emp(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_postal_code                 in varchar2,
  p_address                     in varchar2)
is
  l_rec  pay_jp_isdf_emp_v%rowtype;
Line: 901

  l_proc varchar2(80) := c_package||'update_emp';
Line: 916

  update pay_jp_isdf_emp_dml_v
  set    object_version_number = p_object_version_number,
         postal_code           = p_postal_code,
         address               = p_address
  where  row_id = l_rec.row_id;
Line: 926

end update_emp;
Line: 939

  p_ins_datetrack_update_mode    in varchar2,
  p_ins_element_entry_id         in number,
  p_ins_ee_object_version_number in number,
  p_life_gen_ins_prem            in number,
  p_life_gen_ins_prem_o          in number,
  p_life_pens_ins_prem           in number,
  p_life_pens_ins_prem_o         in number,
  p_nonlife_long_ins_prem        in number,
  p_nonlife_long_ins_prem_o      in number,
  p_nonlife_short_ins_prem       in number default null,
  p_nonlife_short_ins_prem_o     in number default null,
  p_earthquake_ins_prem          in number,
  p_earthquake_ins_prem_o        in number,
  p_is_datetrack_update_mode     in varchar2,
  p_is_element_entry_id          in number,
  p_is_ee_object_version_number  in number,
  p_social_ins_prem              in number,
  p_social_ins_prem_o            in number,
  p_mutual_aid_prem              in number,
  p_mutual_aid_prem_o            in number,
  p_spouse_income                in number,
  p_spouse_income_o              in number,
  p_national_pens_ins_prem       in number,
  p_national_pens_ins_prem_o     in number,
  p_life_gen_ins_prem_new        in number,
  p_life_pens_ins_prem_new       in number,
  p_care_med_ins_prem_new        in number,
  p_object_version_number        out nocopy number)
is
  l_proc varchar2(80) := c_package||'create_ins_entry';
Line: 977

  insert into pay_jp_isdf_entry_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    ins_datetrack_update_mode,
    ins_element_entry_id,
    ins_ee_object_version_number,
    life_gen_ins_prem,
    life_gen_ins_prem_o,
    life_pens_ins_prem,
    life_pens_ins_prem_o,
    nonlife_long_ins_prem,
    nonlife_long_ins_prem_o,
    nonlife_short_ins_prem,
    nonlife_short_ins_prem_o,
    earthquake_ins_prem,
    earthquake_ins_prem_o,
    is_datetrack_update_mode,
    is_element_entry_id,
    is_ee_object_version_number,
    social_ins_prem,
    social_ins_prem_o,
    mutual_aid_prem,
    mutual_aid_prem_o,
    spouse_income,
    spouse_income_o,
    national_pens_ins_prem,
    national_pens_ins_prem_o,
    life_gen_ins_prem_new,
    life_pens_ins_prem_new,
    care_med_ins_prem_new )
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    p_ins_datetrack_update_mode,
    fnd_number.number_to_canonical(p_ins_element_entry_id),
    fnd_number.number_to_canonical(p_ins_ee_object_version_number),
    fnd_number.number_to_canonical(p_life_gen_ins_prem),
    fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
    fnd_number.number_to_canonical(p_life_pens_ins_prem),
    fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
    fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
    fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
    fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
    fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
    fnd_number.number_to_canonical(p_earthquake_ins_prem),
    fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
    p_is_datetrack_update_mode,
    fnd_number.number_to_canonical(p_is_element_entry_id),
    fnd_number.number_to_canonical(p_is_ee_object_version_number),
    fnd_number.number_to_canonical(p_social_ins_prem),
    fnd_number.number_to_canonical(p_social_ins_prem_o),
    fnd_number.number_to_canonical(p_mutual_aid_prem),
    fnd_number.number_to_canonical(p_mutual_aid_prem_o),
    fnd_number.number_to_canonical(p_spouse_income),
    fnd_number.number_to_canonical(p_spouse_income_o),
    fnd_number.number_to_canonical(p_national_pens_ins_prem),
    fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
    fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
    fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
    fnd_number.number_to_canonical(p_care_med_ins_prem_new));
Line: 1059

procedure update_entry(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_life_gen_ins_prem           in number,
  p_life_gen_ins_prem_o         in number,
  p_life_pens_ins_prem          in number,
  p_life_pens_ins_prem_o        in number,
  p_nonlife_long_ins_prem       in number,
  p_nonlife_long_ins_prem_o     in number,
  p_nonlife_short_ins_prem      in number default null,
  p_nonlife_short_ins_prem_o    in number default null,
  p_earthquake_ins_prem         in number,
  p_earthquake_ins_prem_o       in number,
  p_social_ins_prem             in number,
  p_social_ins_prem_o           in number,
  p_mutual_aid_prem             in number,
  p_mutual_aid_prem_o           in number,
  p_spouse_income               in number,
  p_spouse_income_o             in number,
  p_national_pens_ins_prem      in number,
  p_national_pens_ins_prem_o    in number,
  p_life_gen_ins_prem_new        in number,
  p_life_pens_ins_prem_new       in number,
  p_care_med_ins_prem_new        in number)
is
  l_rec  pay_jp_isdf_entry_v%rowtype;
Line: 1086

  l_proc varchar2(80) := c_package||'update_entry';
Line: 1101

  update pay_jp_isdf_entry_dml_v
  set    object_version_number    = p_object_version_number,
         status                   = p_status,
         life_gen_ins_prem        = fnd_number.number_to_canonical(p_life_gen_ins_prem),
         life_gen_ins_prem_o      = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
         life_pens_ins_prem       = fnd_number.number_to_canonical(p_life_pens_ins_prem),
         life_pens_ins_prem_o     = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
         nonlife_long_ins_prem    = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
         nonlife_long_ins_prem_o  = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
         nonlife_short_ins_prem   = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
         nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
         earthquake_ins_prem      = fnd_number.number_to_canonical(p_earthquake_ins_prem),
         earthquake_ins_prem_o    = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
         social_ins_prem          = fnd_number.number_to_canonical(p_social_ins_prem),
         social_ins_prem_o        = fnd_number.number_to_canonical(p_social_ins_prem_o),
         mutual_aid_prem          = fnd_number.number_to_canonical(p_mutual_aid_prem),
         mutual_aid_prem_o        = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
         spouse_income            = fnd_number.number_to_canonical(p_spouse_income),
         spouse_income_o          = fnd_number.number_to_canonical(p_spouse_income_o),
         national_pens_ins_prem   = fnd_number.number_to_canonical(p_national_pens_ins_prem),
         national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
         life_gen_ins_prem_new    = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
         life_pens_ins_prem_new   = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
         care_med_ins_prem_new    = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
  where  row_id = l_rec.row_id;
Line: 1131

end update_entry;
Line: 1184

  insert into pay_jp_isdf_calc_dct_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    life_gen_ins_prem,
    life_pens_ins_prem,
    life_gen_ins_calc_prem,
    life_pens_ins_calc_prem,
    life_ins_deduction,
    nonlife_long_ins_prem,
    nonlife_short_ins_prem,
    earthquake_ins_prem,
    nonlife_long_ins_calc_prem,
    nonlife_short_ins_calc_prem,
    earthquake_ins_calc_prem,
    nonlife_ins_deduction,
    social_ins_deduction,
    mutual_aid_deduction,
    sp_earned_income_calc,
    sp_business_income_calc,
    sp_miscellaneous_income_calc,
    sp_dividend_income_calc,
    sp_real_estate_income_calc,
    sp_retirement_income_calc,
    sp_other_income_calc,
    sp_income_calc,
    spouse_income,
    spouse_deduction,
    national_pens_ins_prem,
    life_gen_new_ins_prem,
    life_pens_new_ins_prem,
    life_gen_new_ins_calc_prem,
    life_pens_new_ins_calc_prem)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_life_gen_ins_prem),
    fnd_number.number_to_canonical(p_life_pens_ins_prem),
    fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
    fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
    fnd_number.number_to_canonical(p_life_ins_deduction),
    fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
    fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
    fnd_number.number_to_canonical(p_earthquake_ins_prem),
    fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
    fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
    fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
    fnd_number.number_to_canonical(p_nonlife_ins_deduction),
    fnd_number.number_to_canonical(p_social_ins_deduction),
    fnd_number.number_to_canonical(p_mutual_aid_deduction),
    fnd_number.number_to_canonical(p_sp_earned_income_calc),
    fnd_number.number_to_canonical(p_sp_business_income_calc),
    fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
    fnd_number.number_to_canonical(p_sp_dividend_income_calc),
    fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
    fnd_number.number_to_canonical(p_sp_retirement_income_calc),
    fnd_number.number_to_canonical(p_sp_other_income_calc),
    fnd_number.number_to_canonical(p_sp_income_calc),
    fnd_number.number_to_canonical(p_spouse_income),
    fnd_number.number_to_canonical(p_spouse_deduction),
    fnd_number.number_to_canonical(p_national_pens_ins_prem),
    fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
    fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
    fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
    fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
Line: 1270

procedure update_calc_dct(
  p_action_information_id        in number,
  p_object_version_number        in out nocopy number,
  p_status                       in varchar2,
  p_life_gen_ins_prem            in number,
  p_life_pens_ins_prem           in number,
  p_life_gen_ins_calc_prem       in number,
  p_life_pens_ins_calc_prem      in number,
  p_life_ins_deduction           in number,
  p_nonlife_long_ins_prem        in number,
  p_nonlife_short_ins_prem       in number default null,
  p_earthquake_ins_prem          in number,
  p_nonlife_long_ins_calc_prem   in number,
  p_nonlife_short_ins_calc_prem  in number default null,
  p_earthquake_ins_calc_prem     in number,
  p_nonlife_ins_deduction        in number,
  p_national_pens_ins_prem       in number,
  p_social_ins_deduction         in number,
  p_mutual_aid_deduction         in number,
  p_sp_earned_income_calc        in number,
  p_sp_business_income_calc      in number,
  p_sp_miscellaneous_income_calc in number,
  p_sp_dividend_income_calc      in number,
  p_sp_real_estate_income_calc   in number,
  p_sp_retirement_income_calc    in number,
  p_sp_other_income_calc         in number,
  p_sp_income_calc               in number,
  p_spouse_income                in number,
  p_spouse_deduction             in number,
  p_life_gen_new_ins_prem        in number,
  p_life_pens_new_ins_prem       in number,
  p_life_gen_new_ins_calc_prem   in number,
  p_life_pens_new_ins_calc_prem  in number)
is
  l_rec  pay_jp_isdf_calc_dct_v%rowtype;
Line: 1305

  l_proc varchar2(80) := c_package||'update_calc_dct';
Line: 1320

  update pay_jp_isdf_calc_dct_dml_v
  set    object_version_number        = p_object_version_number,
         status                       = p_status,
         life_gen_ins_prem            = fnd_number.number_to_canonical(p_life_gen_ins_prem),
         life_pens_ins_prem           = fnd_number.number_to_canonical(p_life_pens_ins_prem),
         life_gen_ins_calc_prem       = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
         life_pens_ins_calc_prem      = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
         life_ins_deduction           = fnd_number.number_to_canonical(p_life_ins_deduction),
         nonlife_long_ins_prem        = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
         nonlife_short_ins_prem       = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
         earthquake_ins_prem          = fnd_number.number_to_canonical(p_earthquake_ins_prem),
         nonlife_long_ins_calc_prem   = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
         nonlife_short_ins_calc_prem  = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
         earthquake_ins_calc_prem     = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
         nonlife_ins_deduction        = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
         social_ins_deduction         = fnd_number.number_to_canonical(p_social_ins_deduction),
         mutual_aid_deduction         = fnd_number.number_to_canonical(p_mutual_aid_deduction),
         sp_earned_income_calc        = fnd_number.number_to_canonical(p_sp_earned_income_calc),
         sp_business_income_calc      = fnd_number.number_to_canonical(p_sp_business_income_calc),
         sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
         sp_dividend_income_calc      = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
         sp_real_estate_income_calc   = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
         sp_retirement_income_calc    = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
         sp_other_income_calc         = fnd_number.number_to_canonical(p_sp_other_income_calc),
         sp_income_calc               = fnd_number.number_to_canonical(p_sp_income_calc),
         spouse_income                = fnd_number.number_to_canonical(p_spouse_income),
         spouse_deduction             = fnd_number.number_to_canonical(p_spouse_deduction),
         national_pens_ins_prem       = fnd_number.number_to_canonical(p_national_pens_ins_prem),
         life_gen_new_ins_prem        = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
         life_pens_new_ins_prem       = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
         life_gen_new_ins_calc_prem   = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
         life_pens_new_ins_calc_prem  = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
  where  row_id = l_rec.row_id;
Line: 1358

end update_calc_dct;
Line: 1384

  insert into pay_jp_isdf_calc_dct_dml_v2(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    care_med_new_ins_prem,
    care_med_new_ins_calc_prem)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_care_med_new_ins_prem),
    fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem));
Line: 1416

procedure update_calc_dct2(
  p_action_information_id        in number,
  p_object_version_number        in out nocopy number,
  p_status                       in varchar2,
  p_care_med_new_ins_prem        in number,
  p_care_med_new_ins_calc_prem   in number)
is
  l_rec  pay_jp_isdf_calc_dct_v2%rowtype;
Line: 1424

  l_proc varchar2(80) := c_package||'update_calc_dct2';
Line: 1439

  update pay_jp_isdf_calc_dct_dml_v2
  set    object_version_number        = p_object_version_number,
         status                       = p_status,
         care_med_new_ins_prem        = fnd_number.number_to_canonical(p_care_med_new_ins_prem),
         care_med_new_ins_calc_prem   = fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem)
  where  row_id = l_rec.row_id;
Line: 1450

end update_calc_dct2;
Line: 1486

  insert into pay_jp_isdf_life_gen_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    assignment_extra_info_id,
    aei_object_version_number,
    gen_ins_class,
    gen_ins_company_code,
    ins_company_name,
    ins_type,
    ins_period,
    contractor_name,
    beneficiary_name,
    beneficiary_relship,
    annual_prem,
    gen_ins_class_old_new)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_assignment_extra_info_id),
    fnd_number.number_to_canonical(p_aei_object_version_number),
    p_gen_ins_class,
    p_gen_ins_company_code,
    p_ins_company_name,
    p_ins_type,
    p_ins_period,
    p_contractor_name,
    p_beneficiary_name,
    p_beneficiary_relship,
    fnd_number.number_to_canonical(p_annual_prem),
    p_gen_ins_old_new);
Line: 1538

procedure update_life_gen(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_ins_company_name            in varchar2,
  p_ins_type                    in varchar2,
  p_ins_period                  in varchar2,
  p_contractor_name             in varchar2,
  p_beneficiary_name            in varchar2,
  p_beneficiary_relship         in varchar2,
  p_annual_prem                 in number,
  p_ins_old_new                 in varchar2)
is
  l_rec  pay_jp_isdf_life_gen_v%rowtype;
Line: 1552

  l_proc varchar2(80) := c_package||'update_life_gen';
Line: 1567

  update pay_jp_isdf_life_gen_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         ins_company_name            = p_ins_company_name,
         ins_type                    = p_ins_type,
         ins_period                  = p_ins_period,
         contractor_name             = p_contractor_name,
         beneficiary_name            = p_beneficiary_name,
         beneficiary_relship         = p_beneficiary_relship,
         annual_prem                 = fnd_number.number_to_canonical(p_annual_prem),
         gen_ins_class_old_new       = p_ins_old_new
  where  row_id = l_rec.row_id;
Line: 1584

end update_life_gen;
Line: 1589

procedure delete_life_gen(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_life_gen_v%rowtype;
Line: 1594

  l_proc varchar2(80) := c_package||'delete_life_gen';
Line: 1610

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 1616

    update pay_jp_isdf_life_gen_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 1627

end delete_life_gen;
Line: 1663

  insert into pay_jp_isdf_care_med_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    assignment_extra_info_id,
    aei_object_version_number,
    care_ins_class,
    care_ins_company_code,
    ins_company_name,
    ins_type,
    ins_period,
    contractor_name,
    beneficiary_name,
    beneficiary_relship,
    annual_prem,
    care_ins_class_old_new)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_assignment_extra_info_id),
    fnd_number.number_to_canonical(p_aei_object_version_number),
    p_care_ins_class,
    p_care_ins_company_code,
    p_ins_company_name,
    p_ins_type,
    p_ins_period,
    p_contractor_name,
    p_beneficiary_name,
    p_beneficiary_relship,
    fnd_number.number_to_canonical(p_annual_prem),
    p_care_ins_old_new);
Line: 1715

procedure update_care_med(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_ins_company_name            in varchar2,
  p_ins_type                    in varchar2,
  p_ins_period                  in varchar2,
  p_contractor_name             in varchar2,
  p_beneficiary_name            in varchar2,
  p_beneficiary_relship         in varchar2,
  p_annual_prem                 in number,
  p_ins_old_new                 in varchar2)
is
  l_rec  pay_jp_isdf_care_med_v%rowtype;
Line: 1729

  l_proc varchar2(80) := c_package||'update_care_med';
Line: 1744

  update pay_jp_isdf_care_med_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         ins_company_name            = p_ins_company_name,
         ins_type                    = p_ins_type,
         ins_period                  = p_ins_period,
         contractor_name             = p_contractor_name,
         beneficiary_name            = p_beneficiary_name,
         beneficiary_relship         = p_beneficiary_relship,
         annual_prem                 = fnd_number.number_to_canonical(p_annual_prem),
         care_ins_class_old_new      = p_ins_old_new
  where  row_id = l_rec.row_id;
Line: 1761

end update_care_med;
Line: 1766

procedure delete_care_med(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_care_med_v%rowtype;
Line: 1771

  l_proc varchar2(80) := c_package||'delete_care_med';
Line: 1787

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 1793

    update pay_jp_isdf_care_med_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 1804

end delete_care_med;
Line: 1841

  insert into pay_jp_isdf_life_pens_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    assignment_extra_info_id,
    aei_object_version_number,
    pens_ins_class,
    pens_ins_company_code,
    ins_company_name,
    ins_type,
    ins_period_start_date,
    ins_period,
    contractor_name,
    beneficiary_name,
    beneficiary_relship,
    annual_prem,
    pens_ins_class_old_new)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_assignment_extra_info_id),
    fnd_number.number_to_canonical(p_aei_object_version_number),
    p_pens_ins_class,
    p_pens_ins_company_code,
    p_ins_company_name,
    p_ins_type,
    fnd_date.date_to_canonical(p_ins_period_start_date),
    p_ins_period,
    p_contractor_name,
    p_beneficiary_name,
    p_beneficiary_relship,
    fnd_number.number_to_canonical(p_annual_prem),
    p_pens_ins_old_new);
Line: 1895

procedure update_life_pens(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_ins_company_name            in varchar2,
  p_ins_type                    in varchar2,
  p_ins_period_start_date       in date,
  p_ins_period                  in varchar2,
  p_contractor_name             in varchar2,
  p_beneficiary_name            in varchar2,
  p_beneficiary_relship         in varchar2,
  p_annual_prem                 in number,
  p_ins_old_new                 in varchar2)
is
  l_rec  pay_jp_isdf_life_pens_v%rowtype;
Line: 1910

  l_proc varchar2(80) := c_package||'update_life_pens';
Line: 1925

  update pay_jp_isdf_life_pens_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         ins_company_name            = p_ins_company_name,
         ins_type                    = p_ins_type,
         ins_period_start_date       = fnd_date.date_to_canonical(p_ins_period_start_date),
         ins_period                  = p_ins_period,
         contractor_name             = p_contractor_name,
         beneficiary_name            = p_beneficiary_name,
         beneficiary_relship         = p_beneficiary_relship,
         annual_prem                 = fnd_number.number_to_canonical(p_annual_prem),
         pens_ins_class_old_new      = p_ins_old_new
  where  row_id = l_rec.row_id;
Line: 1943

end update_life_pens;
Line: 1948

procedure delete_life_pens(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_life_pens_v%rowtype;
Line: 1953

  l_proc varchar2(80) := c_package||'delete_life_pens';
Line: 1969

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 1975

    update pay_jp_isdf_life_pens_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 1986

end delete_life_pens;
Line: 2023

  insert into pay_jp_isdf_nonlife_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    assignment_extra_info_id,
    aei_object_version_number,
    nonlife_ins_class,
    nonlife_ins_term_type,
    nonlife_ins_company_code,
    ins_company_name,
    ins_type,
    ins_period,
    contractor_name,
    beneficiary_name,
    beneficiary_relship,
    maturity_repayment,
    annual_prem)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_assignment_extra_info_id),
    fnd_number.number_to_canonical(p_aei_object_version_number),
    p_nonlife_ins_class,
    p_nonlife_ins_term_type,
    p_nonlife_ins_company_code,
    p_ins_company_name,
    p_ins_type,
    p_ins_period,
    p_contractor_name,
    p_beneficiary_name,
    p_beneficiary_relship,
    p_maturity_repayment,
    fnd_number.number_to_canonical(p_annual_prem));
Line: 2077

procedure update_nonlife(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_nonlife_ins_term_type       in varchar2,
  p_ins_company_name            in varchar2,
  p_ins_type                    in varchar2,
  p_ins_period                  in varchar2,
  p_contractor_name             in varchar2,
  p_beneficiary_name            in varchar2,
  p_beneficiary_relship         in varchar2,
  p_maturity_repayment          in varchar2 default null,
  p_annual_prem                 in number)
is
  l_rec  pay_jp_isdf_nonlife_v%rowtype;
Line: 2092

  l_proc varchar2(80) := c_package||'update_nonlife';
Line: 2107

  update pay_jp_isdf_nonlife_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         ins_company_name            = p_ins_company_name,
         ins_type                    = p_ins_type,
         ins_period                  = p_ins_period,
         contractor_name             = p_contractor_name,
         beneficiary_name            = p_beneficiary_name,
         beneficiary_relship         = p_beneficiary_relship,
         maturity_repayment          = p_maturity_repayment,
         annual_prem                 = fnd_number.number_to_canonical(p_annual_prem)
  where  row_id = l_rec.row_id;
Line: 2124

end update_nonlife;
Line: 2129

procedure delete_nonlife(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_nonlife_v%rowtype;
Line: 2134

  l_proc varchar2(80) := c_package||'delete_nonlife';
Line: 2150

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 2156

    update pay_jp_isdf_nonlife_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 2167

end delete_nonlife;
Line: 2197

  insert into pay_jp_isdf_social_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    ins_type,
    ins_payee_name,
    debtor_name,
    beneficiary_relship,
    annual_prem,
    national_pens_flag)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    p_ins_type,
    p_ins_payee_name,
    p_debtor_name,
    p_beneficiary_relship,
    fnd_number.number_to_canonical(p_annual_prem),
    p_national_pens_flag);
Line: 2237

procedure update_social(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_ins_type                    in varchar2,
  p_ins_payee_name              in varchar2,
  p_debtor_name                 in varchar2,
  p_beneficiary_relship         in varchar2,
  p_annual_prem                 in number,
  p_national_pens_flag          in varchar2)
is
  l_rec  pay_jp_isdf_social_v%rowtype;
Line: 2249

  l_proc varchar2(80) := c_package||'update_social';
Line: 2264

  update pay_jp_isdf_social_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         ins_type                    = p_ins_type,
         ins_payee_name              = p_ins_payee_name,
         debtor_name                 = p_debtor_name,
         beneficiary_relship         = p_beneficiary_relship,
         annual_prem                 = fnd_number.number_to_canonical(p_annual_prem),
         national_pens_flag          = p_national_pens_flag
  where  row_id = l_rec.row_id;
Line: 2279

end update_social;
Line: 2284

procedure delete_social(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_social_v%rowtype;
Line: 2289

  l_proc varchar2(80) := c_package||'delete_social';
Line: 2305

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 2311

    update pay_jp_isdf_social_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 2322

end delete_social;
Line: 2349

  insert into pay_jp_isdf_mutual_aid_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    enterprise_contract_prem,
    pension_prem,
    disable_sup_contract_prem)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_enterprise_contract_prem),
    fnd_number.number_to_canonical(p_pension_prem),
    fnd_number.number_to_canonical(p_disable_sup_contract_prem));
Line: 2383

procedure update_mutual_aid(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_enterprise_contract_prem    in number,
  p_pension_prem                in number,
  p_disable_sup_contract_prem   in number)
is
  l_rec  pay_jp_isdf_mutual_aid_v%rowtype;
Line: 2392

  l_proc varchar2(80) := c_package||'update_mutual_aid';
Line: 2407

  update pay_jp_isdf_mutual_aid_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         enterprise_contract_prem    = fnd_number.number_to_canonical(p_enterprise_contract_prem),
         pension_prem                = fnd_number.number_to_canonical(p_pension_prem),
         disable_sup_contract_prem   = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
  where  row_id = l_rec.row_id;
Line: 2419

end update_mutual_aid;
Line: 2424

procedure delete_mutual_aid(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_mutual_aid_v%rowtype;
Line: 2429

  l_proc varchar2(80) := c_package||'delete_mutual_aid';
Line: 2445

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 2451

    update pay_jp_isdf_mutual_aid_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 2462

end delete_mutual_aid;
Line: 2499

  insert into pay_jp_isdf_spouse_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    full_name_kana,
    --last_name_kana,
    --first_name_kana,
    full_name,
    --last_name,
    --first_name,
    postal_code,
    address,
    emp_income,
    spouse_type,
    widow_type,
    spouse_dct_exclude,
    spouse_income_entry)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    p_full_name_kana,
    --p_last_name_kana,
    --p_first_name_kana,
    p_full_name,
    --p_last_name,
    --p_first_name,
    p_postal_code,
    p_address,
    fnd_number.number_to_canonical(p_emp_income),
    p_spouse_type,
    p_widow_type,
    p_spouse_dct_exclude,
    fnd_number.number_to_canonical(p_spouse_income_entry));
Line: 2553

procedure update_spouse(
  p_action_information_id       in number,
  p_object_version_number       in out nocopy number,
  p_status                      in varchar2,
  p_full_name_kana              in varchar2,
  --p_last_name_kana              in varchar2,
  --p_first_name_kana             in varchar2,
  p_full_name                   in varchar2,
  --p_last_name                   in varchar2,
  --p_first_name                  in varchar2,
  p_postal_code                 in varchar2,
  p_address                     in varchar2,
  p_emp_income                  in number,
  p_spouse_type                 in varchar2,
  p_widow_type                  in varchar2,
  p_spouse_dct_exclude          in varchar2,
  p_spouse_income_entry         in number)
is
  l_rec  pay_jp_isdf_spouse_v%rowtype;
Line: 2572

  l_proc varchar2(80) := c_package||'update_spouse';
Line: 2587

  update pay_jp_isdf_spouse_dml_v
  set    object_version_number       = p_object_version_number,
         status                      = p_status,
         full_name_kana              = p_full_name_kana,
         --last_name_kana              = p_last_name_kana,
         --first_name_kana             = p_first_name_kana,
         full_name                   = p_full_name,
         --last_name                   = p_last_name,
         --first_name                  = p_first_name,
         postal_code                 = p_postal_code,
         address                     = p_address,
         emp_income                  = fnd_number.number_to_canonical(p_emp_income),
         spouse_type                 = p_spouse_type,
         widow_type                  = p_widow_type,
         spouse_dct_exclude          = p_spouse_dct_exclude,
         spouse_income_entry         = fnd_number.number_to_canonical(p_spouse_income_entry)
  where  row_id = l_rec.row_id;
Line: 2609

end update_spouse;
Line: 2614

procedure delete_spouse(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_spouse_v%rowtype;
Line: 2619

  l_proc varchar2(80) := c_package||'delete_spouse';
Line: 2635

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 2641

    update pay_jp_isdf_spouse_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 2652

end delete_spouse;
Line: 2693

  insert into pay_jp_isdf_spouse_inc_dml_v(
    action_information_id,
    object_version_number,
    assignment_action_id,
    action_context_type,
    assignment_id,
    effective_date,
    action_information_category,
    status,
    sp_earned_income,
    sp_earned_income_exp,
    sp_business_income,
    sp_business_income_exp,
    sp_miscellaneous_income,
    sp_miscellaneous_income_exp,
    sp_dividend_income,
    sp_dividend_income_exp,
    sp_real_estate_income,
    sp_real_estate_income_exp,
    sp_retirement_income,
    sp_retirement_income_exp,
    sp_other_income,
    sp_other_income_exp,
    sp_other_income_exp_dct,
    sp_other_income_exp_temp,
    sp_other_income_exp_temp_exp)
  values(
    p_action_information_id,
    p_object_version_number,
    p_assignment_action_id,
    p_action_context_type,
    p_assignment_id,
    p_effective_date,
    p_action_information_category,
    p_status,
    fnd_number.number_to_canonical(p_sp_earned_income),
    fnd_number.number_to_canonical(p_sp_earned_income_exp),
    fnd_number.number_to_canonical(p_sp_business_income),
    fnd_number.number_to_canonical(p_sp_business_income_exp),
    fnd_number.number_to_canonical(p_sp_miscellaneous_income),
    fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
    fnd_number.number_to_canonical(p_sp_dividend_income),
    fnd_number.number_to_canonical(p_sp_dividend_income_exp),
    fnd_number.number_to_canonical(p_sp_real_estate_income),
    fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
    fnd_number.number_to_canonical(p_sp_retirement_income),
    fnd_number.number_to_canonical(p_sp_retirement_income_exp),
    fnd_number.number_to_canonical(p_sp_other_income),
    fnd_number.number_to_canonical(p_sp_other_income_exp),
    fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
    fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
    fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
Line: 2755

procedure update_spouse_inc(
  p_action_information_id        in number,
  p_object_version_number        in out nocopy number,
  p_status                       in varchar2,
  p_sp_earned_income             in number,
  p_sp_earned_income_exp         in number,
  p_sp_business_income           in number,
  p_sp_business_income_exp       in number,
  p_sp_miscellaneous_income      in number,
  p_sp_miscellaneous_income_exp  in number,
  p_sp_dividend_income           in number,
  p_sp_dividend_income_exp       in number,
  p_sp_real_estate_income        in number,
  p_sp_real_estate_income_exp    in number,
  p_sp_retirement_income         in number,
  p_sp_retirement_income_exp     in number,
  p_sp_other_income              in number,
  p_sp_other_income_exp          in number,
  p_sp_other_income_exp_dct      in number,
  p_sp_other_income_exp_temp     in number,
  p_sp_other_income_exp_temp_exp in number)
is
  l_rec  pay_jp_isdf_spouse_inc_v%rowtype;
Line: 2778

  l_proc varchar2(80) := c_package||'update_spouse_inc';
Line: 2793

  update pay_jp_isdf_spouse_inc_dml_v
  set    object_version_number        = p_object_version_number,
         status                       = p_status,
         sp_earned_income             = fnd_number.number_to_canonical(p_sp_earned_income),
         sp_earned_income_exp         = fnd_number.number_to_canonical(p_sp_earned_income_exp),
         sp_business_income           = fnd_number.number_to_canonical(p_sp_business_income),
         sp_business_income_exp       = fnd_number.number_to_canonical(p_sp_business_income_exp),
         sp_miscellaneous_income      = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
         sp_miscellaneous_income_exp  = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
         sp_dividend_income           = fnd_number.number_to_canonical(p_sp_dividend_income),
         sp_dividend_income_exp       = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
         sp_real_estate_income        = fnd_number.number_to_canonical(p_sp_real_estate_income),
         sp_real_estate_income_exp    = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
         sp_retirement_income         = fnd_number.number_to_canonical(p_sp_retirement_income),
         sp_retirement_income_exp     = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
         sp_other_income              = fnd_number.number_to_canonical(p_sp_other_income),
         sp_other_income_exp          = fnd_number.number_to_canonical(p_sp_other_income_exp),
         sp_other_income_exp_dct      = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
         sp_other_income_exp_temp     = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
         sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
  where  row_id = l_rec.row_id;
Line: 2819

end update_spouse_inc;
Line: 2824

procedure delete_spouse_inc(
  p_action_information_id   in number,
  p_object_version_number   in number)
is
  l_rec  pay_jp_isdf_spouse_inc_v%rowtype;
Line: 2829

  l_proc varchar2(80) := c_package||'delete_spouse_inc';
Line: 2845

    delete
    from  pay_action_information
    where rowid = l_rec.row_id;
Line: 2851

    update pay_jp_isdf_spouse_inc_dml_v
    set    object_version_number = l_rec.object_version_number + 1,
           status                = 'D'
    where  rowid = l_rec.row_id;
Line: 2862

end delete_spouse_inc;