APPS.CS_KB_AUTOLINKS_PKG dependencies on CS_KB_AUTOLINKS_B

Line 53: cursor C is select ROWID from CS_KB_AUTOLINKS_B

49: X_LAST_UPDATE_DATE in DATE,
50: X_LAST_UPDATED_BY in NUMBER,
51: X_LAST_UPDATE_LOGIN in NUMBER
52: ) is
53: cursor C is select ROWID from CS_KB_AUTOLINKS_B
54: where AUTOLINK_ID = X_AUTOLINK_ID
55: ;
56: begin
57: insert into CS_KB_AUTOLINKS_B (

Line 57: insert into CS_KB_AUTOLINKS_B (

53: cursor C is select ROWID from CS_KB_AUTOLINKS_B
54: where AUTOLINK_ID = X_AUTOLINK_ID
55: ;
56: begin
57: insert into CS_KB_AUTOLINKS_B (
58: AUTOLINK_ID,
59: DESTINATION_TYPE,
60: PARAMETER_TYPE,
61: FUNCTION_ID,

Line 271: from CS_KB_AUTOLINKS_B

267: ATTRIBUTE12,
268: ATTRIBUTE13,
269: ATTRIBUTE14,
270: ATTRIBUTE15
271: from CS_KB_AUTOLINKS_B
272: where AUTOLINK_ID = X_AUTOLINK_ID
273: for update of AUTOLINK_ID nowait;
274: recinfo c%rowtype;
275:

Line 432: update CS_KB_AUTOLINKS_B set

428: X_LAST_UPDATED_BY in NUMBER,
429: X_LAST_UPDATE_LOGIN in NUMBER
430: ) is
431: begin
432: update CS_KB_AUTOLINKS_B set
433: DESTINATION_TYPE = X_DESTINATION_TYPE,
434: PARAMETER_TYPE = X_PARAMETER_TYPE,
435: FUNCTION_ID = X_FUNCTION_ID,
436: OPEN_IN_NEW_WINDOW_FLAG = X_OPEN_IN_NEW_WINDOW_FLAG,

Line 507: delete from CS_KB_AUTOLINKS_B

503: if (sql%notfound) then
504: raise no_data_found;
505: end if;
506:
507: delete from CS_KB_AUTOLINKS_B
508: where AUTOLINK_ID = X_AUTOLINK_ID;
509:
510: if (sql%notfound) then
511: raise no_data_found;

Line 521: from CS_KB_AUTOLINKS_B B

517: begin
518: delete from CS_KB_AUTOLINKS_TL T
519: where not exists
520: (select NULL
521: from CS_KB_AUTOLINKS_B B
522: where B.AUTOLINK_ID = T.AUTOLINK_ID
523: );
524:
525: update CS_KB_AUTOLINKS_TL T set (