APPS.OTA_PMM_SHD dependencies on OTA_PROGRAM_MEMBERSHIPS

Line 39: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then

35: --
36: If (p_constraint_name = 'OTA_PMM_REQUIRED_FLAG_CHK') Then
37: hr_utility.set_message(801, 'OTA_13423_PMM_REQUIRED_FLAG');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
40: hr_utility.set_message(801, 'OTA_13424_PMM_NO_EVENT');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK2') Then
43: hr_utility.set_message(801, 'OTA_13425_PMM_NO_PROGRAM');

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

38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
40: hr_utility.set_message(801, 'OTA_13424_PMM_NO_EVENT');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK2') Then
43: hr_utility.set_message(801, 'OTA_13425_PMM_NO_PROGRAM');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_PK') Then
46: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

Line 45: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_PK') Then

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK2') Then
43: hr_utility.set_message(801, 'OTA_13425_PMM_NO_PROGRAM');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_PK') Then
46: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
47: hr_utility.raise_error;
48: Else
49: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 102: from ota_program_memberships

98: pmm_information17,
99: pmm_information18,
100: pmm_information19,
101: pmm_information20
102: from ota_program_memberships
103: where program_membership_id = p_program_membership_id;
104: --
105: l_proc varchar2(72) := g_package||'api_updating';
106: l_fct_ret boolean;

Line 201: from ota_program_memberships

197: pmm_information17,
198: pmm_information18,
199: pmm_information19,
200: pmm_information20
201: from ota_program_memberships
202: where program_membership_id = p_program_membership_id
203: for update nowait;
204: --
205: l_proc varchar2(72) := g_package||'lck';

Line 244: hr_utility.set_message_token('TABLE_NAME', 'ota_program_memberships');

240: -- The object is locked therefore we need to supply a meaningful
241: -- error message.
242: --
243: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
244: hr_utility.set_message_token('TABLE_NAME', 'ota_program_memberships');
245: hr_utility.raise_error;
246: End lck;
247: --
248: -- ----------------------------------------------------------------------------