APPS.HR_ATTACHMENTS_LOADER dependencies on FND_ATTACHMENT_BLK_ENTITIES

Line 403: from fnd_attachment_blk_entities

399: where attachment_blk_id=p_attachment_blk_id;
400: --
401: cursor block_entity_exists is
402: select attachment_blk_entity_id
403: from fnd_attachment_blk_entities
404: where data_object_code=p_data_object_code
405: and attachment_blk_id=p_attachment_blk_id;
406: --
407: l_attachment_blk_entity_id NUMBER;

Line 422: select fnd_attachment_blk_entities_s.nextval

418: fetch block_entity_exists into l_attachment_blk_entity_id;
419: if(block_entity_exists%NOTFOUND) then
420: close block_entity_exists;
421: -- if it is not then add it
422: select fnd_attachment_blk_entities_s.nextval
423: into l_attachment_blk_entity_id
424: from sys.dual;
425: --
426: INSERT INTO fnd_attachment_blk_entities (

Line 426: INSERT INTO fnd_attachment_blk_entities (

422: select fnd_attachment_blk_entities_s.nextval
423: into l_attachment_blk_entity_id
424: from sys.dual;
425: --
426: INSERT INTO fnd_attachment_blk_entities (
427: attachment_blk_entity_id,
428: attachment_blk_id,
429: data_object_code,
430: display_method,

Line 482: update fnd_attachment_blk_entities

478: p_attachment_blk_entity_id:=l_attachment_blk_entity_id;
479: else
480: close block_entity_exists;
481: -- if already exists then update it
482: update fnd_attachment_blk_entities
483: set
484: display_method=p_display_method,
485: include_in_indicator_flag=p_include_in_indicator_flag,
486: indicator_in_view_flag=p_indicator_in_view_flag,