eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_BOOK_UTIL dependencies on DBMS_XMLQUERY

Line 4379: l_qryCtx DBMS_XMLQUERY.ctxHandle;

4375: p_document_name IN VARCHAR2,
4376: x_return_status OUT NOCOPY VARCHAR2,
4377: x_return_text OUT NOCOPY VARCHAR2
4378: ) IS
4379: l_qryCtx DBMS_XMLQUERY.ctxHandle;
4380: l_st_time number;
4381: l_end_time number;
4382: l_result CLOB;
4383: l_doc_id number;

Line 4385: l_qryCtx := DBMS_XMLQUERY.newContext('SELECT XMLElement(

4381: l_end_time number;
4382: l_result CLOB;
4383: l_doc_id number;
4384: BEGIN
4385: l_qryCtx := DBMS_XMLQUERY.newContext('SELECT XMLElement(
4386: "PriceBookHeadersVORow",
4387: XMLForest( PBHDR.PRICE_BOOK_HEADER_ID "PriceBookHeaderId",
4388: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.CREATION_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "CreationDate",
4389: PBHDR.CREATED_BY "CreatedBy",

Line 4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');

4644: ) as "PriceBookHeadersVO"
4645: FROM QP_PRICE_BOOK_HEADERS_V PBHDR
4646: WHERE PRICE_BOOK_HEADER_ID = :PBHDRID');
4647: -- Set the row header to be QP_PRICE_BOOK
4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');
4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);
4650:
4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);
4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);

Line 4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);

4645: FROM QP_PRICE_BOOK_HEADERS_V PBHDR
4646: WHERE PRICE_BOOK_HEADER_ID = :PBHDRID');
4647: -- Set the row header to be QP_PRICE_BOOK
4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');
4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);
4650:
4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);
4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);
4653: -- Get the result

Line 4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);

4647: -- Set the row header to be QP_PRICE_BOOK
4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');
4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);
4650:
4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);
4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);
4653: -- Get the result
4654: l_st_time := dbms_utility.get_time;
4655: DBMS_XMLQUERY.SETENCODINGTAG(l_qryCtx,'UTF-8');

Line 4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);

4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');
4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);
4650:
4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);
4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);
4653: -- Get the result
4654: l_st_time := dbms_utility.get_time;
4655: DBMS_XMLQUERY.SETENCODINGTAG(l_qryCtx,'UTF-8');
4656: l_result := DBMS_XMLQUERY.getXML(l_qryCtx);

Line 4655: DBMS_XMLQUERY.SETENCODINGTAG(l_qryCtx,'UTF-8');

4651: DBMS_XMLQUERY.setBindValue(l_qryCtx, 'PBHDRID', p_price_book_hdr_id);
4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);
4653: -- Get the result
4654: l_st_time := dbms_utility.get_time;
4655: DBMS_XMLQUERY.SETENCODINGTAG(l_qryCtx,'UTF-8');
4656: l_result := DBMS_XMLQUERY.getXML(l_qryCtx);
4657:
4658:
4659: l_end_time := dbms_utility.get_time;

Line 4656: l_result := DBMS_XMLQUERY.getXML(l_qryCtx);

4652: --DBMS_XMLQUERY.setNullHandling(l_qryCtx, DBMS_XMLQUERY.DROP_NULLS);
4653: -- Get the result
4654: l_st_time := dbms_utility.get_time;
4655: DBMS_XMLQUERY.SETENCODINGTAG(l_qryCtx,'UTF-8');
4656: l_result := DBMS_XMLQUERY.getXML(l_qryCtx);
4657:
4658:
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));

Line 4699: DBMS_XMLQUERY.closeContext(l_qryCtx);

4695: SET document_id=l_doc_id
4696: WHERE PRICE_BOOK_HEADER_ID = p_price_book_hdr_id;
4697:
4698: --Close context
4699: DBMS_XMLQUERY.closeContext(l_qryCtx);
4700:
4701: x_return_status := FND_API.G_RET_STS_SUCCESS;
4702:
4703: COMMIT;