APPS.CS_KB_ASSOC_PKG dependencies on CS_KB_SET_PLATFORMS

Line 34: select * from cs_kb_set_platforms

30: P_SET_TARGET_ID in NUMBER
31: )return number IS
32: l_count number;
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;

Line 47: insert into CS_KB_SET_PLATFORMS (

43: BEGIN
44:
45: for rec_plat_link in plat_link_csr loop
46:
47: insert into CS_KB_SET_PLATFORMS (
48: SET_ID,
49: PLATFORM_ID,
50: PLATFORM_ORG_ID,
51: CREATION_DATE,

Line 169: -- 0 = CS_KB_SET_PLATFORMS

165: -- Because this procedure is flexible, it require a couple of flags. Those
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

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

204: BEGIN
205: p_result := 1;
206: -- Getting table name
207: IF (p_link_type = 0) AND (p_task = 0) THEN
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';

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

206: -- Getting table name
207: IF (p_link_type = 0) AND (p_task = 0) THEN
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;