APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_MESSAGES

Line 9: qp_price_book_messages table.

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_BOOK_UTIL';
6:
7: /*****************************************************************************
8: Procedure to insert Price Book related error and warning messages into
9: qp_price_book_messages table.
10: *****************************************************************************/
11: PROCEDURE Insert_Price_Book_Messages (
12: p_price_book_messages_tbl IN price_book_messages_tbl)
13: IS

Line 49: INSERT INTO qp_price_book_messages

45: END LOOP;
46: END IF; --If p_price_book_messages_tbl.count > 0
47:
48: FORALL i IN p_price_book_messages_tbl.FIRST..p_price_book_messages_tbl.LAST
49: INSERT INTO qp_price_book_messages
50: (message_id,
51: message_type,
52: message_code,
53: message_text,

Line 64: (qp_price_book_messages_s.nextval,

60: last_updated_by,
61: last_update_login
62: )
63: VALUES
64: (qp_price_book_messages_s.nextval,
65: l_message_type_tbl(i),
66: l_message_code_tbl(i),
67: l_message_text_tbl(i),
68: l_pb_input_header_id_tbl(i),

Line 465: qp_price_book_messages table and also return all messages concatenated in

461:
462:
463: /*****************************************************************************
464: Procedure to Validate Price Book Input Validation messages into
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,

Line 2924: DELETE FROM QP_PRICE_BOOK_MESSAGES WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);

2920: IF SQL%FOUND THEN
2921: COMMIT;
2922: END IF;
2923:
2924: DELETE FROM QP_PRICE_BOOK_MESSAGES WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);
2925: IF SQL%FOUND THEN
2926: COMMIT;
2927: END IF;
2928:

Line 2961: DELETE FROM QP_PRICE_BOOK_MESSAGES WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);

2957: IF SQL%FOUND THEN
2958: COMMIT;
2959: END IF;
2960: */
2961: DELETE FROM QP_PRICE_BOOK_MESSAGES WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);
2962: IF SQL%FOUND THEN
2963: --COMMIT;
2964: null; --Commit will be done only after successful insertion.
2965: END IF;

Line 4596: from QP_PRICE_BOOK_MESSAGES_V pbm

4592: ),
4593: DECODE((SELECT ''X''
4594: from dual
4595: where exists(SELECT ''X''
4596: from QP_PRICE_BOOK_MESSAGES_V pbm
4597: where pbm.Price_Book_Line_Id = PBLin.Price_Book_Line_Id )),
4598: ''X'',
4599: XMLElement(
4600: "PriceBookMessagesVO",

Line 4613: FROM QP_PRICE_BOOK_MESSAGES_V QPPBMSGS

4609: QPPBMSGS.PRICE_BOOK_HEADER_ID "PriceBookHeaderId",
4610: QPPBMSGS.PRICE_BOOK_LINE_ID "PriceBookLineId")
4611: )
4612: )
4613: FROM QP_PRICE_BOOK_MESSAGES_V QPPBMSGS
4614: WHERE QPPBMSGS.Price_Book_Line_Id = PBLin.Price_Book_Line_Id
4615:
4616: )
4617: )

Line 4682: qp_price_book_messages_s.nextval,

4678: LAST_UPDATE_LOGIN,
4679: XML_CONTENT
4680: )
4681: VALUES(
4682: qp_price_book_messages_s.nextval,
4683: EMPTY_BLOB(),
4684: p_document_content_type,
4685: p_document_name,
4686: sysdate,