APPS.HXC_DRU_SHD dependencies on HXC_DATA_APP_RULE_USAGES

Line 33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;

Line 38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then

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

Line 43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then

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

Line 48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then

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

Line 81: from hxc_data_app_rule_usages

77: ,approval_style_id
78: ,time_entry_rule_id
79: ,time_recipient_id
80: ,object_version_number
81: from hxc_data_app_rule_usages
82: where data_app_rule_usage_id = p_data_app_rule_usage_id;
83: --
84: l_fct_ret boolean;
85: --

Line 151: from hxc_data_app_rule_usages

147: ,approval_style_id
148: ,time_entry_rule_id
149: ,time_recipient_id
150: ,object_version_number
151: from hxc_data_app_rule_usages
152: where data_app_rule_usage_id = p_data_app_rule_usage_id
153: for update nowait;
154: --
155: l_proc varchar2(72);

Line 200: fnd_message.set_token('TABLE_NAME', 'hxc_data_app_rule_usages');

196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'hxc_data_app_rule_usages');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------