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 671: FROM dual;

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

Line 804: FROM dual

800:
801: BEGIN
802: SELECT 1
803: INTO l_incorrect_price_exists
804: FROM dual
805: WHERE EXISTS (SELECT cis.organization_id
806: FROM cst_item_costs cis,
807: org_organization_definitions ood
808: WHERE cis.organization_id = ood.organization_id

Line 826: FROM dual

822: IF NVL(l_incorrect_price_exists,0) = 0 THEN
823: BEGIN
824: SELECT 1
825: INTO l_incorrect_price_exists
826: FROM dual
827: WHERE EXISTS (SELECT cql.organization_id
828: FROM cst_quantity_layers cql,
829: org_organization_definitions ood
830: WHERE cql.organization_id = ood.organization_id

Line 1540: FROM DUAL;

1536: x_return_status := l_return_status;
1537:
1538: SELECT DECODE(l_return_status,FND_API.G_RET_STS_SUCCESS,'SUCCESS','WARNING')
1539: INTO l_execution_status
1540: FROM DUAL;
1541:
1542: BEGIN
1543: IF g_debug THEN
1544: DPP_UTILITY_PVT.debug_message('Status before generating output xml: ' || l_return_status);

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

1554: NewPrice NEWPRICE,
1555: Currency CURRENCY,
1556: Reason_For_Failure REASON
1557: from DPP_OUTPUT_XML_GT
1558: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1559: ELSE
1560: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1561: END IF;
1562:

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

1556: Reason_For_Failure REASON
1557: from DPP_OUTPUT_XML_GT
1558: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1559: ELSE
1560: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1561: END IF;
1562:
1563: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1564: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);