37: select sum(mr.reservation_quantity)
38: from csf_debrief_headers cdh,
39: csp_requirement_headers crh,
40: csp_requirement_lines crl,
41: csp_req_line_details crld,
42: mtl_reservations mr
43: where cdh.debrief_header_id = p_dbf_hdr_id
44: and crh.task_assignment_id = cdh.task_assignment_id
45: and crl.requirement_header_id = crh.requirement_header_id
92: l_reservation_rec csp_sch_int_pvt.reservation_rec_typ;
93: l_reservation_id number;
94: l_req_line_id_to_link number;
95:
96: l_req_line_dtl_rec csp_req_line_details_pvt.req_line_details_rec_type;
97: l_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
98: x_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
99: begin
100: log('create_reservations', 'p_dbf_hdr_id=' || p_dbf_hdr_id);
93: l_reservation_id number;
94: l_req_line_id_to_link number;
95:
96: l_req_line_dtl_rec csp_req_line_details_pvt.req_line_details_rec_type;
97: l_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
98: x_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
99: begin
100: log('create_reservations', 'p_dbf_hdr_id=' || p_dbf_hdr_id);
101: log('create_reservations', 'p_inventory_item_id=' || p_inventory_item_id);
94: l_req_line_id_to_link number;
95:
96: l_req_line_dtl_rec csp_req_line_details_pvt.req_line_details_rec_type;
97: l_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
98: x_req_line_dtl_tbl csp_req_line_details_pvt.req_line_details_tbl_type;
99: begin
100: log('create_reservations', 'p_dbf_hdr_id=' || p_dbf_hdr_id);
101: log('create_reservations', 'p_inventory_item_id=' || p_inventory_item_id);
102: log('create_reservations', 'p_qty=' || p_qty);
185: l_req_line_dtl_rec.source_type := 'RES';
186: l_req_line_dtl_rec.source_id := l_reservation_id;
187: l_req_line_dtl_tbl(1) := l_req_line_dtl_rec;
188:
189: csp_req_line_details_pvt.create_req_line_details(
190: p_api_version_number => 1.0
191: , p_init_msg_list => fnd_api.g_false
192: , p_commit => fnd_api.g_false
193: , p_validation_level => fnd_api.g_valid_level_full