141: ,p_item_scratchpad varchar2
142: ,p_shipping_method_code varchar2
143: ,p_local_reservation_id number
144: ,p_sourced_from VARCHAR2) return reqmt_lines_cur as
145: requirement_lines_rec csp_requirement_lines_pub.rql_rec_type;
146: reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
147: x_reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
148: l_lines_cursor reqmt_lines_cur;
149: x_requirement_line_id number;
142: ,p_shipping_method_code varchar2
143: ,p_local_reservation_id number
144: ,p_sourced_from VARCHAR2) return reqmt_lines_cur as
145: requirement_lines_rec csp_requirement_lines_pub.rql_rec_type;
146: reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
147: x_reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
148: l_lines_cursor reqmt_lines_cur;
149: x_requirement_line_id number;
150: x_return_status varchar2(1);
143: ,p_local_reservation_id number
144: ,p_sourced_from VARCHAR2) return reqmt_lines_cur as
145: requirement_lines_rec csp_requirement_lines_pub.rql_rec_type;
146: reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
147: x_reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
148: l_lines_cursor reqmt_lines_cur;
149: x_requirement_line_id number;
150: x_return_status varchar2(1);
151: x_msg_count number;
191: reqmt_lines_tbl(1).SHIPPING_METHOD_CODE := p_SHIppING_METHOD_CODE;
192: reqmt_lines_tbl(1).LOCAL_RESERVATION_ID := p_LOCAL_RESERVATION_ID;
193: reqmt_lines_tbl(1).SOURCED_FROM := p_SOURCED_FROM;
194:
195: CSP_REQUIREMENT_LINES_PUB.Create_REQUIREMENT_LINES(
196: 1.0,
197: FND_API.G_FALSE,
198: FND_API.G_FALSE,
199: reqmt_lines_tbl,