APPS.PAY_SE_SLSA_ARCHIVE dependencies on FND_NUMBER

Line 472: SELECT sum (fnd_number.canonical_to_number (result_value))

468: p_report_start_date DATE,
469: p_report_end_date DATE
470:
471: ) IS
472: SELECT sum (fnd_number.canonical_to_number (result_value))
473: FROM pay_run_result_values prrv
474: WHERE input_value_id = p_input_value_id
475: AND run_result_id IN (SELECT prr.run_result_id
476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,

Line 632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),

628: p_action_information2 => l_curr_prev_std_hour,
629: p_action_information3 => p_legal_employer_id,
630: p_action_information4 => l_legal_employer_details.legal_employer_name,
631: p_action_information5 => l_legal_employer_details.org_number,
632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),
633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),

Line 633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),

629: p_action_information3 => p_legal_employer_id,
630: p_action_information4 => l_legal_employer_details.legal_employer_name,
631: p_action_information5 => l_legal_employer_details.org_number,
632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),
633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),
637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)

Line 634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),

630: p_action_information4 => l_legal_employer_details.legal_employer_name,
631: p_action_information5 => l_legal_employer_details.org_number,
632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),
633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),
637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)
638: );

Line 635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),

631: p_action_information5 => l_legal_employer_details.org_number,
632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),
633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),
637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)
638: );
639: /* Get the Element Type Id for the given element Name */

Line 861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),

857: p_action_information3 => p_legal_employer_id,
858: p_action_information4 => l_legal_employer_details.legal_employer_name,
859: p_action_information5 => l_legal_employer_details.org_number,
860: /* Archive the no of employees agewise in each gender group */
861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),
862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),

Line 862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),

858: p_action_information4 => l_legal_employer_details.legal_employer_name,
859: p_action_information5 => l_legal_employer_details.org_number,
860: /* Archive the no of employees agewise in each gender group */
861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),
862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),

Line 863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),

859: p_action_information5 => l_legal_employer_details.org_number,
860: /* Archive the no of employees agewise in each gender group */
861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),
862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */

Line 864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),

860: /* Archive the no of employees agewise in each gender group */
861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),
862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),

Line 865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),

861: p_action_information6 => fnd_number.number_to_canonical (l_men_lower_age_count),
862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),

Line 866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),

862: p_action_information7 => fnd_number.number_to_canonical (l_men_middle_age_count),
863: p_action_information8 => fnd_number.number_to_canonical (l_men_upper_age_count),
864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),

Line 868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),

864: p_action_information9 => fnd_number.number_to_canonical (l_women_lower_age_count),
865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),

Line 869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),

865: p_action_information10 => fnd_number.number_to_canonical (l_women_middle_age_count),
866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),

Line 870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),

866: p_action_information11 => fnd_number.number_to_canonical (l_women_upper_age_count),
867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */

Line 871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),

867: /* Archive the no of working hours agewise in each gender group */
868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),

Line 872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),

868: p_action_information12 => fnd_number.number_to_canonical (l_men_lower_age_work_hour),
869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),

Line 873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),

869: p_action_information13 => fnd_number.number_to_canonical (l_men_middle_age_work_hour),
870: p_action_information14 => fnd_number.number_to_canonical (l_men_upper_age_work_hour),
871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),

Line 875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),

871: p_action_information15 => fnd_number.number_to_canonical (l_women_lower_age_work_hour),
872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),

Line 876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),

872: p_action_information16 => fnd_number.number_to_canonical (l_women_middle_age_work_hour),
873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),

Line 877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),

873: p_action_information17 => fnd_number.number_to_canonical (l_women_upper_age_work_hour),
874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */

Line 878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),

874: /* Archive the no of sick leaves agewise in each gender group */
875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),

Line 879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),

875: p_action_information18 => fnd_number.number_to_canonical (l_men_l_age_sick_leaves),
876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),

Line 880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),

876: p_action_information19 => fnd_number.number_to_canonical (l_men_m_age_sick_leaves),
877: p_action_information20 => fnd_number.number_to_canonical (l_men_u_age_sick_leaves),
878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),

Line 882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),

878: p_action_information21 => fnd_number.number_to_canonical (l_women_l_age_sick_leaves),
879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),

Line 883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),

879: p_action_information22 => fnd_number.number_to_canonical (l_women_m_age_sick_leaves),
880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),
887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)

Line 884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),

880: p_action_information23 => fnd_number.number_to_canonical (l_women_u_age_sick_leaves),
881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),
887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)
888: );

Line 885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),

881: /* Archive the no of long sick leaves agewise in each gender group */
882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),
887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)
888: );
889: pay_action_information_api.create_action_information (

Line 886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),

882: p_action_information24 => fnd_number.number_to_canonical (l_men_l_age_l_sick_leaves),
883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),
887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)
888: );
889: pay_action_information_api.create_action_information (
890: p_action_information_id => l_action_info_id,

Line 887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)

883: p_action_information25 => fnd_number.number_to_canonical (l_men_m_age_l_sick_leaves),
884: p_action_information26 => fnd_number.number_to_canonical (l_men_u_age_l_sick_leaves),
885: p_action_information27 => fnd_number.number_to_canonical (l_women_l_age_l_sick_leaves),
886: p_action_information28 => fnd_number.number_to_canonical (l_women_m_age_l_sick_leaves),
887: p_action_information29 => fnd_number.number_to_canonical (l_women_u_age_l_sick_leaves)
888: );
889: pay_action_information_api.create_action_information (
890: p_action_information_id => l_action_info_id,
891: p_action_context_id => p_payroll_action_id,

Line 904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),

900: p_action_information3 => p_legal_employer_id,
901: p_action_information4 => l_legal_employer_details.legal_employer_name,
902: p_action_information5 => l_legal_employer_details.org_number,
903: /* Archive the no of employees agewise in each gender group */
904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),
905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),

Line 905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),

901: p_action_information4 => l_legal_employer_details.legal_employer_name,
902: p_action_information5 => l_legal_employer_details.org_number,
903: /* Archive the no of employees agewise in each gender group */
904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),
905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),

Line 906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),

902: p_action_information5 => l_legal_employer_details.org_number,
903: /* Archive the no of employees agewise in each gender group */
904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),
905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),
910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)

Line 907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),

903: /* Archive the no of employees agewise in each gender group */
904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),
905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),
910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)
911: );

Line 908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),

904: p_action_information6 => fnd_number.number_to_canonical (l_leave_to_work_hours),
905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),
910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)
911: );
912: END;

Line 909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),

905: p_action_information7 => fnd_number.number_to_canonical (l_long_leave_part),
906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),
910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)
911: );
912: END;
913: -- Archiving the data , as this will fire once

Line 910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)

906: p_action_information8 => fnd_number.number_to_canonical (l_men_leave_to_work_hour),
907: p_action_information9 => fnd_number.number_to_canonical (l_women_leave_to_work_hour),
908: p_action_information10 => fnd_number.number_to_canonical (l_leave_to_work_hour_lower),
909: p_action_information11 => fnd_number.number_to_canonical (l_leave_to_work_hour_middle),
910: p_action_information12 => fnd_number.number_to_canonical (l_leave_to_work_hour_upper)
911: );
912: END;
913: -- Archiving the data , as this will fire once
914: BEGIN