APPS.HR_ATTACHMENTS_LOADER dependencies on FND_ATTACHMENT_BLOCKS

Line 188: from fnd_attachment_blocks

184: where attachment_function_id=p_attachment_function_id;
185: --
186: cursor block_exists is
187: select attachment_blk_id
188: from fnd_attachment_blocks
189: where block_name=p_block_name
190: and attachment_function_id=p_attachment_function_id;
191: --
192: l_attachment_blk_id NUMBER;

Line 208: select fnd_attachment_blocks_s.nextval

204: fetch block_exists into l_attachment_blk_id;
205: if(block_exists%NOTFOUND) then
206: close block_exists;
207: -- if it doesn't then add it
208: select fnd_attachment_blocks_s.nextval
209: into l_attachment_blk_id
210: from sys.dual;
211: --
212: INSERT INTO fnd_attachment_blocks (

Line 212: INSERT INTO fnd_attachment_blocks (

208: select fnd_attachment_blocks_s.nextval
209: into l_attachment_blk_id
210: from sys.dual;
211: --
212: INSERT INTO fnd_attachment_blocks (
213: attachment_blk_id,
214: attachment_function_id,
215: block_name,
216: query_flag,

Line 250: update fnd_attachment_blocks

246: hr_utility.set_location('Added block '||p_block_name,10);
247: else
248: close block_exists;
249: -- if it does exist then update it
250: update fnd_attachment_blocks
251: set
252: query_flag=p_query_flag,
253: security_type=p_security_type,
254: creation_date=sysdate,

Line 398: from fnd_attachment_blocks

394: ,p_attachment_blk_entity_id OUT NUMBER) is
395: --
396: cursor block_exists is
397: select 1
398: from fnd_attachment_blocks
399: where attachment_blk_id=p_attachment_blk_id;
400: --
401: cursor block_entity_exists is
402: select attachment_blk_entity_id