APPS.PON_PRINTING_PKG dependencies on DUAL

Line 990: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;

986: -- and fu.USER_ID = pah.CREATED_BY;
987:
988: dbms_lob.createtemporary(result, TRUE);
989:
990: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
991:
992: xml_stmt := 'DECLARE
993: queryCtx DBMS_XMLGEN.ctxHandle;
994: BEGIN

Line 1005: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;

1001: END;';
1002: execute immediate xml_stmt
1003: USING IN OUT xml_query_cursor, IN OUT result;
1004:
1005: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
1006:
1007: CLOSE xml_query_cursor;
1008:
1009: IF l_statement_log_level >= l_current_log_level THEN

Line 1023: -- This function is used to query data for individual supplier report |

1019:
1020: -------------------------------------------------------------------------*\
1021: -- 13-Nov-2008 Yao Zhang Create |
1022: -- Function Name: GENERATE_SUPPLIER_XML |
1023: -- This function is used to query data for individual supplier report |
1024: -------------------------------------------------------------------------*/
1025:
1026: FUNCTION generate_supplier_xml(p_auction_header_id IN NUMBER,
1027: p_supplier_sequence IN NUMBER) RETURN CLOB IS

Line 1437: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;

1433: END IF;
1434:
1435: dbms_lob.createtemporary(result, TRUE);
1436:
1437: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
1438:
1439: xml_stmt := 'DECLARE
1440: queryCtx DBMS_XMLGEN.ctxHandle;
1441: BEGIN

Line 1452: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;

1448: END;';
1449: execute immediate xml_stmt
1450: USING IN OUT xml_query_cursor, IN OUT result;
1451:
1452: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
1453:
1454: CLOSE xml_query_cursor;
1455:
1456: IF l_statement_log_level >= l_current_log_level THEN

Line 1469: -- This function is used to query data for receipt to individual supplier |

1465:
1466: -------------------------------------------------------------------------*\
1467: -- 10-Dec-2008 Lion Li Create |
1468: -- Function Name: GENERATE_EMD_FORFEIT_XML |
1469: -- This function is used to query data for receipt to individual supplier |
1470: -------------------------------------------------------------------------*/
1471:
1472: FUNCTION generate_receipt_xml(p_auction_header_id IN NUMBER,
1473: p_supplier_sequence IN NUMBER) RETURN CLOB IS

Line 1657: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;

1653: and hz.party_id(+) = paha.trading_partner_contact_id;
1654:
1655: dbms_lob.createtemporary(result, TRUE);
1656:
1657: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
1658:
1659: xml_stmt := 'DECLARE
1660: queryCtx DBMS_XMLGEN.ctxHandle;
1661: BEGIN

Line 1672: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;

1668: END;';
1669: execute immediate xml_stmt
1670: USING IN OUT xml_query_cursor, IN OUT result;
1671:
1672: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
1673:
1674: CLOSE xml_query_cursor;
1675:
1676: IF l_statement_log_level >= l_current_log_level THEN

Line 2669: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;

2665: -------------------------------------------------
2666:
2667: --dbms_lob.createtemporary(result, TRUE);
2668:
2669: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
2670:
2671:
2672:
2673: BEGIN

Line 2871: and (l_is_buyer_negpdf IN (SELECT 'Y' FROM dual)

2867: and lt.line_type_id(+) = paip.line_type_id
2868: and lt.language(+) = l_printing_language
2869: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2870: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
2871: and (l_is_buyer_negpdf IN (SELECT 'Y' FROM dual)
2872: or
2873: (not exists (select 'x'
2874: from pon_bidding_parties bp
2875: where bp.auction_header_id = paip.auction_header_id

Line 4821: queryCtx := DBMS_XMLGEN.newContext('select null from dual');

4817:
4818: CLOSE doc_msgs_cursor;
4819:
4820: dbms_lob.createtemporary(res, TRUE);
4821: queryCtx := DBMS_XMLGEN.newContext('select null from dual');
4822: DBMS_XMLGEN.SetRowSetTag(queryCtx, null);
4823: DBMS_XMLGEN.SetRowTag(queryCtx, null);
4824: DBMS_XMLGEN.getXML(queryCtx, res, DBMS_XMLGEN.NONE);
4825: DBMS_XMLGEN.closeContext (queryCtx);

Line 4829: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;

4825: DBMS_XMLGEN.closeContext (queryCtx);
4826:
4827: result := res || '' || '' || xml_clob || '' || '';
4828:
4829: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
4830:
4831: IF l_statement_log_level >= l_current_log_level THEN
4832: FND_LOG.string(l_statement_log_level, l_module_name, 'PDF: generating XML time: ' || (l_end_time - l_start_time) * 24 * 60 * 60);
4833: END IF;