1793: pjwa.itax_organization_id itx_org_id,
1794: pjwa.itax_category itx_type,
1795: pjwa.itax_yea_category itx_inc_flag,
1796: nvl(nvl(pap.prl_information1,g_bg_itax_dpnt_ref_type),'CTR_EE') dpnt_ref_type,
1797: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
1798: pp.person_id,
1799: pp.sex,
1800: pp.date_of_birth,
1801: pjwa.leaving_reason,
1928: pjwa.itax_organization_id itx_org_id,
1929: pjwa.itax_category itx_type,
1930: pjwa.itax_yea_category itx_inc_flag,
1931: nvl(nvl(pap.prl_information1,g_bg_itax_dpnt_ref_type),'CTR_EE') dpnt_ref_type,
1932: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
1933: pp.person_id,
1934: pp.sex,
1935: pp.date_of_birth,
1936: pjwa.leaving_reason,
6036: where ppa.payroll_action_id = :payroll_action_id
6037: and pp.business_group_id = ppa.business_group_id + 0
6038: and ppos.person_id = pp.person_id
6039: and ppos.business_group_id + 0 = pp.business_group_id
6040: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
6041: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
6042: order by
6043: ppos.person_id';
6044: --
6037: and pp.business_group_id = ppa.business_group_id + 0
6038: and ppos.person_id = pp.person_id
6039: and ppos.business_group_id + 0 = pp.business_group_id
6040: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
6041: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
6042: order by
6043: ppos.person_id';
6044: --
6045: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
6041: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
6042: order by
6043: ppos.person_id';
6044: --
6045: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
6046: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
6047: --
6048: if g_debug then
6049: hr_utility.set_location(l_proc,1000);
6042: order by
6043: ppos.person_id';
6044: --
6045: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
6046: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
6047: --
6048: if g_debug then
6049: hr_utility.set_location(l_proc,1000);
6050: end if;
12657: p_assignment_action_id => p_assignment_action_id,
12658: p_effective_date => g_effective_date,
12659: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12660: p_category => 'EFD',
12661: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12658: p_effective_date => g_effective_date,
12659: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12660: p_category => 'EFD',
12661: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12659: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12660: p_category => 'EFD',
12661: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12660: p_category => 'EFD',
12661: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12661: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12662: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12663: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12664: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12672: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
12665: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12672: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
12673: p_action_information_id => l_action_information_id,
12666: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12672: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
12673: p_action_information_id => l_action_information_id,
12674: p_object_version_number => l_object_version_number);
12667: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12672: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
12673: p_action_information_id => l_action_information_id,
12674: p_object_version_number => l_object_version_number);
12675: --
12668: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
12669: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
12670: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
12671: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
12672: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
12673: p_action_information_id => l_action_information_id,
12674: p_object_version_number => l_object_version_number);
12675: --
12676: if g_debug
12682: p_assignment_action_id => p_assignment_action_id,
12683: p_effective_date => g_effective_date,
12684: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12685: p_category => 'ERD',
12686: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12683: p_effective_date => g_effective_date,
12684: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12685: p_category => 'ERD',
12686: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12684: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12685: p_category => 'ERD',
12686: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12685: p_category => 'ERD',
12686: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12686: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12687: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12688: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12689: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12697: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
12690: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12697: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
12698: p_action_information_id => l_action_information_id,
12691: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12697: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
12698: p_action_information_id => l_action_information_id,
12699: p_object_version_number => l_object_version_number);
12692: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12697: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
12698: p_action_information_id => l_action_information_id,
12699: p_object_version_number => l_object_version_number);
12700: --
12693: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
12694: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
12695: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
12696: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
12697: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
12698: p_action_information_id => l_action_information_id,
12699: p_object_version_number => l_object_version_number);
12700: --
12701: if g_debug
13257: p_assignment_action_id => p_assignment_action_id,
13258: p_effective_date => g_effective_date,
13259: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13260: p_category => 'EFD',
13261: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13258: p_effective_date => g_effective_date,
13259: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13260: p_category => 'EFD',
13261: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13259: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13260: p_category => 'EFD',
13261: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13260: p_category => 'EFD',
13261: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13261: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13262: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13263: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13264: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13265: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13266: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13267: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13275: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
13268: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13275: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
13276: p_action_information_id => l_action_information_id,
13269: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13275: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
13276: p_action_information_id => l_action_information_id,
13277: p_object_version_number => l_object_version_number);
13270: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13275: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
13276: p_action_information_id => l_action_information_id,
13277: p_object_version_number => l_object_version_number);
13278: --
13271: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
13272: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
13273: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
13274: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
13275: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
13276: p_action_information_id => l_action_information_id,
13277: p_object_version_number => l_object_version_number);
13278: --
13279: if g_debug
13285: p_assignment_action_id => p_assignment_action_id,
13286: p_effective_date => g_effective_date,
13287: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13288: p_category => 'ERD',
13289: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13286: p_effective_date => g_effective_date,
13287: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13288: p_category => 'ERD',
13289: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13287: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13288: p_category => 'ERD',
13289: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13288: p_category => 'ERD',
13289: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13289: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13290: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13291: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13292: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13293: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13294: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13295: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13303: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
13296: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13303: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
13304: p_action_information_id => l_action_information_id,
13297: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13303: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
13304: p_action_information_id => l_action_information_id,
13305: p_object_version_number => l_object_version_number);
13298: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13303: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
13304: p_action_information_id => l_action_information_id,
13305: p_object_version_number => l_object_version_number);
13306: --
13299: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
13300: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
13301: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
13302: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
13303: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
13304: p_action_information_id => l_action_information_id,
13305: p_object_version_number => l_object_version_number);
13306: --
13307: if g_debug
14842: p_assignment_action_id => p_assignment_action_id,
14843: p_effective_date => g_effective_date,
14844: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14845: p_category => 'EFD',
14846: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14843: p_effective_date => g_effective_date,
14844: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14845: p_category => 'EFD',
14846: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14844: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14845: p_category => 'EFD',
14846: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14845: p_category => 'EFD',
14846: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14846: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14847: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14848: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14849: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14857: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
14850: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14857: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
14858: p_action_information_id => l_action_information_id,
14851: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14857: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
14858: p_action_information_id => l_action_information_id,
14859: p_object_version_number => l_object_version_number);
14852: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14857: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
14858: p_action_information_id => l_action_information_id,
14859: p_object_version_number => l_object_version_number);
14860: --
14853: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
14854: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
14855: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
14856: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
14857: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
14858: p_action_information_id => l_action_information_id,
14859: p_object_version_number => l_object_version_number);
14860: --
14861: if g_debug
14867: p_assignment_action_id => p_assignment_action_id,
14868: p_effective_date => g_effective_date,
14869: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14870: p_category => 'ERD',
14871: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14868: p_effective_date => g_effective_date,
14869: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14870: p_category => 'ERD',
14871: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14869: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14870: p_category => 'ERD',
14871: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14870: p_category => 'ERD',
14871: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14871: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14872: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14873: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14874: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14882: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
14875: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14882: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
14883: p_action_information_id => l_action_information_id,
14876: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14882: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
14883: p_action_information_id => l_action_information_id,
14884: p_object_version_number => l_object_version_number);
14877: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14882: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
14883: p_action_information_id => l_action_information_id,
14884: p_object_version_number => l_object_version_number);
14885: --
14878: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
14879: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
14880: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
14881: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
14882: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
14883: p_action_information_id => l_action_information_id,
14884: p_object_version_number => l_object_version_number);
14885: --
14886: if g_debug
15442: p_assignment_action_id => p_assignment_action_id,
15443: p_effective_date => g_effective_date,
15444: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15445: p_category => 'EFD',
15446: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15443: p_effective_date => g_effective_date,
15444: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15445: p_category => 'EFD',
15446: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15444: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15445: p_category => 'EFD',
15446: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15445: p_category => 'EFD',
15446: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15446: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15447: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15448: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15449: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15450: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15451: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15452: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15460: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
15453: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15460: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
15461: p_action_information_id => l_action_information_id,
15454: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15460: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
15461: p_action_information_id => l_action_information_id,
15462: p_object_version_number => l_object_version_number);
15455: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15460: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
15461: p_action_information_id => l_action_information_id,
15462: p_object_version_number => l_object_version_number);
15463: --
15456: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
15457: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
15458: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
15459: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
15460: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
15461: p_action_information_id => l_action_information_id,
15462: p_object_version_number => l_object_version_number);
15463: --
15464: if g_debug
15470: p_assignment_action_id => p_assignment_action_id,
15471: p_effective_date => g_effective_date,
15472: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15473: p_category => 'ERD',
15474: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15471: p_effective_date => g_effective_date,
15472: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15473: p_category => 'ERD',
15474: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15472: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15473: p_category => 'ERD',
15474: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15473: p_category => 'ERD',
15474: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15474: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15475: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15476: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15477: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15478: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15479: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15480: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15488: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
15481: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15488: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
15489: p_action_information_id => l_action_information_id,
15482: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15488: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
15489: p_action_information_id => l_action_information_id,
15490: p_object_version_number => l_object_version_number);
15483: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15488: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
15489: p_action_information_id => l_action_information_id,
15490: p_object_version_number => l_object_version_number);
15491: --
15484: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
15485: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
15486: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
15487: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
15488: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
15489: p_action_information_id => l_action_information_id,
15490: p_object_version_number => l_object_version_number);
15491: --
15492: if g_debug
17296: p_assignment_id => p_assignment_id,
17297: p_effective_date => g_effective_date,
17298: p_action_information_category => 'JP_ITWB_SAL_ACT',
17299: p_category => 'EFD',
17300: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17297: p_effective_date => g_effective_date,
17298: p_action_information_category => 'JP_ITWB_SAL_ACT',
17299: p_category => 'EFD',
17300: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17298: p_action_information_category => 'JP_ITWB_SAL_ACT',
17299: p_category => 'EFD',
17300: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17299: p_category => 'EFD',
17300: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17300: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17301: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17302: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17303: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17311: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
17304: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_efd),
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17311: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
17312: p_object_version_number => l_object_version_number);
17305: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_efd),
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17311: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
17312: p_object_version_number => l_object_version_number);
17313: --
17306: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_efd),
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17311: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
17312: p_object_version_number => l_object_version_number);
17313: --
17314: if g_debug
17307: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_efd),
17308: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_efd),
17309: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_efd),
17310: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_efd),
17311: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_efd),
17312: p_object_version_number => l_object_version_number);
17313: --
17314: if g_debug
17315: and g_detail_debug = 'Y' then
17323: p_assignment_id => p_assignment_id,
17324: p_effective_date => g_effective_date,
17325: p_action_information_category => 'JP_ITWB_SAL_ACT',
17326: p_category => 'ERD',
17327: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17324: p_effective_date => g_effective_date,
17325: p_action_information_category => 'JP_ITWB_SAL_ACT',
17326: p_category => 'ERD',
17327: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17325: p_action_information_category => 'JP_ITWB_SAL_ACT',
17326: p_category => 'ERD',
17327: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17326: p_category => 'ERD',
17327: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17327: p_col_mth1 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth1,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17328: p_col_mth2 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth2,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17329: p_col_mth3 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth3,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17330: p_col_mth4 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth4,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17338: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
17331: p_col_mth5 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth5,0)).sal_act_erd),
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17338: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
17339: p_object_version_number => l_object_version_number);
17332: p_col_mth6 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth6,0)).sal_act_erd),
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17338: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
17339: p_object_version_number => l_object_version_number);
17340: --
17333: p_col_mth7 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth7,0)).sal_act_erd),
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17338: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
17339: p_object_version_number => l_object_version_number);
17340: --
17341: if g_debug
17334: p_col_mth8 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth8,0)).sal_act_erd),
17335: p_col_mth9 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth9,0)).sal_act_erd),
17336: p_col_mth10 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth10,0)).sal_act_erd),
17337: p_col_mth11 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth11,0)).sal_act_erd),
17338: p_col_mth12 => fnd_date.date_to_canonical(g_data_sal_tbl(nvl(g_body_tbl(p_assignment_action_id).sal_act_act_mth12,0)).sal_act_erd),
17339: p_object_version_number => l_object_version_number);
17340: --
17341: if g_debug
17342: and g_detail_debug = 'Y' then
17942: p_assignment_id => p_assignment_id,
17943: p_effective_date => g_effective_date,
17944: p_action_information_category => 'JP_ITWB_BON_ACT',
17945: p_category => 'EFD',
17946: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17943: p_effective_date => g_effective_date,
17944: p_action_information_category => 'JP_ITWB_BON_ACT',
17945: p_category => 'EFD',
17946: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17944: p_action_information_category => 'JP_ITWB_BON_ACT',
17945: p_category => 'EFD',
17946: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17945: p_category => 'EFD',
17946: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17946: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17947: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17948: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17949: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17950: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17951: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17952: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17960: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
17953: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_efd),
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17960: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
17961: p_object_version_number => l_object_version_number);
17954: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_efd),
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17960: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
17961: p_object_version_number => l_object_version_number);
17962: --
17955: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_efd),
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17960: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
17961: p_object_version_number => l_object_version_number);
17962: --
17963: if g_debug
17956: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_efd),
17957: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_efd),
17958: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_efd),
17959: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_efd),
17960: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_efd),
17961: p_object_version_number => l_object_version_number);
17962: --
17963: if g_debug
17964: and g_detail_debug = 'Y' then
17972: p_assignment_id => p_assignment_id,
17973: p_effective_date => g_effective_date,
17974: p_action_information_category => 'JP_ITWB_BON_ACT',
17975: p_category => 'ERD',
17976: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17973: p_effective_date => g_effective_date,
17974: p_action_information_category => 'JP_ITWB_BON_ACT',
17975: p_category => 'ERD',
17976: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17974: p_action_information_category => 'JP_ITWB_BON_ACT',
17975: p_category => 'ERD',
17976: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17975: p_category => 'ERD',
17976: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17976: p_col_cnt1 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt1,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17977: p_col_cnt2 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt2,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17978: p_col_cnt3 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt3,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17979: p_col_cnt4 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt4,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17980: p_col_cnt5 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt5,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17981: p_col_cnt6 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt6,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17982: p_col_cnt7 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt7,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17990: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
17983: p_col_cnt8 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt8,0)).bon_act_erd),
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17990: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
17991: p_object_version_number => l_object_version_number);
17984: p_col_cnt9 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt9,0)).bon_act_erd),
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17990: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
17991: p_object_version_number => l_object_version_number);
17992: --
17985: p_col_cnt10 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt10,0)).bon_act_erd),
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17990: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
17991: p_object_version_number => l_object_version_number);
17992: --
17993: if g_debug
17986: p_col_cnt11 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt11,0)).bon_act_erd),
17987: p_col_cnt12 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt12,0)).bon_act_erd),
17988: p_col_cnt13 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt13,0)).bon_act_erd),
17989: p_col_cnt14 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt14,0)).bon_act_erd),
17990: p_col_cnt15 => fnd_date.date_to_canonical(g_data_bon_tbl(nvl(g_body_tbl(p_assignment_action_id).bon_act_act_cnt15,0)).bon_act_erd),
17991: p_object_version_number => l_object_version_number);
17992: --
17993: if g_debug
17994: and g_detail_debug = 'Y' then