28: END Get_Primary_UOM;
29:
30:
31: Procedure Consolidate_Labor_Coverages(
32: p_lbr_in_tbl IN oks_con_coverage_pub.bill_rate_tbl_type,
33: x_lbr_out_tbl OUT NOCOPY oks_con_coverage_pub.bill_rate_tbl_type)
34: IS
35:
36: i number;
29:
30:
31: Procedure Consolidate_Labor_Coverages(
32: p_lbr_in_tbl IN oks_con_coverage_pub.bill_rate_tbl_type,
33: x_lbr_out_tbl OUT NOCOPY oks_con_coverage_pub.bill_rate_tbl_type)
34: IS
35:
36: i number;
37: j number;
34: IS
35:
36: i number;
37: j number;
38: l_lbr_tmp_rec oks_con_coverage_pub.bill_rate_rec_type;
39:
40: BEGIN
41: j := 0;
42: FOR i IN 1..p_lbr_in_tbl.count LOOP
153: EXCP_USER_DEFINED EXCEPTION;
154:
155: l_charges_rec cs_charge_details_pub.charges_rec_type;
156: x_tm_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;
157: l_input_br_rec oks_con_coverage_pub.input_br_rec;
158: l_labor_sch_tbl oks_con_coverage_pub.labor_sch_tbl_type;
159: l_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
160: x_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
161:
154:
155: l_charges_rec cs_charge_details_pub.charges_rec_type;
156: x_tm_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;
157: l_input_br_rec oks_con_coverage_pub.input_br_rec;
158: l_labor_sch_tbl oks_con_coverage_pub.labor_sch_tbl_type;
159: l_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
160: x_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
161:
162: i number;
155: l_charges_rec cs_charge_details_pub.charges_rec_type;
156: x_tm_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;
157: l_input_br_rec oks_con_coverage_pub.input_br_rec;
158: l_labor_sch_tbl oks_con_coverage_pub.labor_sch_tbl_type;
159: l_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
160: x_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
161:
162: i number;
163: j number;
156: x_tm_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;
157: l_input_br_rec oks_con_coverage_pub.input_br_rec;
158: l_labor_sch_tbl oks_con_coverage_pub.labor_sch_tbl_type;
159: l_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
160: x_con_lbr_coverage_tbl oks_con_coverage_pub.bill_rate_tbl_type;
161:
162: i number;
163: j number;
164: l_duration number;
950: --DBMS_OUTPUT.PUT_LINE('l_labor_sch_tbl(1).end_datetime'||l_labor_sch_tbl(1).end_datetime);
951: --DBMS_OUTPUT.PUT_LINE('l_labor_sch_tbl(1).holiday_flag'||l_labor_sch_tbl(1).holiday_flag);
952:
953: -- Get Contract labor coverage billing data.
954: oks_con_coverage_pub.get_bill_rates(
955: p_api_version => p_api_version_number,
956: p_init_msg_list => FND_API.G_FALSE,
957: p_input_br_rec => l_input_br_rec,
958: p_labor_sch_tbl => l_labor_sch_tbl,