APPS.OTA_NHS_SHD dependencies on OTA_NOTRNG_HISTORIES

Line 36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');

Line 39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then

35: --
36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');

Line 42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then

38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');

Line 116: from ota_notrng_histories

112: business_group_id,
113: nth_information14,
114: customer_id,
115: organization_id
116: from ota_notrng_histories
117: where nota_history_id = p_nota_history_id;
118: --
119: l_proc varchar2(72) := g_package||'api_updating';
120: l_fct_ret boolean;

Line 226: from ota_notrng_histories

222: business_group_id,
223: nth_information14,
224: customer_id,
225: organization_id
226: from ota_notrng_histories
227: where nota_history_id = p_nota_history_id
228: for update nowait;
229: --
230: l_proc varchar2(72) := g_package||'lck';

Line 269: hr_utility.set_message_token('TABLE_NAME', 'ota_notrng_histories');

265: -- The object is locked therefore we need to supply a meaningful
266: -- error message.
267: --
268: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
269: hr_utility.set_message_token('TABLE_NAME', 'ota_notrng_histories');
270: hr_utility.raise_error;
271: End lck;
272: --
273: -- ----------------------------------------------------------------------------