APPS.OTA_OFF_SHD dependencies on OTA_OFFERINGS

Line 22: If (p_constraint_name = 'OTA_OFFERINGS_FK1') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'OTA_OFFERINGS_FK1') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 27: ElsIf (p_constraint_name = 'OTA_OFFERINGS_PK') Then

23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'OTA_OFFERINGS_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 80: ota_offerings.offering_id

76: -- Cursor selects the 'current' row from the HR Schema
77: --
78: Cursor C_Sel1 is
79: select
80: ota_offerings.offering_id
81: ,activity_version_id
82: ,business_group_id
83:
84: ,start_date

Line 130: from ota_offerings

126: ,data_source
127: ,vendor_id
128: ,competency_update_level
129: ,language_code -- 2733966
130: from ota_offerings
131: where ota_offerings.offering_id = p_offering_id;
132:
133: --
134: l_fct_ret boolean;

Line 131: where ota_offerings.offering_id = p_offering_id;

127: ,vendor_id
128: ,competency_update_level
129: ,language_code -- 2733966
130: from ota_offerings
131: where ota_offerings.offering_id = p_offering_id;
132:
133: --
134: l_fct_ret boolean;
135: --

Line 246: from ota_offerings

242: ,data_source
243: ,vendor_id
244: ,competency_update_level
245: ,language_code -- 2733966
246: from ota_offerings
247: where offering_id = p_offering_id
248:
249: for update nowait;
250: --

Line 297: fnd_message.set_token('TABLE_NAME', 'ota_offerings');

293: -- The object is locked therefore we need to supply a meaningful
294: -- error message.
295: --
296: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
297: fnd_message.set_token('TABLE_NAME', 'ota_offerings');
298: fnd_message.raise_error;
299: End lck;
300: --
301: -- ----------------------------------------------------------------------------