APPS.EGO_UPLOAD_PUB SQL Statements

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

Line: 17

  SELECT object_id
  INTO l_object_id
  FROM FND_OBJECTS
  WHERE OBJ_NAME = 'EGO_ITEM';

Line: 32

  SELECT CATALOG_GROUP_ID
  INTO x_catalog_group_id
  from EGO_CATALOG_GROUPS_V
  where catalog_group = p_catalog_group;

Line: 47

  SELECT attr_group_id
  INTO x_attr_group_id
  from ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = p_attr_group_type
   AND  descriptive_flex_context_code = p_attr_group_name
   AND  application_id = 431;

Line: 65

  SELECT association_id
  INTO x_association_id
  FROM EGO_OBJ_AG_ASSOCS_B
  WHERE object_id = p_object_id
   AND  classification_code = TO_CHAR(p_catalog_group_id)
   AND  attr_group_id = p_attr_group_id;

Line: 83

  SELECT page_id
  INTO x_page_id
  FROM EGO_PAGES_B
  WHERE object_id = p_object_id
   AND  classification_code = TO_CHAR(p_catalog_group_id)
   AND  internal_name = p_page_int_name;

Line: 101

  SELECT sequence
  INTO    x_sequence
  FROM ego_page_entries_b
  WHERE page_id = p_page_id
   AND  association_id = p_association_id
   AND  classification_code = TO_CHAR(p_catalog_group_id);

Line: 277

    SELECT user_id, party_id
    INTO l_user_id, l_party_id
    from ego_user_v
    where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);

Line: 287

      SELECT user_id, party_id
      INTO l_user_id, l_party_id
      from ego_user_v
      where user_name = 'MFG';

Line: 300

    l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;

Line: 478

    EGO_EXT_FWK_PUB. Update_Association (
        p_api_version            => p_api_version
       ,p_association_id         => x_association_id
       ,p_enabled_flag           => p_enabled_flag
       ,p_view_privilege_id      => NULL    --ignored for now
       ,p_edit_privilege_id      => NULL     --ignored for now
--       ,p_init_msg_list                 IN   VARCHAR2   :=  fnd_api.g_FALSE
       ,p_commit                  => p_commit
       ,x_return_status           => x_return_status
       ,x_errorcode               => l_errorcode
       ,x_msg_count               => x_msg_count
       ,x_msg_data                => x_msg_data
       );

Line: 563

    EGO_EXT_FWK_PUB.Update_Page (
        p_api_version             => p_api_version
       ,p_page_id                 => x_page_id
       ,p_internal_name           => p_page_int_name
       ,p_display_name            => p_name
       ,p_description             => p_desc
       ,p_sequence                => p_sequence
--       ,p_init_msg_list                 IN   VARCHAR2   :=  fnd_api.g_FALSE
       ,p_commit                  => p_commit
--       ,p_is_nls_mode                   IN   VARCHAR2   DEFAULT FND_API.G_FALSE
       ,x_return_status           => x_return_status
       ,x_errorcode               => l_errorcode
       ,x_msg_count               => x_msg_count
       ,x_msg_data                => x_msg_data
       );

Line: 684

    EGO_EXT_FWK_PUB.Update_Page_Entry (
        p_api_version             => p_api_version
       ,p_page_id                 => l_page_id
       ,p_new_association_id      => l_association_id
       ,p_old_association_id      => l_association_id
       ,p_sequence                => p_sequence
--       ,p_init_msg_list                 IN   VARCHAR2   :=  fnd_api.g_FALSE
       ,p_commit                  => p_commit
       ,x_return_status           => x_return_status
       ,x_errorcode               => l_errorcode
       ,x_msg_count               => x_msg_count
       ,x_msg_data                => x_msg_data
       );