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.IBE_SHOP_LIST_HEADER_PKG SQL Statements

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

Line: 6


PROCEDURE Insert_Row(
   x_shp_list_id            OUT NOCOPY NUMBER  ,
   p_request_id             IN  NUMBER  ,
   p_program_application_id IN  NUMBER  ,
   p_program_id             IN  NUMBER  ,
   p_program_update_date    IN  DATE    ,
   p_object_version_number  IN  NUMBER  ,
   p_created_by             IN  NUMBER  ,
   p_creation_date          IN  DATE    ,
   p_last_updated_by        IN  NUMBER  ,
   p_last_update_date       IN  DATE    ,
   p_last_update_login      IN  NUMBER  ,
   p_party_id               IN  NUMBER  ,
   p_cust_account_id        IN  NUMBER  ,
   p_shopping_list_name     IN  VARCHAR2,
   p_description            IN  VARCHAR2,
   p_attribute_category     IN  VARCHAR2,
   p_attribute1             IN  VARCHAR2,
   p_attribute2             IN  VARCHAR2,
   p_attribute3             IN  VARCHAR2,
   p_attribute4             IN  VARCHAR2,
   p_attribute5             IN  VARCHAR2,
   p_attribute6             IN  VARCHAR2,
   p_attribute7             IN  VARCHAR2,
   p_attribute8             IN  VARCHAR2,
   p_attribute9             IN  VARCHAR2,
   p_attribute10            IN  VARCHAR2,
   p_attribute11            IN  VARCHAR2,
   p_attribute12            IN  VARCHAR2,
   p_attribute13            IN  VARCHAR2,
   p_attribute14            IN  VARCHAR2,
   p_attribute15            IN  VARCHAR2,
   p_org_id                 IN  NUMBER)
IS
BEGIN
   IF (IBE_UTIL.G_DEBUGON = l_true) THEN
          IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');

Line: 45


   INSERT INTO ibe_sh_shp_lists_all(
      shp_list_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      party_id,
      cust_account_id,
      shopping_list_name,
      description,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      org_id
   )
   VALUES(
      ibe_sh_shp_lists_s1.NEXTVAL,
      DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
      DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
      DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
      DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
      1,
      FND_GLOBAL.User_Id,
      SYSDATE,
      FND_GLOBAL.User_Id,
      SYSDATE,
      FND_GLOBAL.Login_Id,
      p_party_id,
      p_cust_account_id,
      DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
      DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
      DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
      DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
      DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
      DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
      DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
      DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
      DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
      DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
      DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
      DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
      DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
      DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
      DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
      DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
      DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
      DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
      DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
   )
   RETURNING shp_list_id INTO x_shp_list_id;

Line: 115


          IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');

Line: 117


END Insert_Row;

Line: 120


PROCEDURE Update_Row(
   p_shp_list_id            IN NUMBER  ,
   p_request_id             IN NUMBER  ,
   p_program_application_id IN NUMBER  ,
   p_program_id             IN NUMBER  ,
   p_program_update_date    IN DATE    ,
   p_object_version_number  IN NUMBER  ,
   p_created_by             IN NUMBER  ,
   p_creation_date          IN DATE    ,
   p_last_updated_by        IN NUMBER  ,
   p_last_update_date       IN DATE    ,
   p_last_update_login      IN NUMBER  ,
   p_party_id               IN NUMBER  ,
   p_cust_account_id        IN NUMBER  ,
   p_shopping_list_name     IN VARCHAR2,
   p_description            IN VARCHAR2,
   p_attribute_category     IN VARCHAR2,
   p_attribute1             IN VARCHAR2,
   p_attribute2             IN VARCHAR2,
   p_attribute3             IN VARCHAR2,
   p_attribute4             IN VARCHAR2,
   p_attribute5             IN VARCHAR2,
   p_attribute6             IN VARCHAR2,
   p_attribute7             IN VARCHAR2,
   p_attribute8             IN VARCHAR2,
   p_attribute9             IN VARCHAR2,
   p_attribute10            IN VARCHAR2,
   p_attribute11            IN VARCHAR2,
   p_attribute12            IN VARCHAR2,
   p_attribute13            IN VARCHAR2,
   p_attribute14            IN VARCHAR2,
   p_attribute15            IN VARCHAR2,
   p_org_id                 IN NUMBER)
IS
BEGIN
   IF (IBE_UTIL.G_DEBUGON = l_true) THEN
          IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');

Line: 159


   UPDATE ibe_sh_shp_lists_all
   SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
       program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
       program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
       program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
       object_version_number = object_version_number + 1,
       created_by = created_by,
       creation_date = creation_date,
       last_updated_by = FND_GLOBAL.User_Id,
       last_update_date = SYSDATE,
       last_update_login = FND_GLOBAL.Login_Id,
       party_id = party_id,
       cust_account_id = cust_account_id,
       shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
       description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
       attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
       attribute1  = DECODE(p_attribute1,  FND_API.G_MISS_CHAR, attribute1,  p_attribute1),
       attribute2  = DECODE(p_attribute2,  FND_API.G_MISS_CHAR, attribute2,  p_attribute2),
       attribute3  = DECODE(p_attribute3,  FND_API.G_MISS_CHAR, attribute3,  p_attribute3),
       attribute4  = DECODE(p_attribute4,  FND_API.G_MISS_CHAR, attribute4,  p_attribute4),
       attribute5  = DECODE(p_attribute5,  FND_API.G_MISS_CHAR, attribute5,  p_attribute5),
       attribute6  = DECODE(p_attribute6,  FND_API.G_MISS_CHAR, attribute6,  p_attribute6),
       attribute7  = DECODE(p_attribute7,  FND_API.G_MISS_CHAR, attribute7,  p_attribute7),
       attribute8  = DECODE(p_attribute8,  FND_API.G_MISS_CHAR, attribute8,  p_attribute8),
       attribute9  = DECODE(p_attribute9,  FND_API.G_MISS_CHAR, attribute9,  p_attribute9),
       attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
       attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
       attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
       attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
       attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
       attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
       org_id      = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
   WHERE shp_list_id = p_shp_list_id
     AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

Line: 198


          IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');

Line: 200


END Update_Row;

Line: 203


PROCEDURE Delete_Row(
   p_shp_list_id           IN NUMBER,
   p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
IS
BEGIN
   IF (IBE_UTIL.G_DEBUGON = l_true) THEN
          IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');

Line: 212


   DELETE
   FROM ibe_sh_shp_lists_all
   WHERE shp_list_id = p_shp_list_id
     AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

Line: 221


          IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');

Line: 223


END Delete_Row;