APPS.QP_PRICE_BOOK_PUB dependencies on QP_PRICE_BOOK_MESSAGES

Line 78: SELECT qp_price_book_messages_s.nextval

74: x_return_status := 'E';
75: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
76: l_message_text := FND_MESSAGE.GET;
77: BEGIN
78: SELECT qp_price_book_messages_s.nextval
79: INTO x_price_book_messages_tbl(1).message_id FROM dual;
80: EXCEPTION
81: WHEN OTHERS THEN
82: x_price_book_messages_tbl(1).message_id := NULL;

Line 147: SELECT qp_price_book_messages_s.nextval

143: x_return_status := 'E';
144: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
145: l_message_text := FND_MESSAGE.GET;
146: BEGIN
147: SELECT qp_price_book_messages_s.nextval
148: INTO x_price_book_messages_tbl(1).message_id FROM dual;
149: EXCEPTION
150: WHEN OTHERS THEN
151: x_price_book_messages_tbl(1).message_id := NULL;

Line 199: SELECT qp_price_book_messages_s.nextval

195: x_return_status := 'E';
196: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
197: l_message_text := FND_MESSAGE.GET;
198: BEGIN
199: SELECT qp_price_book_messages_s.nextval
200: INTO x_price_book_messages_tbl(1).message_id FROM dual;
201: EXCEPTION
202: WHEN OTHERS THEN
203: x_price_book_messages_tbl(1).message_id := NULL;

Line 453: FROM qp_price_book_messages

449: x_err_buf => x_err_buf);
450:
451: IF x_return_status = 'E' THEN --If input validation errors occur
452: SELECT * BULK COLLECT INTO x_price_book_messages_tbl
453: FROM qp_price_book_messages
454: WHERE pb_input_header_id = l_pb_input_header_id;
455:
456: DELETE FROM qp_price_book_messages
457: WHERE pb_input_header_id = l_pb_input_header_id;

Line 456: DELETE FROM qp_price_book_messages

452: SELECT * BULK COLLECT INTO x_price_book_messages_tbl
453: FROM qp_price_book_messages
454: WHERE pb_input_header_id = l_pb_input_header_id;
455:
456: DELETE FROM qp_price_book_messages
457: WHERE pb_input_header_id = l_pb_input_header_id;
458:
459: DELETE FROM qp_pb_input_headers_b
460: WHERE pb_input_header_id = l_pb_input_header_id;

Line 724: FROM qp_price_book_messages

720: FROM qp_price_book_break_lines_v
721: WHERE price_book_header_id = x_price_book_header_rec.price_book_header_id;
722:
723: SELECT * BULK COLLECT INTO x_price_book_messages_tbl
724: FROM qp_price_book_messages
725: WHERE price_book_header_id = x_price_book_header_rec.price_book_header_id;
726:
727: END Get_Price_Book;
728: