DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_COMPENSATION

Line 942: l_result BEN_TCS_COMPENSATION.period_table;

938: l_uom VARCHAR2(30);
939: l_comp_type_cd VARCHAR2(30);
940: l_nnmntry_uom VARCHAR(30);
941: l_status VARCHAR2(3);
942: l_result BEN_TCS_COMPENSATION.period_table;
943: l_count number := 0;
944: item_u_cnt NUMBER :=0;
945: item item_ids := null;
946: item_cnt NUMBER :=0;

Line 1031: hr_utility.set_location('Before BEN_TCS_COMPENSATION.get_value_for_item call',83);

1027: INTO l_source_cd , l_source_key ,l_uom ,l_nnmntry_uom,l_comp_type_cd ,item_name
1028: FROM ben_tcs_item
1029: WHERE item_id = item_id_process.item_id;
1030:
1031: hr_utility.set_location('Before BEN_TCS_COMPENSATION.get_value_for_item call',83);
1032: hr_utility.set_location('Assignment Id'|| l_assign.assignment_id ,84) ;
1033: hr_utility.set_location('Person Id' || p_person_id,85);
1034: -- hr_utility.trace_on(null,'tcs');
1035: BEN_TCS_COMPENSATION.get_value_for_item(p_source_cd => l_source_cd,

Line 1035: BEN_TCS_COMPENSATION.get_value_for_item(p_source_cd => l_source_cd,

1031: hr_utility.set_location('Before BEN_TCS_COMPENSATION.get_value_for_item call',83);
1032: hr_utility.set_location('Assignment Id'|| l_assign.assignment_id ,84) ;
1033: hr_utility.set_location('Person Id' || p_person_id,85);
1034: -- hr_utility.trace_on(null,'tcs');
1035: BEN_TCS_COMPENSATION.get_value_for_item(p_source_cd => l_source_cd,
1036: p_source_key => l_source_key,
1037: p_perd_st_dt => p_start_date,
1038: p_perd_en_dt => p_period_end_date,
1039: p_person_id => p_person_id,

Line 1048: hr_utility.set_location('After BEN_TCS_COMPENSATION.get_value_for_item call',86);

1044: p_effective_date => p_period_end_date ,
1045: p_result => l_result,
1046: p_status => l_status);
1047:
1048: hr_utility.set_location('After BEN_TCS_COMPENSATION.get_value_for_item call',86);
1049: -- hr_utility.trace_off;
1050: IF ( l_status = '0') THEN
1051: IF (l_result.count > 0) THEN
1052: IF (item_id_process.cntr_cd = 'ER' OR item_id_process.cntr_cd = 'EE' ) THEN