147:
148: end get_poi_to_send_ntfn;
149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
148: end get_poi_to_send_ntfn;
149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,
684: /* 3) Coverage Start date */
685: /* 4) */
686: /* */
687: Procedure ghr_tsp_migrate(
688: p_assignment_id in per_assignments_f.assignment_id%type,
689: p_opt_name in Varchar2,
690: p_opt_val in Number,
691: p_effective_date in Date,
692: p_business_group_id in per_assignments_f.business_group_id%type,
688: p_assignment_id in per_assignments_f.assignment_id%type,
689: p_opt_name in Varchar2,
690: p_opt_val in Number,
691: p_effective_date in Date,
692: p_business_group_id in per_assignments_f.business_group_id%type,
693: p_person_id in per_assignments_f.person_id%type) is
694:
695: l_prog_count number;
696: l_plan_count number;
689: p_opt_name in Varchar2,
690: p_opt_val in Number,
691: p_effective_date in Date,
692: p_business_group_id in per_assignments_f.business_group_id%type,
693: p_person_id in per_assignments_f.person_id%type) is
694:
695: l_prog_count number;
696: l_plan_count number;
697: l_oipl_count number;
1041:
1042:
1043: /* TSP Catch Up Migration Procedure */
1044: Procedure ghr_tsp_catchup_migrate(
1045: p_assignment_id in per_assignments_f.assignment_id%type,
1046: p_opt_name in Varchar2,
1047: p_opt_val in Number,
1048: p_effective_date in Date,
1049: p_business_group_id in per_assignments_f.business_group_id%type,
1045: p_assignment_id in per_assignments_f.assignment_id%type,
1046: p_opt_name in Varchar2,
1047: p_opt_val in Number,
1048: p_effective_date in Date,
1049: p_business_group_id in per_assignments_f.business_group_id%type,
1050: p_person_id in per_assignments_f.person_id%type) is
1051:
1052: l_prog_count number;
1053: l_plan_count number;
1046: p_opt_name in Varchar2,
1047: p_opt_val in Number,
1048: p_effective_date in Date,
1049: p_business_group_id in per_assignments_f.business_group_id%type,
1050: p_person_id in per_assignments_f.person_id%type) is
1051:
1052: l_prog_count number;
1053: l_plan_count number;
1054: l_oipl_count number;