APPS.WIP_WS_UTIL dependencies on DUAL

Line 209: from dual;

205: end if;
206:
207: select to_char(l_c_start_date, 'HH24:MI:SS')
208: into l_c_from_time
209: from dual;
210:
211: select to_char(l_c_end_date, 'HH24:MI:SS')
212: into l_c_to_time
213: from dual;

Line 213: from dual;

209: from dual;
210:
211: select to_char(l_c_end_date, 'HH24:MI:SS')
212: into l_c_to_time
213: from dual;
214:
215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);

Line 1546: from dual

1542: for pref_attach in pref_attach_source(l_level_id) loop
1543: if pref_attach.attribute_value_code = g_att_src_discrete_job then
1544: begin
1545: select 1 into l_attach_count
1546: from dual
1547: where exists (select 1
1548: from FND_ATTACHED_DOCUMENTS
1549: where entity_name = 'WIP_DISCRETE_JOBS'
1550: and pk1_value = p_job_id

Line 1561: from dual

1557: end;
1558: elsif pref_attach.attribute_value_code = g_att_src_job_operation then
1559: begin
1560: select 1 into l_attach_count
1561: from dual
1562: where exists (select 1
1563: from FND_ATTACHED_DOCUMENTS
1564: where entity_name = 'WIP_DISCRETE_OPERATIONS'
1565: and pk1_value = p_job_id

Line 1577: from dual

1573: end;
1574: elsif pref_attach.attribute_value_code = g_att_src_assembly_item then
1575: begin
1576: select 1 into l_attach_count
1577: from dual
1578: where exists (select 1
1579: from FND_ATTACHED_DOCUMENTS fad,
1580: wip_entities we
1581: where fad.entity_name = 'MTL_SYSTEM_ITEMS'

Line 1595: from dual

1591: end;
1592: elsif pref_attach.attribute_value_code = g_att_src_bill_header then
1593: begin
1594: select 1 into l_attach_count
1595: from dual
1596: where exists (select 1
1597: from FND_ATTACHED_DOCUMENTS fad,
1598: wip_discrete_jobs wdj
1599: where fad.entity_name = 'BOM_BILL_OF_MATERIALS'

Line 1612: from dual

1608: end;
1609: elsif pref_attach.attribute_value_code = g_att_src_rtg_header then
1610: begin
1611: select 1 into l_attach_count
1612: from dual
1613: where exists (select 1
1614: from FND_ATTACHED_DOCUMENTS fad,
1615: wip_discrete_jobs wdj
1616: where fad.entity_name = 'BOM_OPERATIONAL_ROUTINGS'

Line 1629: from dual

1625: end;
1626: elsif pref_attach.attribute_value_code = g_att_src_bill_comps then
1627: begin
1628: select 1 into l_attach_count
1629: from dual
1630: where exists (select 1
1631: from FND_ATTACHED_DOCUMENTS fad
1632: where fad.entity_name = 'MTL_SYSTEM_ITEMS'
1633: and pk1_value = p_org_id

Line 1648: from dual

1644: end;
1645: elsif pref_attach.attribute_value_code = g_att_src_so_header then
1646: begin
1647: select 1 into l_attach_count
1648: from dual
1649: where exists (select 1
1650: from FND_ATTACHED_DOCUMENTS fad
1651: where fad.entity_name = 'OE_ORDER_HEADERS'
1652: and pk1_value IN ( select header_id

Line 1670: from dual

1666: end;
1667: elsif pref_attach.attribute_value_code = g_att_src_so_line then
1668: begin
1669: select 1 into l_attach_count
1670: from dual
1671: where exists (select 1
1672: from FND_ATTACHED_DOCUMENTS fad
1673: where fad.entity_name = 'OE_ORDER_LINES'
1674: and pk1_value IN ( select mr.demand_source_line_id

Line 1735: from dual;

1731: end if;
1732:
1733: select to_char(l_shift_date, WIP_CONSTANTS.DATETIME_FMT)
1734: into l_result
1735: from dual;
1736: else
1737: l_result := null;
1738: end if;
1739:

Line 1793: from dual;

1789: and we.organization_id = p_org_id;
1790:
1791: select to_char(l_c_clock_date, WIP_CONSTANTS.DATETIME_FMT)
1792: into l_clock_desc
1793: from dual;
1794:
1795: select wip_ws_util.get_jobop_name(l_job_name, l_op_seq)
1796: into l_job_desc
1797: from dual;

Line 1797: from dual;

1793: from dual;
1794:
1795: select wip_ws_util.get_jobop_name(l_job_name, l_op_seq)
1796: into l_job_desc
1797: from dual;
1798:
1799: l_result := l_job_desc || ', ' || l_clock_desc;
1800: --if no clocked in record return null
1801: else