eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DELIVERABLES_EXT_B

Line 4955: DELETE FROM OKC_DELIVERABLES_EXT_B

4951: END IF;
4952: -- delete deleverable definitions which are removed from approved business doc
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

Line 4988: DELETE FROM OKC_DELIVERABLES_EXT_B

4984: END IF;
4985: -- delete deleverable definitions which are removed from approved business doc
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

Line 6760: DELETE FROM OKC_DELIVERABLES_EXT_B

6756: IF l_result = 'S' THEN
6757: -- delete deliverables
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;

Line 10579: DELETE FROM OKC_DELIVERABLES_EXT_B

10575: IF l_result = 'S' THEN
10576: -- delete deliverables
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;

Line 10754: DELETE FROM OKC_DELIVERABLES_EXT_B

10750: IF l_result = 'S' THEN
10751: -- delete deliverables
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;

Line 10882: DELETE FROM OKC_DELIVERABLES_EXT_B

10878: IF l_result = 'S' THEN
10879: FOR i IN delIdTab.FIRST..delIdTab.LAST LOOP
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;