APPS.OTA_CTU_INS dependencies on OTA_CATEGORY_USAGES

Line 87: -- Insert the row into: ota_category_usages

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ota_category_usages
88: --
89:
90: insert into ota_category_usages
91: (category_usage_id

Line 90: insert into ota_category_usages

86: --
87: -- Insert the row into: ota_category_usages
88: --
89:
90: insert into ota_category_usages
91: (category_usage_id
92: ,business_group_id
93: ,category
94: ,object_version_number

Line 228: Cursor C_Sel1 is select ota_category_usages_s.nextval from sys.dual;

224: Procedure pre_insert
225: (p_rec in out nocopy ota_ctu_shd.g_rec_type
226: ) is
227: --
228: Cursor C_Sel1 is select ota_category_usages_s.nextval from sys.dual;
229: --
230: Cursor C_Sel2 is
231: Select null
232: from ota_category_usages

Line 232: from ota_category_usages

228: Cursor C_Sel1 is select ota_category_usages_s.nextval from sys.dual;
229: --
230: Cursor C_Sel2 is
231: Select null
232: from ota_category_usages
233: where category_usage_id =
234: ota_ctu_ins.g_category_usage_id_i;
235: --
236: l_proc varchar2(72) := g_package||'pre_insert';

Line 254: fnd_message.set_token('TABLE_NAME','ota_category_usages');

250: --
251: -- The primary key values are already in use.
252: --
253: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
254: fnd_message.set_token('TABLE_NAME','ota_category_usages');
255: fnd_message.raise_error;
256: End If;
257: Close C_Sel2;
258: --

Line 397: (p_module_name => 'OTA_CATEGORY_USAGES'

393: --
394: when hr_api.cannot_find_prog_unit then
395: --
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'OTA_CATEGORY_USAGES'
398: ,p_hook_type => 'AI');
399: --
400: end;
401: --