APPS.OTA_ACI_SHD dependencies on OTA_ACT_CAT_INCLUSIONS

Line 37: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then

33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 42: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then

38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;

Line 47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then

43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;

Line 113: from ota_act_cat_inclusions

109: ,start_date_active
110: ,end_date_active
111: ,primary_flag
112: ,category_usage_id
113: from ota_act_cat_inclusions
114: where activity_version_id = p_activity_version_id
115: and category_usage_id = p_category_usage_id;
116: --
117: l_fct_ret boolean;

Line 213: from ota_act_cat_inclusions

209: ,start_date_active
210: ,end_date_active
211: ,primary_flag
212: ,category_usage_id
213: from ota_act_cat_inclusions
214: where activity_version_id = p_activity_version_id
215: and category_usage_id = p_category_usage_id
216: for update nowait;
217: --

Line 269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');

265: -- The object is locked therefore we need to supply a meaningful
266: -- error message.
267: --
268: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');
270: fnd_message.raise_error;
271: End lck;
272: --
273: -- ----------------------------------------------------------------------------