APPS.DPP_ITEMCOST_PVT dependencies on DUAL

Line 44: Into STime From Sys.Dual;

40: begin
41: if ( max_wait > 0 ) then
42: Time_Out := TRUE;
43: Select To_Number(((To_Char(Sysdate, 'J') - 1 ) * 86400) + To_Char(Sysdate, 'SSSss'))
44: Into STime From Sys.Dual;
45: end if;
46:
47: LOOP
48:

Line 68: Into ETime From Sys.Dual;

64: end if;
65:
66: if ( Time_Out ) then
67: Select To_Number(((To_Char(Sysdate, 'J') - 1 ) * 86400) + To_Char(Sysdate, 'SSSss'))
68: Into ETime From Sys.Dual;
69:
70: if ( (ETime - STime) >= max_wait ) then
71: call_status := FALSE;
72: return (call_status);

Line 669: FROM dual;

665: END;
666:
667: SELECT dpp_cst_group_id_seq.nextval
668: INTO l_import_cost_group_id
669: FROM dual;
670:
671: SELECT count(*)
672: INTO l_bom_installed
673: FROM bom_parameters

Line 800: FROM dual

796:
797: BEGIN
798: SELECT 1
799: INTO l_incorrect_price_exists
800: FROM dual
801: WHERE EXISTS (SELECT cis.organization_id
802: FROM cst_item_costs cis,
803: org_organization_definitions ood
804: WHERE cis.organization_id = ood.organization_id

Line 822: FROM dual

818: IF NVL(l_incorrect_price_exists,0) = 0 THEN
819: BEGIN
820: SELECT 1
821: INTO l_incorrect_price_exists
822: FROM dual
823: WHERE EXISTS (SELECT cql.organization_id
824: FROM cst_quantity_layers cql,
825: org_organization_definitions ood
826: WHERE cql.organization_id = ood.organization_id

Line 1502: FROM DUAL;

1498: x_return_status := l_return_status;
1499:
1500: SELECT DECODE(l_return_status,FND_API.G_RET_STS_SUCCESS,'SUCCESS','WARNING')
1501: INTO l_execution_status
1502: FROM DUAL;
1503:
1504: BEGIN
1505: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status before generating output xml: ' || l_return_status);
1506:

Line 1518: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');

1514: NewPrice NEWPRICE,
1515: Currency CURRENCY,
1516: Reason_For_Failure REASON
1517: from DPP_OUTPUT_XML_GT
1518: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1519: ELSE
1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;
1522:

Line 1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');

1516: Reason_For_Failure REASON
1517: from DPP_OUTPUT_XML_GT
1518: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1519: ELSE
1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;
1522:
1523: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1524: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);