236: /*****************************************************************************
237: Internal API to Insert Price Book Lines, Attributes, Break Lines and Messages
238: ******************************************************************************/
239: PROCEDURE Insert_Price_Book_Content(
240: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,
241: p_pb_input_lines_tbl IN QP_PRICE_BOOK_UTIL.pb_input_lines_tbl,
242: p_price_book_header_id IN NUMBER
243: )
244: IS
1524: p_customer_id IN NUMBER := NULL,
1525: p_price_book_header_id IN NUMBER := NULL,
1526: p_spawned_request IN VARCHAR2 := 'N')
1527: IS
1528: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
1529: l_pb_input_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;
1530: l_publish_price_book_header_id NUMBER := NULL;
1531: l_overwrite_pb_header_id NUMBER := NULL;
1532: l_item_validation_org_id NUMBER;
1692:
1693: BEGIN
1694: SELECT *
1695: INTO l_pb_input_header_rec
1696: FROM qp_pb_input_headers_vl
1697: WHERE pb_input_header_id = p_pb_input_header_id;
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');