APPS.PSP_POA_SHD dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 32: If (p_constraint_name = 'PSP_ORGANIZATION_ACCOUNTS_U1') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PSP_ORGANIZATION_ACCOUNTS_U1') 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;

Line 94: from psp_organization_accounts

90: ,poeta_start_date
91: ,poeta_end_date
92: ,object_version_number
93: ,funding_source_code
94: from psp_organization_accounts
95: where organization_account_id = p_organization_account_id;
96: --
97: l_fct_ret boolean;
98: --

Line 193: from psp_organization_accounts

189: ,poeta_start_date
190: ,poeta_end_date
191: ,object_version_number
192: ,funding_source_code
193: from psp_organization_accounts
194: where organization_account_id = p_organization_account_id
195: for update nowait;
196: --
197: l_proc varchar2(72) := g_package||'lck';

Line 242: fnd_message.set_token('TABLE_NAME', 'psp_organization_accounts');

238: -- The object is locked therefore we need to supply a meaningful
239: -- error message.
240: --
241: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
242: fnd_message.set_token('TABLE_NAME', 'psp_organization_accounts');
243: fnd_message.raise_error;
244: End lck;
245: --
246: -- ----------------------------------------------------------------------------