APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_HEADERS_B

Line 2344: Procedure to insert Price Book Header info into qp_price_book_headers_b

2340: END Validate_PB_Inp_Criteria_Wrap;
2341:
2342:
2343: /******************************************************************************
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,

Line 2666: FROM qp_price_book_headers_b

2662: BEGIN
2663: BEGIN
2664: SELECT cust_account_id
2665: INTO l_cust_account_id
2666: FROM qp_price_book_headers_b
2667: WHERE price_book_header_id = p_pb_header_id;
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: l_cust_account_id := null;

Line 2717: FROM qp_price_book_headers_b

2713: BEGIN
2714: BEGIN
2715: SELECT cust_account_id
2716: INTO l_cust_account_id
2717: FROM qp_price_book_headers_b
2718: WHERE price_book_header_id = p_pb_header_id;
2719: EXCEPTION
2720: WHEN OTHERS THEN
2721: l_cust_account_id := null;

Line 2904: DELETE FROM QP_PRICE_BOOK_HEADERS_B WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);

2900: IF SQL%FOUND THEN
2901: COMMIT;
2902: END IF;
2903:
2904: DELETE FROM QP_PRICE_BOOK_HEADERS_B WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);
2905: IF SQL%FOUND THEN
2906: COMMIT;
2907: END IF;
2908:

Line 3457: UPDATE QP_PRICE_BOOK_HEADERS_B

3453: RAISE INVALID_PARAMS_ERROR;
3454: END IF;
3455:
3456: BEGIN
3457: UPDATE QP_PRICE_BOOK_HEADERS_B
3458: SET PUB_STATUS_CODE = 'REQUESTED'
3459: WHERE PRICE_BOOK_HEADER_ID = p_price_book_header_id;
3460: COMMIT;
3461: EXCEPTION

Line 3488: FROM QP_PRICE_BOOK_HEADERS_B

3484: DBMS_LOCK.SLEEP(L_STATUS_REQUEST_INTERVAL);
3485:
3486: SELECT PUB_STATUS_CODE
3487: INTO l_status_code
3488: FROM QP_PRICE_BOOK_HEADERS_B
3489: WHERE PRICE_BOOK_HEADER_ID = p_price_book_header_id;
3490:
3491: IF l_status_code = 'ERROR' THEN
3492: RAISE E_ROUTINE_ERRORS;

Line 3612: FROM qp_price_book_headers_b p, qp_pb_input_headers_b i

3608: msgs_sent_flag := FALSE;
3609:
3610: SELECT i.customer_attr_value, i.DLV_XML_SITE_ID
3611: INTO party_id, party_site_id
3612: FROM qp_price_book_headers_b p, qp_pb_input_headers_b i
3613: WHERE p.price_book_header_id = p_price_book_header_id
3614: AND p.pb_input_header_id = i.pb_input_header_id;
3615:
3616: IF (l_debug = FND_API.G_TRUE) THEN

Line 4665: FROM qp_price_book_headers_b

4661:
4662: --delete from qp_xml_documents where PRICE_BOOK_HEADER_ID=p_price_book_hdr_id;
4663: DELETE FROM QP_DOCUMENTS
4664: WHERE DOCUMENT_ID = (SELECT DOCUMENT_ID
4665: FROM qp_price_book_headers_b
4666: WHERE PRICE_BOOK_HEADER_ID = p_price_book_hdr_id);
4667:
4668: --INSERT INTO qp_xml_documents VALUES(p_price_book_hdr_id,result);
4669: INSERT INTO QP_DOCUMENTS(

Line 4694: UPDATE qp_price_book_headers_b

4690: fnd_global.conc_login_id,
4691: l_result
4692: ) RETURNING DOCUMENT_ID INTO l_doc_id;
4693:
4694: UPDATE qp_price_book_headers_b
4695: SET document_id=l_doc_id
4696: WHERE PRICE_BOOK_HEADER_ID = p_price_book_hdr_id;
4697:
4698: --Close context