APPS.BSC_KPI_TREE_NODES_PKG dependencies on BSC_KPI_TREE_NODES_B

Line 20: cursor C is select ROWID from BSC_KPI_TREE_NODES_B

16: X_NAME in VARCHAR2,
17: X_HELP in VARCHAR2,
18: X_Y_AXIS_TITLE IN VARCHAR
19: ) is
20: cursor C is select ROWID from BSC_KPI_TREE_NODES_B
21: where INDICATOR = X_INDICATOR
22: and NODE_ID = X_NODE_ID
23: ;
24: begin

Line 25: insert into BSC_KPI_TREE_NODES_B (

21: where INDICATOR = X_INDICATOR
22: and NODE_ID = X_NODE_ID
23: ;
24: begin
25: insert into BSC_KPI_TREE_NODES_B (
26: INDICATOR,
27: NODE_ID,
28: SIMULATE_FLAG,
29: FORMAT_ID,

Line 111: from BSC_KPI_TREE_NODES_B

107: TOP_POSITION,
108: LEFT_POSITION,
109: WIDTH,
110: HEIGHT
111: from BSC_KPI_TREE_NODES_B
112: where INDICATOR = X_INDICATOR
113: and NODE_ID = X_NODE_ID
114: for update of INDICATOR nowait;
115: recinfo c%rowtype;

Line 183: update BSC_KPI_TREE_NODES_B set

179: X_HELP in VARCHAR2,
180: X_Y_AXIS_TITLE IN VARCHAR
181: ) is
182: begin
183: update BSC_KPI_TREE_NODES_B set
184: SIMULATE_FLAG = X_SIMULATE_FLAG,
185: FORMAT_ID = X_FORMAT_ID,
186: COLOR_FLAG = X_COLOR_FLAG,
187: COLOR_METHOD = X_COLOR_METHOD,

Line 227: delete from BSC_KPI_TREE_NODES_B

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from BSC_KPI_TREE_NODES_B
228: where INDICATOR = X_INDICATOR
229: and NODE_ID = X_NODE_ID;
230:
231: if (sql%notfound) then

Line 242: from BSC_KPI_TREE_NODES_B B

238: begin
239: delete from BSC_KPI_TREE_NODES_TL T
240: where not exists
241: (select NULL
242: from BSC_KPI_TREE_NODES_B B
243: where B.INDICATOR = T.INDICATOR
244: and B.NODE_ID = T.NODE_ID
245: );
246: