eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_AMV_ATTACHMENT_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30


   l_sql := 'SELECT COUNT(*) FROM ' || p_table_name;

Line: 53


   l_sql := 'SELECT COUNT(*) FROM ' || p_table_name;

Line: 82


   l_sql := 'SELECT COUNT(*) FROM ' || p_lookup_table_name;

Line: 322


SELECT jtf_amv_attachments_s.NEXTVAL
FROM DUAL;

Line: 326


SELECT COUNT(*)
FROM jtf_amv_attachments
WHERE attachment_id = act_attachment_id;

Line: 331


SELECT deliverable_type_code
FROM   jtf_amv_items_b
WHERE  item_id = p_item_id;

Line: 418


   INSERT INTO jtf_amv_attachments
   (
      attachment_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      object_version_number,
      owner_user_id,
      attachment_used_by_id,
      attachment_used_by,
      version,
      enabled_flag,
      can_fulfill_electronic_flag,
      file_id,
      file_name,
      file_extension,
      document_id,
      keywords,
      display_width,
      display_height,
      display_location,
      link_to,
      link_URL,
      send_for_preview_flag,
      attachment_type,
      language_code,
      application_id,
      description,
      default_style_sheet,
      display_url,
      display_rule_id,
      display_program,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
	 display_text,
	 alternate_text,
         secured_flag,
	 attachment_sub_type
      )
	 VALUES (
      l_act_attachment_rec.attachment_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.conc_login_id,
      1,  -- object_version_number
      l_act_attachment_rec.owner_user_id,
      l_act_attachment_rec.attachment_used_by_id,
      l_act_attachment_rec.attachment_used_by,
      l_act_attachment_rec.version,
      NVL(l_act_attachment_rec.enabled_flag, 'Y'),
      NVL(l_act_attachment_rec.can_fulfill_electronic_flag, 'N'),
      l_act_attachment_rec.file_id,
      l_act_attachment_rec.file_name,
      l_act_attachment_rec.file_extension,
      l_act_attachment_rec.document_id,
      l_act_attachment_rec.keywords,
      l_act_attachment_rec.display_width,
      l_act_attachment_rec.display_height,
      l_act_attachment_rec.display_location,
      l_act_attachment_rec.link_to,
      l_act_attachment_rec.link_URL,
      l_act_attachment_rec.send_for_preview_flag,
      l_act_attachment_rec.attachment_type,
      l_act_attachment_rec.language_code,
      l_act_attachment_rec.application_id,
      l_act_attachment_rec.description,
      l_act_attachment_rec.default_style_sheet,
      l_act_attachment_rec.display_url,
      l_act_attachment_rec.display_rule_id,
      l_act_attachment_rec.display_program,
      l_act_attachment_rec.attribute_category,
      l_act_attachment_rec.attribute1,
      l_act_attachment_rec.attribute2,
      l_act_attachment_rec.attribute3,
      l_act_attachment_rec.attribute4,
      l_act_attachment_rec.attribute5,
      l_act_attachment_rec.attribute6,
      l_act_attachment_rec.attribute7,
      l_act_attachment_rec.attribute8,
      l_act_attachment_rec.attribute9,
      l_act_attachment_rec.attribute10,
      l_act_attachment_rec.attribute11,
      l_act_attachment_rec.attribute12,
      l_act_attachment_rec.attribute13,
      l_act_attachment_rec.attribute14,
      l_act_attachment_rec.attribute15,
      l_act_attachment_rec.display_text,
      l_act_attachment_rec.alternate_text,
      l_act_attachment_rec.secured_flag,
      l_act_attachment_rec.attachment_sub_type
   );

Line: 528


       update jtf_amv_items_b
       set last_update_date = sysdate,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.conc_login_id
       where item_id = l_act_attachment_rec.attachment_used_by_id ;

Line: 584


PROCEDURE delete_act_attachment
(
  p_api_version          IN  NUMBER,
  p_init_msg_list        IN  VARCHAR2 := FND_API.g_false,
  p_commit               IN  VARCHAR2 := FND_API.g_false,
  x_return_status        OUT NOCOPY  VARCHAR2,
  x_msg_count            OUT NOCOPY  NUMBER,
  x_msg_data             OUT NOCOPY  VARCHAR2,
  p_act_attachment_id    IN  NUMBER,
  p_object_version       IN  NUMBER
) AS
l_api_version CONSTANT NUMBER       := 1.0;

Line: 596


l_api_name    CONSTANT VARCHAR2(30) := 'delete_act_attachment';

Line: 600


   SAVEPOINT delete_act_attachment;

Line: 615


   DELETE FROM jtf_amv_attachments
   WHERE attachment_id = p_act_attachment_id
   AND object_version_number = p_object_version;

Line: 640


      ROLLBACK TO delete_act_attachment;

Line: 649


      ROLLBACK TO delete_act_attachment;

Line: 658


      ROLLBACK TO delete_act_attachment;

Line: 670


END delete_act_attachment;

Line: 681


PROCEDURE update_act_attachment
(
  p_api_version          IN  NUMBER,
  p_init_msg_list        IN  VARCHAR2 := FND_API.g_false,
  p_commit               IN  VARCHAR2 := FND_API.g_false,
  p_validation_level     IN  NUMBER   := FND_API.g_valid_level_full,

  x_return_status        OUT NOCOPY  VARCHAR2,
  x_msg_count            OUT NOCOPY  NUMBER,
  x_msg_data             OUT NOCOPY  VARCHAR2,

  p_act_attachment_rec   IN  act_attachment_rec_type
) AS
l_api_version CONSTANT NUMBER := 1.0;

Line: 695


l_api_name    CONSTANT VARCHAR2(30) := 'update_act_attachment';

Line: 700


SELECT deliverable_type_code
FROM   jtf_amv_items_b
WHERE  item_id = p_item_id;

Line: 707


   SAVEPOINT update_act_attachment;

Line: 727


         p_validation_mode    => JTF_PLSQL_API.g_update,
         x_return_status      => l_return_status
      );

Line: 789


   UPDATE jtf_amv_attachments SET
      last_update_date = SYSDATE,
      last_updated_by = FND_GLOBAL.user_id,
      last_update_login = FND_GLOBAL.conc_login_id,
      object_version_number = l_act_attachment_rec.object_version_number + 1,
      owner_user_id = l_act_attachment_rec.owner_user_id,
      attachment_used_by_id = l_act_attachment_rec.attachment_used_by_id,
      attachment_used_by = l_act_attachment_rec.attachment_used_by,
      version = l_act_attachment_rec.version,
      enabled_flag = l_act_attachment_rec.enabled_flag,
      can_fulfill_electronic_flag =
          l_act_attachment_rec.can_fulfill_electronic_flag,
      file_id = l_act_attachment_rec.file_id,
      file_name = l_act_attachment_rec.file_name,
      file_extension = l_act_attachment_rec.file_extension,
      document_id = l_act_attachment_rec.document_id,
      keywords = l_act_attachment_rec.keywords,
      display_width = l_act_attachment_rec.display_width,
      display_height = l_act_attachment_rec.display_height,
      display_location = l_act_attachment_rec.display_location,
      link_to = l_act_attachment_rec.link_to,
      link_url = l_act_attachment_rec.link_url,
      send_for_preview_flag = l_act_attachment_rec.send_for_preview_flag,
      attachment_type = l_act_attachment_rec.attachment_type,
      language_code = l_act_attachment_rec.language_code,
      application_id = l_act_attachment_rec.application_id,
      description = l_act_attachment_rec.description,
      default_style_sheet = l_act_attachment_rec.default_style_sheet,
      display_rule_id = l_act_attachment_rec.display_rule_id,
      display_url = l_act_attachment_rec.display_url,
      display_program = l_act_attachment_rec.display_program,
      attribute_category = l_act_attachment_rec.attribute_category,
      attribute1  = l_act_attachment_rec.attribute1,
      attribute2  = l_act_attachment_rec.attribute2,
      attribute3  = l_act_attachment_rec.attribute3,
      attribute4  = l_act_attachment_rec.attribute4,
      attribute5  = l_act_attachment_rec.attribute5,
      attribute6  = l_act_attachment_rec.attribute6,
      attribute7  = l_act_attachment_rec.attribute7,
      attribute8  = l_act_attachment_rec.attribute8,
      attribute9  = l_act_attachment_rec.attribute9,
      attribute10 = l_act_attachment_rec.attribute10,
      attribute11 = l_act_attachment_rec.attribute11,
      attribute12 = l_act_attachment_rec.attribute12,
      attribute13 = l_act_attachment_rec.attribute13,
      attribute14 = l_act_attachment_rec.attribute14,
      attribute15 = l_act_attachment_rec.attribute15,
	 display_text = l_act_attachment_rec.display_text,
	 alternate_text = l_act_attachment_rec.alternate_text,
	 secured_flag = l_act_attachment_rec.secured_flag,
	 attachment_sub_type = l_act_attachment_rec.attachment_sub_type
   WHERE attachment_id = l_act_attachment_rec.attachment_id
   AND object_version_number = l_act_attachment_rec.object_version_number;

Line: 852


       update jtf_amv_items_b
       set last_update_date = sysdate,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.conc_login_id
       where item_id = l_act_attachment_rec.attachment_used_by_id;

Line: 873


      ROLLBACK TO update_act_attachment;

Line: 883


      ROLLBACK TO update_act_attachment;

Line: 893


      ROLLBACK TO update_act_attachment;

Line: 904


END update_act_attachment;

Line: 930


SELECT attachment_id
  FROM jtf_amv_attachments
 WHERE attachment_id = p_act_attachment_id
   AND object_version_number = p_object_version
   FOR UPDATE OF attachment_id NOWAIT;

Line: 1211


   x_act_attachment_rec.last_update_date      := FND_API.g_miss_date;

Line: 1212


   x_act_attachment_rec.last_updated_by       := FND_API.g_miss_num;

Line: 1215


   x_act_attachment_rec.last_update_login     := FND_API.g_miss_num;

Line: 1279


SELECT *
FROM jtf_amv_attachments
WHERE attachment_id = p_act_attachment_rec.attachment_id;