APPS.CS_SR_UWQ_NODES_PKG dependencies on CS_SR_UWQ_NODES_B

Line 28: cursor C is select ROWID from CS_SR_UWQ_NODES_B

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from CS_SR_UWQ_NODES_B
29: where NODE_ID = X_NODE_ID
30: ;
31: begin
32: insert into CS_SR_UWQ_NODES_B (

Line 32: insert into CS_SR_UWQ_NODES_B (

28: cursor C is select ROWID from CS_SR_UWQ_NODES_B
29: where NODE_ID = X_NODE_ID
30: ;
31: begin
32: insert into CS_SR_UWQ_NODES_B (
33: NODE_ID,
34: NODE_VIEW,
35: DATA_SOURCE,
36: MEDIA_TYPE_ID,

Line 149: from CS_SR_UWQ_NODES_B

145: CURSOR_KEY_COL,
146: ENABLED_FLAG,
147: OBJECT_VERSION_NUMBER,
148: SECURITY_GROUP_ID
149: from CS_SR_UWQ_NODES_B
150: where NODE_ID = X_NODE_ID
151: for update of NODE_ID nowait;
152: recinfo c%rowtype;
153:

Line 242: update CS_SR_UWQ_NODES_B set

238: X_LAST_UPDATE_LOGIN in NUMBER
239: ) is
240: begin
241:
242: update CS_SR_UWQ_NODES_B set
243: ENABLED_FLAG = X_ENABLED_FLAG
244: where NODE_ID = X_NODE_ID
245: and LAST_UPDATED_BY = X_LAST_UPDATED_BY;
246:

Line 247: update CS_SR_UWQ_NODES_B set

243: ENABLED_FLAG = X_ENABLED_FLAG
244: where NODE_ID = X_NODE_ID
245: and LAST_UPDATED_BY = X_LAST_UPDATED_BY;
246:
247: update CS_SR_UWQ_NODES_B set
248: NODE_VIEW = X_NODE_VIEW,
249: DATA_SOURCE = X_DATA_SOURCE,
250: MEDIA_TYPE_ID = X_MEDIA_TYPE_ID,
251: WHERE_CLAUSE = X_WHERE_CLAUSE,

Line 296: delete from CS_SR_UWQ_NODES_B

292: if (sql%notfound) then
293: raise no_data_found;
294: end if;
295:
296: delete from CS_SR_UWQ_NODES_B
297: where NODE_ID = X_NODE_ID;
298:
299: if (sql%notfound) then
300: raise no_data_found;

Line 310: from CS_SR_UWQ_NODES_B B

306: begin
307: delete from CS_SR_UWQ_NODES_TL T
308: where not exists
309: (select NULL
310: from CS_SR_UWQ_NODES_B B
311: where B.NODE_ID = T.NODE_ID
312: );
313:
314: update CS_SR_UWQ_NODES_TL T set (