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

Line 717: from dual;

713: elsif p_field_code = 'FED_DATE' then
714: select to_char(sysdate,'MMDD')
715: into
716: rt_value
717: from dual;
718:
719: elsif p_field_code = 'FED_YEAR' then
720: select to_char(sysdate,'YY')
721: into

Line 723: from dual;

719: elsif p_field_code = 'FED_YEAR' then
720: select to_char(sysdate,'YY')
721: into
722: rt_value
723: from dual;
724:
725: elsif p_field_code = 'FED_POSTING_DATE' then
726: select to_char(sysdate,'YYYYMMDD')
727: into

Line 729: from dual;

725: elsif p_field_code = 'FED_POSTING_DATE' then
726: select to_char(sysdate,'YYYYMMDD')
727: into
728: rt_value
729: from dual;
730:
731: elsif p_field_code = 'FED_ZIP' then
732: rt_value := get_uda_fed_zip(to_number(p_id));
733:

Line 759: FROM DUAL;

755:
756: --Temporately use 'FedBizOpps' as key to match with encryption in NegotiationConfCO.java
757: elsif p_field_code = 'FED_PASSWORD' then
758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value
759: FROM DUAL;
760:
761: end if;
762:
763: if (p_field_code = 'CARRIER_NAME' or p_field_code = 'AMENDMENT_DESCRIPTION') then

Line 1220: || g_newline || ' from dual) AS ' || p_field_code ||'_NM';

1216:
1217: p_query_stmt := p_query_stmt || g_newline || ',cursor (select to_char(' || l_date_value_column || ',''YYYY'') AS "YYYY"'
1218: || g_newline || ' ,to_char(' || l_date_value_column || ',''MM'') AS "MM"'
1219: || g_newline || ' ,to_char(' || l_date_value_column || ',''DD'') AS "DD"'
1220: || g_newline || ' from dual) AS ' || p_field_code ||'_NM';
1221:
1222:
1223: elsif p_datatype = 'DATETIME' then
1224: l_date_value_column := p_value_alias || '.' ||p_value_column;

Line 1234: || g_newline || ' from dual) AS ' || p_field_code ||'_NM';

1230: || g_newline || ' ,to_char(' || l_date_value_column || ',''DD'') AS "DD"'
1231: || g_newline || ' ,to_char(' || l_date_value_column || ',''HH'') AS "HH"'
1232: || g_newline || ' ,to_char(' || l_date_value_column || ',''MI'') AS "MI"'
1233: || g_newline || ' ,to_char(' || l_date_value_column || ',''SS'') AS "SS"'
1234: || g_newline || ' from dual) AS ' || p_field_code ||'_NM';
1235: elsif p_datatype = 'TEXT' then
1236:
1237: if p_value_set_name is null then
1238:

Line 1563: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';

1559: if nvl(r1.LEVEL2_SECTION_code,'#x#') <> nvl(l_prev_section_code,'#x#') then
1560:
1561: if l_prev_section_code is not null then
1562:
1563: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';
1564:
1565: end if;
1566:
1567: l_prev_section_code := r1.LEVEL2_SECTION_code;

Line 1572: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_level1section_code || ' ';

1568:
1569: end if;
1570:
1571: if l_prev_level1section_code is not null then
1572: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_level1section_code || ' ';
1573: end if;
1574:
1575: if r1.LEVEL1_SECTION_CODE is not null then
1576: p_query_stmt := p_query_stmt || g_newline || ' ,cursor (select 1 AS row_num';

Line 1596: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';

1592: l_prev_section_code = '|| l_prev_section_code);
1593:
1594: if l_prev_section_code is not null then
1595:
1596: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';
1597:
1598: end if;
1599:
1600: l_prev_section_code := r1.LEVEL2_SECTION_code;

Line 1698: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';

1694: l_prev_level1section_code = '||l_prev_level1section_code);
1695:
1696: if l_prev_section_code is not null then
1697:
1698: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_section_code || ' ';
1699:
1700: end if;
1701:
1702: if l_prev_level1section_code is not null then

Line 1704: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_level1section_code || ' ';

1700: end if;
1701:
1702: if l_prev_level1section_code is not null then
1703:
1704: p_query_stmt := p_query_stmt || g_newline || ' from dual ) as ' || l_prev_level1section_code || ' ';
1705:
1706: end if;
1707:
1708: print_debug_log(l_api_name, 'Last if : p_query_stmt = '||p_query_stmt);

Line 4311: from dual;

4307: SAVEPOINT post_wf;
4308:
4309: select pon_post_wf_s.nextval
4310: into l_sequence
4311: from dual;
4312:
4313: --get solicitation number
4314: select DOCUMENT_NUMBER into l_solnbr from pon_auction_headers_all where auction_header_id = p_entity_pk1;
4315:

Line 4324: into l_item_key from dual;

4320: AND LANGUAGE = l_curr_lang; -- bug 9855606
4321:
4322: --get item key
4323: select to_char(l_form_name) || '-' ||to_char(l_solnbr) ||'-' ||to_char(l_sequence)
4324: into l_item_key from dual;
4325:
4326: --get sender email
4327: select email_address into l_buyer_email
4328: from WF_LOCAL_ROLES