APPS.CS_KB_ASSOC_PKG dependencies on CS_KB_SET_PRODUCTS

Line 37: select * from cs_kb_set_products

33: cursor plat_link_csr is
34: select * from cs_kb_set_platforms
35: where set_id = p_set_source_id;
36: cursor prod_link_csr is
37: select * from cs_kb_set_products
38: where set_id = p_set_source_id;
39: cursor cat_link_csr is
40: select * from cs_kb_set_categories
41: where set_id = p_set_source_id;

Line 72: insert into CS_KB_SET_PRODUCTS (

68: end loop;
69:
70: for rec_prod_link in prod_link_csr loop
71:
72: insert into CS_KB_SET_PRODUCTS (
73: SET_ID,
74: PRODUCT_ID,
75: PRODUCT_ORG_ID,
76: CREATION_DATE,

Line 170: -- 1 = CS_KB_SET_PRODUCTS

166: -- variables are as follows:
167: --
168: -- P_LINK_TYPE:
169: -- 0 = CS_KB_SET_PLATFORMS
170: -- 1 = CS_KB_SET_PRODUCTS
171: --
172: -- P_TASK:
173: -- 0 = REMOVE
174: -- 1 = ADD

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

208: sqlStatement := 'DELETE FROM CS_KB_SET_PLATFORMS WHERE SET_ID = :S AND PLATFORM_ID = :P AND PLATFORM_ORG_ID = :O';
209: ELSIF (p_link_type = 0) AND (p_task = 1) THEN
210: sqlStatement := 'INSERT INTO CS_KB_SET_PLATFORMS(SET_ID,PLATFORM_ID,PLATFORM_ORG_ID,'||a_sql;
211: ELSIF (p_link_type = 1) AND (p_task = 0) THEN
212: sqlStatement := 'DELETE FROM CS_KB_SET_PRODUCTS WHERE SET_ID = :S AND PRODUCT_ID = :P AND PRODUCT_ORG_ID = :O';
213: ELSIF (p_link_type = 1) AND (p_task = 1) THEN
214: sqlStatement := 'INSERT INTO CS_KB_SET_PRODUCTS(SET_ID,PRODUCT_ID,PRODUCT_ORG_ID,'||a_sql;
215: END IF;
216:

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

210: sqlStatement := 'INSERT INTO CS_KB_SET_PLATFORMS(SET_ID,PLATFORM_ID,PLATFORM_ORG_ID,'||a_sql;
211: ELSIF (p_link_type = 1) AND (p_task = 0) THEN
212: sqlStatement := 'DELETE FROM CS_KB_SET_PRODUCTS WHERE SET_ID = :S AND PRODUCT_ID = :P AND PRODUCT_ORG_ID = :O';
213: ELSIF (p_link_type = 1) AND (p_task = 1) THEN
214: sqlStatement := 'INSERT INTO CS_KB_SET_PRODUCTS(SET_ID,PRODUCT_ID,PRODUCT_ORG_ID,'||a_sql;
215: END IF;
216:
217: IF (sqlStatement is not null) THEN
218: length := p_item_id.COUNT;