APPS.XDP_UTILITIES dependencies on DUAL

Line 754: FROM dual;

750: SELECT DECODE(p_Code, 0, 'IN',
751: 1, 'IN OUT',
752: 2, 'OUT')
753: INTO v_Output
754: FROM dual;
755: */
756: IF p_Code = 0 THEN
757: v_Output := 'IN';
758: ELSIF p_Code = 1 THEN

Line 1343: from dual

1339: BEGIN
1340:
1341: begin
1342: select 'Y' into lv_attr_defined
1343: from dual
1344: where exists(
1345: select 1
1346: from WF_ITEM_ATTRIBUTE_values WIA
1347: where WIA.ITEM_TYPE = p_item_type

Line 1370: into lv_id from dual;

1366: p_item_key,
1367: 'XDP_NUMBER_OF_CHILDREN');
1368:
1369: select XDP_WF_COORDINATION_ID_S.NextVal
1370: into lv_id from dual;
1371:
1372: For lv_child_rec in lc_child loop
1373: begin
1374: select 'N' into lv_error_wf

Line 1375: from dual

1371:
1372: For lv_child_rec in lc_child loop
1373: begin
1374: select 'N' into lv_error_wf
1375: from dual
1376: where not exists(
1377: select 1
1378: from WF_ITEM_ATTRIBUTE_values WIA
1379: where WIA.ITEM_TYPE = lv_child_rec.item_type

Line 1391: from dual

1387: IF lv_error_wf = 'N' THEN
1388: lv_child_count := lv_child_count + 1;
1389: begin
1390: select 'Y' into lv_attr_defined
1391: from dual
1392: where exists(
1393: select 1
1394: from WF_ITEM_ATTRIBUTE_values WIA
1395: where WIA.ITEM_TYPE = lv_child_rec.item_type

Line 1537: select user into lf_owner from dual;

1533: name = lv_pkg_name
1534: order by line;
1535:
1536: BEGIN
1537: select user into lf_owner from dual;
1538:
1539: x_return_code := 0;
1540: lv_ret := FND_INSTALLATION.get_app_info(
1541: 'FND',

Line 1666: select user into lf_owner from dual;

1662: name = p_pkg_name
1663: order by line;
1664: BEGIN
1665:
1666: select user into lf_owner from dual;
1667: x_return_code := 0;
1668: lv_ret := FND_INSTALLATION.get_app_info(
1669: 'FND',
1670: lv1,

Line 2299: select user into lf_owner from dual;

2295: AND name = lv_pkg_name
2296: ORDER BY line;
2297:
2298: BEGIN
2299: select user into lf_owner from dual;
2300:
2301: x_error_code := 0;
2302:
2303: lv_ret := FND_INSTALLATION.get_app_info(