APPS.OTA_AP_DELETE dependencies on OTA_FINANCE_HEADERS

Line 30: from ota_finance_headers

26: where vendor_id = p_vendor_id;
27: --
28: cursor c_finance_headers1 is
29: select null
30: from ota_finance_headers
31: where vendor_id = p_vendor_id;
32: --
33: cursor c_finance_headers2 is
34: select null

Line 35: from ota_finance_headers

31: where vendor_id = p_vendor_id;
32: --
33: cursor c_finance_headers2 is
34: select null
35: from ota_finance_headers
36: where contact_id = p_contact_id
37: and vendor_id is not null;
38: --
39: cursor c_finance_headers3 is

Line 41: from ota_finance_headers

37: and vendor_id is not null;
38: --
39: cursor c_finance_headers3 is
40: select null
41: from ota_finance_headers
42: where address_id = p_vendor_site_id
43: and vendor_id is not null;
44: --
45: begin

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

88: fetch c_finance_headers1 into l_exists;
89: if c_finance_headers1%found then
90: close c_finance_headers1;
91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
93: fnd_message.set_token('COLUMN','CUSTOMER_ID');
94: fnd_message.raise_error;
95: end if;
96: close c_finance_headers1;

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

102: fetch c_finance_headers2 into l_exists;
103: if c_finance_headers2%found then
104: close c_finance_headers2;
105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');
106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
107: fnd_message.set_token('COLUMN','CONTACT_ID');
108: fnd_message.raise_error;
109: end if;
110: close c_finance_headers2;

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

116: fetch c_finance_headers3 into l_exists;
117: if c_finance_headers3%found then
118: close c_finance_headers3;
119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');
120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
121: fnd_message.set_token('COLUMN','ADDRESS_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_finance_headers3;