APPS.WIP_WS_UTIL dependencies on WIP_DISCRETE_JOBS

Line 645: update wip_discrete_jobs wdj

641: FND_MSG_PUB.initialize;
642: END IF;
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: update wip_discrete_jobs wdj
646: set wdj.job_note = wdj.job_note || p_msg
647: where wdj.wip_entity_id = p_wip_entity_id;
648:
649: exception when others then

Line 676: from wip_discrete_jobs wdj

672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: select wdj.job_note
675: into job_note
676: from wip_discrete_jobs wdj
677: where wdj.wip_entity_id = p_wip_entity_id
678: for update;
679:
680: dbms_lob.append(job_note, p_clob_msg);

Line 1549: where entity_name = 'WIP_DISCRETE_JOBS'

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
1551: and pk2_value = p_org_id
1552: and rownum = 1);
1553: exit;

Line 1598: wip_discrete_jobs wdj

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'
1600: and fad.pk1_value = wdj.common_bom_sequence_id
1601: and wdj.wip_entity_id = p_job_id
1602: and wdj.organization_id = p_org_id

Line 1615: wip_discrete_jobs wdj

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'
1617: and fad.pk1_value = wdj.common_routing_sequence_id
1618: and wdj.wip_entity_id = p_job_id
1619: and wdj.organization_id = p_org_id