APPS.CS_KB_ASSOC_PKG SQL Statements

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

Line: 21

 |  09-Jul-2003 MKETTLE  Add Insert into SET_CATEGORIES in clone_link   |
 +======================================================================*/


/****************************************************
-------------FUNCTIONS--------------------------------------------------------------------------
****************************************************/
function Clone_Link(
P_SET_SOURCE_ID in NUMBER,
P_SET_TARGET_ID in NUMBER
)return number IS
  l_count number;

Line: 34

    select * from cs_kb_set_platforms
    where set_id = p_set_source_id;

Line: 37

    select * from cs_kb_set_products
    where set_id = p_set_source_id;

Line: 40

    select * from cs_kb_set_categories
    where set_id = p_set_source_id;

Line: 47

  insert into CS_KB_SET_PLATFORMS (
    SET_ID,
    PLATFORM_ID,
    PLATFORM_ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
   ) values (
     P_SET_TARGET_ID,
     REC_PLAT_LINK.PLATFORM_ID,
     REC_PLAT_LINK.PLATFORM_ORG_ID,
     REC_PLAT_LINK.CREATION_DATE,
     REC_PLAT_LINK.CREATED_BY,
     REC_PLAT_LINK.LAST_UPDATE_DATE,
     REC_PLAT_LINK.LAST_UPDATED_BY,
     REC_PLAT_LINK.LAST_UPDATE_LOGIN
   );

Line: 72

  insert into CS_KB_SET_PRODUCTS (
    SET_ID,
    PRODUCT_ID,
    PRODUCT_ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
   ) values (
     P_SET_TARGET_ID,
     REC_PROD_LINK.PRODUCT_ID,
     REC_PROD_LINK.PRODUCT_ORG_ID,
     REC_PROD_LINK.CREATION_DATE,
     REC_PROD_LINK.CREATED_BY,
     REC_PROD_LINK.LAST_UPDATE_DATE,
     REC_PROD_LINK.LAST_UPDATED_BY,
     REC_PROD_LINK.LAST_UPDATE_LOGIN
   );

Line: 96

  insert into CS_KB_SET_CATEGORIES (
    SET_ID,
    CATEGORY_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15

   ) values (
     P_SET_TARGET_ID,
     REC_CAT_LINK.CATEGORY_ID,
     REC_CAT_LINK.CREATION_DATE,
     REC_CAT_LINK.CREATED_BY,
     REC_CAT_LINK.LAST_UPDATE_DATE,
     REC_CAT_LINK.LAST_UPDATED_BY,
     REC_CAT_LINK.LAST_UPDATE_LOGIN,
     REC_CAT_LINK.ATTRIBUTE_CATEGORY,
     REC_CAT_LINK.ATTRIBUTE1,
     REC_CAT_LINK.ATTRIBUTE2,
     REC_CAT_LINK.ATTRIBUTE3,
     REC_CAT_LINK.ATTRIBUTE4,
     REC_CAT_LINK.ATTRIBUTE5,
     REC_CAT_LINK.ATTRIBUTE6,
     REC_CAT_LINK.ATTRIBUTE7,
     REC_CAT_LINK.ATTRIBUTE8,
     REC_CAT_LINK.ATTRIBUTE9,
     REC_CAT_LINK.ATTRIBUTE10,
     REC_CAT_LINK.ATTRIBUTE11,
     REC_CAT_LINK.ATTRIBUTE12,
     REC_CAT_LINK.ATTRIBUTE13,
     REC_CAT_LINK.ATTRIBUTE14,
     REC_CAT_LINK.ATTRIBUTE15
   );

Line: 193

    a_sql VARCHAR2(100) := 'CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) VALUES(:S,:P,:O,:D,:U,:D,:U)';

Line: 208

        sqlStatement := 'DELETE FROM CS_KB_SET_PLATFORMS WHERE SET_ID = :S AND PLATFORM_ID = :P AND PLATFORM_ORG_ID = :O';

Line: 210

        sqlStatement := 'INSERT INTO CS_KB_SET_PLATFORMS(SET_ID,PLATFORM_ID,PLATFORM_ORG_ID,'||a_sql;

Line: 212

        sqlStatement := 'DELETE FROM CS_KB_SET_PRODUCTS WHERE SET_ID = :S AND PRODUCT_ID = :P AND PRODUCT_ORG_ID = :O';

Line: 214

        sqlStatement := 'INSERT INTO CS_KB_SET_PRODUCTS(SET_ID,PRODUCT_ID,PRODUCT_ORG_ID,'||a_sql;