APPS.BSC_SYS_DIM_LEVELS_PKG dependencies on BSC_SYS_DIM_LEVELS_B

Line 20: cursor C is select ROWID from BSC_SYS_DIM_LEVELS_B

16: X_HELP in VARCHAR2,
17: X_TOTAL_DISP_NAME in VARCHAR2,
18: X_COMP_DISP_NAME in VARCHAR2
19: ) is
20: cursor C is select ROWID from BSC_SYS_DIM_LEVELS_B
21: where DIM_LEVEL_ID = X_DIM_LEVEL_ID
22: ;
23: begin
24: insert into BSC_SYS_DIM_LEVELS_B (

Line 24: insert into BSC_SYS_DIM_LEVELS_B (

20: cursor C is select ROWID from BSC_SYS_DIM_LEVELS_B
21: where DIM_LEVEL_ID = X_DIM_LEVEL_ID
22: ;
23: begin
24: insert into BSC_SYS_DIM_LEVELS_B (
25: DIM_LEVEL_ID,
26: LEVEL_TABLE_NAME,
27: TABLE_TYPE,
28: LEVEL_PK_COL,

Line 108: from BSC_SYS_DIM_LEVELS_B

104: COMP_ORDER_BY,
105: CUSTOM_GROUP,
106: USER_KEY_SIZE,
107: DISP_KEY_SIZE
108: from BSC_SYS_DIM_LEVELS_B
109: where DIM_LEVEL_ID = X_DIM_LEVEL_ID
110: for update of DIM_LEVEL_ID nowait;
111: recinfo c%rowtype;
112:

Line 184: update BSC_SYS_DIM_LEVELS_B set

180: X_TOTAL_DISP_NAME in VARCHAR2,
181: X_COMP_DISP_NAME in VARCHAR2
182: ) is
183: begin
184: update BSC_SYS_DIM_LEVELS_B set
185: LEVEL_TABLE_NAME = X_LEVEL_TABLE_NAME,
186: TABLE_TYPE = X_TABLE_TYPE,
187: LEVEL_PK_COL = X_LEVEL_PK_COL,
188: ABBREVIATION = X_ABBREVIATION,

Line 225: delete from BSC_SYS_DIM_LEVELS_B

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: delete from BSC_SYS_DIM_LEVELS_B
226: where DIM_LEVEL_ID = X_DIM_LEVEL_ID;
227:
228: if (sql%notfound) then
229: raise no_data_found;

Line 239: from BSC_SYS_DIM_LEVELS_B B

235: begin
236: delete from BSC_SYS_DIM_LEVELS_TL T
237: where not exists
238: (select NULL
239: from BSC_SYS_DIM_LEVELS_B B
240: where B.DIM_LEVEL_ID = T.DIM_LEVEL_ID
241: );
242:
243: update BSC_SYS_DIM_LEVELS_TL T set (