17:
18: l_msg := 'INV_LOC_INTERORG_SHIP_METHODS';
19: select 'Y'
20: into v_delete_permitted
21: from sys.dual
22: where not exists (
23:
24: select null
25: from MTL_INTERORG_SHIP_METHODS
30:
31: l_msg := 'INV_LOC_TRANSACTIONS_TEMP';
32: select 'Y'
33: into v_delete_permitted
34: from sys.dual
35: where not exists (
36:
37: select null
38: from MTL_MATERIAL_TRANSACTIONS_TEMP
42:
43: l_msg := 'INV_LOC_MOVEMENT_PARAMTERS';
44: select 'Y'
45: into v_delete_permitted
46: from sys.dual
47: where not exists (
48:
49: select null
50: from MTL_MOVEMENT_PARAMETERS
56:
57: l_msg := 'INV_LOC_REPLENISH_HEADERS';
58: select 'Y'
59: into v_delete_permitted
60: from sys.dual
61: where not exists (
62:
63: select null
64: from MTL_REPLENISH_HEADERS
68:
69: l_msg := 'INV_LOC_REPLENISH_HEADERS_INT';
70: select 'Y'
71: into v_delete_permitted
72: from sys.dual
73: where not exists (
74:
75: select null
76: from MTL_REPLENISH_HEADERS_INT
80:
81: l_msg := 'INV_LOC_MTL_SUPPLY';
82: select 'Y'
83: into v_delete_permitted
84: from sys.dual
85: where not exists (
86:
87: select null
88: from MTL_SUPPLY
95:
96: l_msg := 'INV_LOC_TRANSACTION_INTERFACE';
97: select 'Y'
98: into v_delete_permitted
99: from sys.dual
100: where not exists (
101:
102: select null
103: from MTL_TRANSACTIONS_INTERFACE