APPS.PAY_MGB_SHD dependencies on PAY_MAGNETIC_BLOCKS

Line 36: If (p_constraint_name = 'PAY_MAGNETIC_BLOCKS_PK') Then

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

Line 75: from pay_magnetic_blocks

71: main_block_flag,
72: report_format,
73: cursor_name,
74: no_column_returned
75: from pay_magnetic_blocks
76: where magnetic_block_id = p_magnetic_block_id;
77: --
78: l_proc varchar2(72) := g_package||'api_updating';
79: l_fct_ret boolean;

Line 144: from pay_magnetic_blocks

140: main_block_flag,
141: report_format,
142: cursor_name,
143: no_column_returned
144: from pay_magnetic_blocks
145: where magnetic_block_id = p_magnetic_block_id
146: for update nowait;
147: --
148: l_proc varchar2(72) := g_package||'lck';

Line 184: hr_utility.set_message_token('TABLE_NAME', 'pay_magnetic_blocks');

180: -- The object is locked therefore we need to supply a meaningful
181: -- error message.
182: --
183: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
184: hr_utility.set_message_token('TABLE_NAME', 'pay_magnetic_blocks');
185: hr_utility.raise_error;
186: End lck;
187: --
188: -- ----------------------------------------------------------------------------

Line 236: from pay_magnetic_blocks

232: Return number is
233: --
234: cursor csr_magnetic_block_id is
235: select distinct magnetic_block_id
236: from pay_magnetic_blocks
237: where block_name = p_block_name
238: and report_format = p_report_format;
239: --
240: l_proc varchar2(72) := g_package||'get_magnetic_block_id';

Line 241: l_magnetic_block_id PAY_MAGNETIC_BLOCKS.MAGNETIC_BLOCK_ID%TYPE;

237: where block_name = p_block_name
238: and report_format = p_report_format;
239: --
240: l_proc varchar2(72) := g_package||'get_magnetic_block_id';
241: l_magnetic_block_id PAY_MAGNETIC_BLOCKS.MAGNETIC_BLOCK_ID%TYPE;
242: --
243: Begin
244: --
245: hr_utility.set_location('Entering:'||l_proc, 5);