APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PB_INPUT_HEADERS_VL

Line 469: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,

465: qp_price_book_messages table and also return all messages concatenated in
466: x_return_status for use with get_catalog and UI.
467: *****************************************************************************/
468: PROCEDURE Validate_PB_Input_Criteria (
469: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,
470: p_pb_input_lines_tbl IN pb_input_lines_tbl,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_return_text IN OUT NOCOPY VARCHAR2)
473: IS

Line 2295: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;

2291: p_pb_input_header_id IN NUMBER,
2292: x_return_status OUT NOCOPY VARCHAR2,
2293: x_return_text IN OUT NOCOPY VARCHAR2)
2294: IS
2295: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
2296: l_price_book_messages_tbl price_book_messages_tbl;
2297: l_pb_input_lines_tbl pb_input_lines_tbl;
2298: l_message_text VARCHAR2(2000);
2299: i NUMBER := 1;

Line 2306: FROM qp_pb_input_headers_vl

2302: --Fetch the Price Book Input Header record into variable
2303: BEGIN
2304: SELECT *
2305: INTO l_pb_input_header_rec
2306: FROM qp_pb_input_headers_vl
2307: WHERE pb_input_header_id = p_pb_input_header_id;
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: x_return_status := 'E';

Line 2348: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,

2344: Procedure to insert Price Book Header info into qp_price_book_headers_b
2345: and _tl tables.
2346: ******************************************************************************/
2347: PROCEDURE Insert_Price_Book_Header (
2348: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,
2349: x_price_book_header_id OUT NOCOPY NUMBER)
2350: IS
2351: l_application_id NUMBER;
2352: l_request_type_code VARCHAR2(30);

Line 4137: FROM qp_pb_input_headers_vl

4133: BEGIN
4134:
4135: SELECT pb_input_header_id
4136: INTO l_pb_input_header_id
4137: FROM qp_pb_input_headers_vl
4138: WHERE price_book_name = p_price_book_name
4139: AND customer_attr_value = p_customer_attr_value
4140: --AND effective_date = p_effective_date
4141: AND price_book_type_code = p_price_book_type_code;

Line 4180: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;

4176: x_return_text IN OUT NOCOPY VARCHAR2
4177: )
4178: IS
4179: l_pb_input_header_id NUMBER;
4180: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;

Line 4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;

4177: )
4178: IS
4179: l_pb_input_header_id NUMBER;
4180: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;

Line 4198: FROM qp_pb_input_headers_vl

4194: --Fetch the Price Book Input Header record into variable
4195: BEGIN
4196: SELECT *
4197: INTO l_pb_input_header_rec
4198: FROM qp_pb_input_headers_vl
4199: WHERE pb_input_header_id = p_pb_input_header_id;
4200: EXCEPTION
4201: WHEN OTHERS THEN
4202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4221: FROM qp_pb_input_headers_vl

4217: --Fetch the Price Book Input Header record into variable
4218: BEGIN
4219: SELECT *
4220: INTO l_full_pb_input_header_rec
4221: FROM qp_pb_input_headers_vl
4222: WHERE price_book_name = l_pb_input_header_rec.price_book_name
4223: AND customer_attr_value = l_pb_input_header_rec.customer_attr_value
4224: AND customer_context = l_pb_input_header_rec.customer_context
4225: AND customer_attribute = l_pb_input_header_rec.customer_attribute