APPS.PAY_EXA_SHD dependencies on PAY_EXTERNAL_ACCOUNTS

Line 37: If (p_constraint_name = 'PAY_EXTERNAL_ACCOUNTS_PK') Then

33: --
34: begin
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'PAY_EXTERNAL_ACCOUNTS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;

Line 105: FROM PAY_EXTERNAL_ACCOUNTS

101: segment28,
102: segment29,
103: segment30,
104: object_version_number
105: FROM PAY_EXTERNAL_ACCOUNTS
106: WHERE external_account_id = p_external_account_id
107: ;
108: --
109: l_proc varchar2(72) := g_package||'api_updating';

Line 219: from pay_external_accounts

215: segment28,
216: segment29,
217: segment30,
218: object_version_number
219: from pay_external_accounts
220: where external_account_id = p_external_account_id
221: for update nowait;
222: --
223: l_proc varchar2(72) := g_package||'lck';

Line 262: hr_utility.set_message_token('TABLE_NAME', 'pay_external_accounts');

258: -- The object is locked therefore we need to supply a meaningful
259: -- error message.
260: --
261: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
262: hr_utility.set_message_token('TABLE_NAME', 'pay_external_accounts');
263: hr_utility.raise_error;
264: end lck;
265: --
266: -- ----------------------------------------------------------------------------

Line 413: l_id_flex_num pay_external_accounts.id_flex_num%type;

409: ) is
410: --
411: l_proc varchar2(72) := g_package||'keyflex_comb';
412: --
413: l_id_flex_num pay_external_accounts.id_flex_num%type;
414: --
415: -- the cursor orgsel selects the valid id_flex_num (external account kf)
416: -- for the specified business group
417: --