DBA Data[Home] [Help]

APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_MAGNETIC_BLOCKS

Line 911: -- This procedure uploads a single row into pay_magnetic_blocks

907: -- |------------------------------< load_mgb_row >----------------------------|
908: -- ----------------------------------------------------------------------------
909: --
910: -- Description:
911: -- This procedure uploads a single row into pay_magnetic_blocks
912: -- table. If the row being uploaded already exists in the table then the
913: -- row is only updated with the new values else the row is inserted.
914: --
915: -- ----------------------------------------------------------------------------

Line 926: l_magnetic_block_id PAY_MAGNETIC_BLOCKS.MAGNETIC_BLOCK_ID%TYPE;

922: --
923: l_proc varchar2(72) := g_package||'load_mgb_row';
924: l_rec PAY_MGB_SHD.G_REC_TYPE;
925: l_exists varchar2 (1);
926: l_magnetic_block_id PAY_MAGNETIC_BLOCKS.MAGNETIC_BLOCK_ID%TYPE;
927: --
928: cursor csr_exists is
929: select null
930: from pay_magnetic_blocks

Line 930: from pay_magnetic_blocks

926: l_magnetic_block_id PAY_MAGNETIC_BLOCKS.MAGNETIC_BLOCK_ID%TYPE;
927: --
928: cursor csr_exists is
929: select null
930: from pay_magnetic_blocks
931: where magnetic_block_id = l_magnetic_block_id;
932:
933: --
934: BEGIN