DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_DOCUMENTS

Line 2930: DELETE FROM QP_DOCUMENTS WHERE DOCUMENT_ID in (l_document_id,d_document_id);

2926: COMMIT;
2927: END IF;
2928:
2929:
2930: DELETE FROM QP_DOCUMENTS WHERE DOCUMENT_ID in (l_document_id,d_document_id);
2931: IF SQL%FOUND THEN
2932: COMMIT;
2933: END IF;
2934:

Line 4663: DELETE FROM QP_DOCUMENTS

4659: l_end_time := dbms_utility.get_time;
4660: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Time Taken for Creation of XML: '||((l_end_time-l_st_time)/100));
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:

Line 4669: INSERT INTO QP_DOCUMENTS(

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(
4670: DOCUMENT_ID,
4671: DOCUMENT_CONTENT,
4672: DOCUMENT_CONTENT_TYPE,
4673: DOCUMENT_NAME,