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.

[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on DUAL

Line 640: select to_char (PO_WF_ITEMKEY_S.NEXTVAL) into l_seq_for_item_key from sys.dual;

636: l_okc_doc_type varchar2(50);
637:
638: BEGIN
639:
640: select to_char (PO_WF_ITEMKEY_S.NEXTVAL) into l_seq_for_item_key from sys.dual;
641:
642: l_itemkey := to_char(p_document_id) || '-' || l_seq_for_item_key;
643:
644: l_itemtype := 'POAPPRV';

Line 752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;

748:
749: select DECODE(p_document_subtype,'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then
754: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');
755: end if;
756:

Line 1377: select 'Y' into l_duplicate_filenames from dual

1373:
1374: -- bug4917605
1375: -- User base table to improve performance
1376: Begin
1377: select 'Y' into l_duplicate_filenames from dual
1378: where exists
1379: (
1380: select fl.file_name
1381: from fnd_documents d,

Line 1440: select 'Y' into l_duplicate_filenames from dual

1436: ELSE
1437: -- bug4917605
1438: -- User base table to improve performance
1439: Begin
1440: select 'Y' into l_duplicate_filenames from dual
1441: where exists
1442: (
1443: select fl.file_name
1444: from fnd_documents d,

Line 3970: select 'Y' into l_attachments_exist from dual

3966: IF (p_document_type='RELEASE') THEN
3967:
3968: -- bug4931216
3969: -- Go directly to the base tables for better performance
3970: select 'Y' into l_attachments_exist from dual
3971: where exists
3972: (
3973: select fl.file_name
3974: from fnd_documents d,

Line 4023: select 'Y' into l_attachments_exist from dual

4019:
4020:
4021: -- bug4931216
4022: -- Go directly to the base tables for better performance
4023: select 'Y' into l_attachments_exist from dual
4024: where exists
4025: (
4026: select fl.file_name
4027: from fnd_documents d,

Line 4439: --Bug 6692126 SELECT fnd_profile.value('SERVER_TIMEZONE_ID') into l_timezone_id from dual;

4435:
4436: IF get_preparer_profile(p_document_id,p_document_type,'ENABLE_TIMEZONE_CONVERSIONS') = 'Y' THEN --Bug 6692126
4437: BEGIN
4438: --Bug 6692126 Get the profile value based on prepares context
4439: --Bug 6692126 SELECT fnd_profile.value('SERVER_TIMEZONE_ID') into l_timezone_id from dual;
4440: l_timezone_id := get_preparer_profile(p_document_id,p_document_type,'SERVER_TIMEZONE_ID'); --Bug 6692126
4441: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id=to_number(l_timezone_id);
4442: EXCEPTION
4443: WHEN OTHERS THEN

Line 5392: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;

5388: AND fad.datatype_id=2
5389: AND pllx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId()
5390: order by seq_num'; --bug6133951
5391:
5392: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Start of executing queries', l_time);
5395: END IF;
5396:

Line 5421: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5417: l_lineAttach_query := :3;
5418: l_disAttach_query := :4;
5419: l_fileClob := :5;
5420:
5421: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5423: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
5424: END IF;
5425:

Line 5433: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5429: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
5430: :xresult := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5431: dbms_xmlgen.closeContext(context);
5432:
5433: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
5436: END IF;
5437:

Line 5445: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5441: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
5442: :xheaderAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5443: dbms_xmlgen.closeContext(context);
5444:
5445: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5446: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
5448: END IF;
5449:

Line 5457: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5453: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
5454: :xlineAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5455: dbms_xmlgen.closeContext(context);
5456:
5457: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5459: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
5460: END IF;
5461:

Line 5469: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5465: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
5466: :xdisAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5467: dbms_xmlgen.closeContext(context);
5468:
5469: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5470: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5471: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
5472: END IF;
5473:

Line 5476: open refcur for ''select :l_fileClob1 as text_file from dual'' using l_fileClob;

5472: END IF;
5473:
5474: IF l_fileClob is not null THEN
5475:
5476: open refcur for ''select :l_fileClob1 as text_file from dual'' using l_fileClob;
5477: context := DBMS_XMLGEN.newContext(refcur);
5478: DBMS_XMLGEN.setRowTag(context,NULL);
5479: DBMS_XMLGEN.setRowSetTag(context,NULL);
5480: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);

Line 5495: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;

5491: END IF;
5492:
5493: -- bug#3580225 Start --
5494:
5495: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5496: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:

Line 5522: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;

5518: execute immediate l_xml9_stmt USING l_xml_query , l_headerAttachmentsQuery, l_lineAttachQuery, l_shipmentAttachmentQuery, l_fileClob,
5519: OUT l_xml_result, OUT l_headerAttachments, OUT l_line_Attachments, OUT l_disAttachments, OUT l_fileClob, OUT l_address_details;
5520:
5521:
5522: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5524: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'End of executing queries', l_time);
5525: END IF;
5526:

Line 6372: FROM dual

6368: -- SQL Why :To find out if the document was ever signed
6369: begin
6370: SELECT 'Y'
6371: INTO l_signatures
6372: FROM dual
6373: WHERE EXISTS (SELECT 1
6374: FROM PO_ACTION_HISTORY
6375: WHERE object_id = p_header_id
6376: AND object_type_code IN ('PO','PA')

Line 6433: SELECT userenv('LANG') INTO l_language_code FROM dual;

6429: BEGIN
6430:
6431: -- If the language code is null the get the userenv language.
6432: IF p_language_code IS NULL THEN
6433: SELECT userenv('LANG') INTO l_language_code FROM dual;
6434: ELSE
6435: l_language_code := p_language_code;
6436: END IF;
6437: