DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_COMPENSATION

Line 934: l_result BEN_TCS_COMPENSATION.period_table;

930: l_uom VARCHAR2(30);
931: l_comp_type_cd VARCHAR2(30);
932: l_nnmntry_uom VARCHAR(30);
933: l_status VARCHAR2(3);
934: l_result BEN_TCS_COMPENSATION.period_table;
935: l_count number := 0;
936: item_u_cnt NUMBER :=0;
937: item item_ids := null;
938: item_cnt NUMBER :=0;

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

1019: INTO l_source_cd , l_source_key ,l_uom ,l_nnmntry_uom,l_comp_type_cd ,item_name
1020: FROM ben_tcs_item
1021: WHERE item_id = item_id_process.item_id;
1022:
1023: hr_utility.set_location('Before BEN_TCS_COMPENSATION.get_value_for_item call',83);
1024: hr_utility.set_location('Assignment Id'|| l_assign.assignment_id ,84) ;
1025: hr_utility.set_location('Person Id' || p_person_id,85);
1026: -- hr_utility.trace_on(null,'tcs');
1027: BEN_TCS_COMPENSATION.get_value_for_item(p_source_cd => l_source_cd,

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

1023: hr_utility.set_location('Before BEN_TCS_COMPENSATION.get_value_for_item call',83);
1024: hr_utility.set_location('Assignment Id'|| l_assign.assignment_id ,84) ;
1025: hr_utility.set_location('Person Id' || p_person_id,85);
1026: -- hr_utility.trace_on(null,'tcs');
1027: BEN_TCS_COMPENSATION.get_value_for_item(p_source_cd => l_source_cd,
1028: p_source_key => l_source_key,
1029: p_perd_st_dt => p_start_date,
1030: p_perd_en_dt => p_period_end_date,
1031: p_person_id => p_person_id,

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

1036: p_effective_date => p_period_end_date ,
1037: p_result => l_result,
1038: p_status => l_status);
1039:
1040: hr_utility.set_location('After BEN_TCS_COMPENSATION.get_value_for_item call',86);
1041: -- hr_utility.trace_off;
1042: IF ( l_status = '0') THEN
1043: IF (l_result.count > 0) THEN
1044: IF (item_id_process.cntr_cd = 'ER' OR item_id_process.cntr_cd = 'EE' ) THEN