DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DELIVERABLES_EXT_TL

Line 4957: DELETE FROM OKC_DELIVERABLES_EXT_TL

4953: delete from okc_deliverables
4954: where deliverable_id = def_rec.deliverable_id;
4955: DELETE FROM OKC_DELIVERABLES_EXT_B
4956: WHERE deliverable_id = def_rec.deliverable_id;
4957: DELETE FROM OKC_DELIVERABLES_EXT_TL
4958: WHERE deliverable_id = def_rec.deliverable_id;
4959: ELSE
4960: -- clear all amendment attributes but
4961: -- don't clear last_amendment_date this is needed for PO change History

Line 4990: DELETE FROM OKC_DELIVERABLES_EXT_TL

4986: delete from okc_deliverables
4987: where deliverable_id = def_rec.deliverable_id;
4988: DELETE FROM OKC_DELIVERABLES_EXT_B
4989: WHERE deliverable_id = def_rec.deliverable_id;
4990: DELETE FROM OKC_DELIVERABLES_EXT_TL
4991: WHERE deliverable_id = def_rec.deliverable_id;
4992: ELSE
4993: -- clear only amendment_operation
4994: UPDATE okc_deliverables SET amendment_operation = null,

Line 6762: DELETE FROM OKC_DELIVERABLES_EXT_TL

6758: DELETE FROM okc_deliverables
6759: WHERE deliverable_id = delIdTab(i);
6760: DELETE FROM OKC_DELIVERABLES_EXT_B
6761: WHERE deliverable_id = delIdTab(i);
6762: DELETE FROM OKC_DELIVERABLES_EXT_TL
6763: WHERE deliverable_id = delIdTab(i);
6764: END IF;
6765:
6766:

Line 10581: DELETE FROM OKC_DELIVERABLES_EXT_TL

10577: DELETE FROM okc_deliverables
10578: WHERE deliverable_id = l_del_id;
10579: DELETE FROM OKC_DELIVERABLES_EXT_B
10580: WHERE deliverable_id = l_del_id;
10581: DELETE FROM OKC_DELIVERABLES_EXT_TL
10582: WHERE deliverable_id = l_del_id;
10583: END IF;
10584: x_return_status := l_return_status;
10585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 10756: DELETE FROM OKC_DELIVERABLES_EXT_TL

10752: DELETE FROM okc_deliverables
10753: WHERE deliverable_id = p_del_id;
10754: DELETE FROM OKC_DELIVERABLES_EXT_B
10755: WHERE deliverable_id = p_del_id;
10756: DELETE FROM OKC_DELIVERABLES_EXT_TL
10757: WHERE deliverable_id = p_del_id;
10758: END IF;
10759: x_return_status := l_result;
10760: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 10884: DELETE FROM OKC_DELIVERABLES_EXT_TL

10880: DELETE FROM okc_deliverables
10881: WHERE deliverable_id = delIdTab(i);
10882: DELETE FROM OKC_DELIVERABLES_EXT_B
10883: WHERE deliverable_id = delIdTab(i);
10884: DELETE FROM OKC_DELIVERABLES_EXT_TL
10885: WHERE deliverable_id = delIdTab(i);
10886: END LOOP;
10887: END IF;
10888: END IF;-- delIdTab.COUNT