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.PO_COMMUNICATION_PVT dependencies on DUAL

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

745: -- bug 16475213 end
746:
747: BEGIN
748:
749: select to_char (PO_WF_ITEMKEY_S.NEXTVAL) into l_seq_for_item_key from sys.dual;
750:
751: l_itemkey := to_char(p_document_id) || '-' || l_seq_for_item_key;
752:
753: l_itemtype := 'POAPPRV';

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

857:
858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),
859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then
863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');
864: end if;
865:

Line 1623: select 'Y' into l_duplicate_filenames from dual

1619:
1620: -- bug4917605
1621: -- User base table to improve performance
1622: Begin
1623: select 'Y' into l_duplicate_filenames from dual
1624: where exists
1625: (
1626: select fl.file_name
1627: from fnd_documents d,

Line 1686: select 'Y' into l_duplicate_filenames from dual

1682: ELSE
1683: -- bug4917605
1684: -- User base table to improve performance
1685: Begin
1686: select 'Y' into l_duplicate_filenames from dual
1687: where exists
1688: (
1689: select fl.file_name
1690: from fnd_documents d,

Line 4525: select 'Y' into l_attachments_exist from dual

4521: IF (p_document_type = 'RELEASE') THEN
4522:
4523: -- bug4931216
4524: -- Go directly to the base tables for better performance
4525: select 'Y' into l_attachments_exist from dual
4526: where exists
4527: (
4528: select fl.file_name
4529: from fnd_documents d,

Line 4659: select 'Y' into l_attachments_exist from dual

4655:
4656:
4657: -- bug4931216
4658: -- Go directly to the base tables for better performance
4659: select 'Y' into l_attachments_exist from dual
4660: where exists
4661: (
4662: select fl.file_name
4663: from fnd_documents d,

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

5193:
5194: IF get_preparer_profile(p_document_id, p_document_type, 'ENABLE_TIMEZONE_CONVERSIONS') = 'Y' THEN --Bug 6692126
5195: BEGIN
5196: --Bug 6692126 Get the profile value based on prepares context
5197: --Bug 6692126 SELECT fnd_profile.value('SERVER_TIMEZONE_ID') into l_timezone_id from dual;
5198: l_timezone_id := get_preparer_profile(p_document_id, p_document_type, 'SERVER_TIMEZONE_ID'); --Bug 6692126
5199: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id = to_number(l_timezone_id);
5200: EXCEPTION
5201: WHEN OTHERS THEN

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

6429: l_shipmentAttachmentQuery := l_shipmentAttachmentQuery || ' order by seq_num';
6430: End If;
6431: -- End Bug16076162
6432:
6433: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Start of executing queries', l_time);
6436: END IF;
6437:

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

6458: l_lineAttach_query := :3;
6459: l_disAttach_query := :4;
6460: l_fileClob := :5;
6461:
6462: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6464: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
6465: END IF;
6466:

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

6470: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
6471: :xresult := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6472: dbms_xmlgen.closeContext(context);
6473:
6474: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
6477: END IF;
6478:

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

6482: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
6483: :xheaderAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6484: dbms_xmlgen.closeContext(context);
6485:
6486: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
6489: END IF;
6490:

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

6494: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
6495: :xlineAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6496: dbms_xmlgen.closeContext(context);
6497:
6498: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6499: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
6501: END IF;
6502:

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

6506: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
6507: :xdisAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6508: dbms_xmlgen.closeContext(context);
6509:
6510: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
6513: END IF;
6514:

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

6513: END IF;
6514:
6515: IF l_fileClob is not null THEN
6516:
6517: open refcur for ''select :l_fileClob1 as text_file from dual'' using l_fileClob;
6518: context := DBMS_XMLGEN.newContext(refcur);
6519: DBMS_XMLGEN.setRowTag(context,NULL);
6520: DBMS_XMLGEN.setRowSetTag(context,NULL);
6521: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);

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

6532: END IF;
6533:
6534: -- bug#3580225 Start --
6535:
6536: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:

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

6559: execute immediate l_xml9_stmt USING l_xml_query , l_headerAttachmentsQuery, l_lineAttachQuery, l_shipmentAttachmentQuery, l_fileClob,
6560: OUT l_xml_result, OUT l_headerAttachments, OUT l_line_Attachments, OUT l_disAttachments, OUT l_fileClob, OUT l_address_details;
6561:
6562:
6563: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6564: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'End of executing queries', l_time);
6566: END IF;
6567:

Line 7494: FROM dual

7490: l_signed := TRUE;
7491: else
7492: SELECT 'Y'
7493: INTO l_signatures
7494: FROM dual
7495: WHERE EXISTS (SELECT 1
7496: FROM PO_ACTION_HISTORY
7497: WHERE object_id = p_header_id
7498: AND object_type_code IN ('PO', 'PA')

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

7559: l_revision_num := p_revision_num;
7560:
7561: -- If the language code is null the get the userenv language.
7562: IF p_language_code IS NULL THEN
7563: SELECT userenv('LANG') INTO l_language_code FROM dual;
7564: ELSE
7565: l_language_code := p_language_code;
7566: END IF;
7567: