DBA Data[Home] [Help]

APPS.CSP_CREATE_PARTS_REQ_PKG dependencies on CSP_REQUIREMENT_LINES_PUB

Line 145: requirement_lines_rec csp_requirement_lines_pub.rql_rec_type;

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;

Line 146: reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;

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);

Line 147: x_reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;

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;

Line 195: CSP_REQUIREMENT_LINES_PUB.Create_REQUIREMENT_LINES(

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,