DBA Data[Home] [Help]

APPS.HXC_HDP_SHD dependencies on HXC_DEPOSIT_PROCESSES

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

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_DEPOSIT_PROCESSES_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 = 'HXC_DEPOSIT_PROCESSES_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 = 'HXC_DEPOSIT_PROCESSES_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 60: from hxc_deposit_processes

56: ,name
57: ,time_source_id
58: ,mapping_id
59: ,object_version_number
60: from hxc_deposit_processes
61: where deposit_process_id = p_deposit_process_id;
62: --
63: l_fct_ret boolean;
64: --

Line 130: from hxc_deposit_processes

126: ,name
127: ,time_source_id
128: ,mapping_id
129: ,object_version_number
130: from hxc_deposit_processes
131: where deposit_process_id = p_deposit_process_id
132: for update nowait;
133: --
134: l_proc varchar2(72);

Line 179: fnd_message.set_token('TABLE_NAME', 'hxc_deposit_processes');

175: -- The object is locked therefore we need to supply a meaningful
176: -- error message.
177: --
178: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
179: fnd_message.set_token('TABLE_NAME', 'hxc_deposit_processes');
180: fnd_message.raise_error;
181: End lck;
182: --
183: -- ----------------------------------------------------------------------------