[Home] [Help]
457: end if;
458: if l_continue then
459: begin
460: hr_utility.set_location('cer insert api called',55);
461: ben_copy_entity_results_api.create_copy_entity_results
462: (p_effective_date => p_effective_date
463: ,p_copy_entity_txn_id => p_copy_entity_txn_id
464: ,p_result_type_cd => 'DISPLAY'
465: ,p_table_name => l_crr_tr_name
643: if l_continue then
644: begin
645: -- These mappings have been taken from hrben_to_stage document
646: -- call to create ben_cer is made here using api.
647: ben_copy_entity_results_api.create_copy_entity_results
648: (p_effective_date => p_effective_date
649: ,p_copy_entity_txn_id => p_copy_entity_txn_id
650: ,p_result_type_cd => 'DISPLAY'
651: ,p_table_name => l_crs_tr_name
1621: l_ordr_num := nvl(l_ordr_num,0) + 1;
1622: hr_utility.set_location('ord_num is '||l_ordr_num,20);
1623: end;
1624: begin
1625: ben_copy_entity_results_api.create_copy_entity_results(
1626: p_effective_date => p_effective_date
1627: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1628: ,p_gs_mr_src_entity_result_id => p_pgm_cer_id
1629: ,p_gs_parent_entity_result_id => p_pgm_cer_id
2478: get_table_route_details(p_table_alias => l_table_alias,
2479: p_table_route_id => l_table_route_id,
2480: p_table_name => l_table_route_name);
2481: -- create a row for the control record with the values of flags for this txn.
2482: ben_copy_entity_results_api.create_copy_entity_results
2483: (p_effective_date => p_effective_date
2484: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2485: ,p_result_type_cd => 'DISPLAY'
2486: ,p_table_name => l_table_route_name
2519: get_table_route_details(p_table_alias => l_table_alias,
2520: p_table_route_id => l_table_route_id,
2521: p_table_name => l_table_route_name);
2522: -- create a row for the control record with the values of flags for this txn.
2523: ben_copy_entity_results_api.create_copy_entity_results
2524: (p_effective_date => p_effective_date
2525: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2526: ,p_result_type_cd => 'DISPLAY'
2527: ,p_table_name => l_table_route_name
3248: hr_utility.set_location('pgm id is'||p_pgm_id,10);
3249: if p_pgm_id is not null then
3250: for i in c1 loop
3251: l_old_flag := 'N';
3252: BEN_COPY_ENTITY_RESULTS_API.CREATE_COPY_ENTITY_RESULTS(
3253: p_copy_entity_result_id => l_copy_entity_result_id
3254: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3255: ,p_result_type_cd => 'DISPLAY'
3256: ,p_information_category => 'PQH_GSP_EXTRA_INFO'
3266: ,p_dml_operation => 'UPDATE'
3267: );
3268: end loop;
3269: if l_old_flag = 'Y' then
3270: BEN_COPY_ENTITY_RESULTS_API.CREATE_COPY_ENTITY_RESULTS(
3271: p_copy_entity_result_id => l_copy_entity_result_id
3272: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3273: ,p_result_type_cd => 'DISPLAY'
3274: ,p_information_category => 'PQH_GSP_EXTRA_INFO'
3955: if l_continue then
3956: begin
3957: -- These mappings have been taken from hrben_to_stage document
3958: -- call to create ben_cer is made here using api.
3959: ben_copy_entity_results_api.create_copy_entity_results
3960: (p_effective_date => p_effective_date
3961: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3962: ,p_result_type_cd => 'DISPLAY'
3963: ,p_table_name => l_hrr_tr_name
4042: if l_continue then
4043: begin
4044: -- These mappings have been taken from hrben_to_stage document
4045: -- call to create ben_cer is made here using api.
4046: ben_copy_entity_results_api.create_copy_entity_results
4047: (p_effective_date => p_effective_date
4048: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4049: ,p_result_type_cd => 'DISPLAY'
4050: ,p_table_name => l_hrr_tr_name
4121: if l_continue then
4122: begin
4123: -- These mappings have been taken from hrben_to_stage document
4124: -- call to create ben_cer is made here using api.
4125: ben_copy_entity_results_api.create_copy_entity_results
4126: (p_effective_date => p_effective_date
4127: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4128: ,p_result_type_cd => 'DISPLAY'
4129: ,p_table_name => l_abr_tr_name
4245: -- create scale row in staging area
4246: begin
4247: -- These mappings have been taken from hrben_to_stage document
4248: -- call to create ben_cer is made here using api.
4249: ben_copy_entity_results_api.create_copy_entity_results
4250: (p_effective_date => p_effective_date
4251: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4252: ,p_result_type_cd => 'DISPLAY'
4253: ,p_table_name => l_scl_tr_name
5115: p_ceiling_flag => l_ceiling_flag,
5116: p_point_value => l_point_value,
5117: p_scale_id => l_scale_id);
5118: begin
5119: ben_copy_entity_results_api.create_copy_entity_results(
5120: p_effective_date => p_effective_date
5121: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5122: ,p_gs_parent_entity_result_id => p_plip_cer_id
5123: ,p_parent_entity_result_id => p_plip_cer_id
5384: p_grd_ovn => l_grd_ovn,
5385: p_grade_definition_id => l_grade_definition_id);
5386: end if;
5387: begin
5388: ben_copy_entity_results_api.create_copy_entity_results(
5389: p_effective_date => p_effective_date
5390: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5391: ,p_gs_mr_src_entity_result_id => p_plip_cer_id
5392: ,p_mirror_src_entity_result_id => p_plip_cer_id
5469: p_information5 => l_information5);
5470: end if;
5471: end if;
5472: begin
5473: ben_copy_entity_results_api.create_copy_entity_results(
5474: p_effective_date => p_effective_date
5475: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5476: ,p_result_type_cd => 'DISPLAY'
5477: ,p_table_name => l_opt_tr_name