APPS.OTA_AR_DELETE dependencies on OTA_FINANCE_HEADERS

Line 60: from ota_finance_headers

56: where customer_id = p_customer_id;
57: --
58: cursor c_finance_headers1 is
59: select null
60: from ota_finance_headers
61: where customer_id = p_customer_id;
62: --
63: cursor c_finance_headers2 is
64: select null

Line 65: from ota_finance_headers

61: where customer_id = p_customer_id;
62: --
63: cursor c_finance_headers2 is
64: select null
65: from ota_finance_headers
66: where contact_id = p_contact_id
67: and customer_id is not null;
68: --
69: cursor c_finance_headers3 is

Line 71: from ota_finance_headers

67: and customer_id is not null;
68: --
69: cursor c_finance_headers3 is
70: select null
71: from ota_finance_headers
72: where address_id = p_address_id
73: and customer_id is not null;
74: --
75: begin

Line 134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

130: fetch c_finance_headers1 into l_exists;
131: if c_finance_headers1%found then
132: close c_finance_headers1;
133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
135: fnd_message.set_token('COLUMN','CUSTOMER_ID');
136: fnd_message.raise_error;
137: end if;
138: close c_finance_headers1;

Line 184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

180: fetch c_finance_headers2 into l_exists;
181: if c_finance_headers2%found then
182: close c_finance_headers2;
183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
185: fnd_message.set_token('COLUMN','CONTACT_ID');
186: fnd_message.raise_error;
187: end if;
188: close c_finance_headers2;

Line 222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

218: fetch c_finance_headers3 into l_exists;
219: if c_finance_headers3%found then
220: close c_finance_headers3;
221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
223: fnd_message.set_token('COLUMN','ADDRESS_ID');
224: fnd_message.raise_error;
225: end if;
226: close c_finance_headers3;