APPS.BSC_TAB_IND_GROUPS_PKG dependencies on BSC_TAB_IND_GROUPS_B

Line 18: cursor C is select ROWID from BSC_TAB_IND_GROUPS_B

14: X_HEIGHT in NUMBER,
15: X_NAME in VARCHAR2,
16: X_HELP in VARCHAR2
17: ) is
18: cursor C is select ROWID from BSC_TAB_IND_GROUPS_B
19: where TAB_ID = X_TAB_ID
20: and CSF_ID = X_CSF_ID
21: and IND_GROUP_ID = X_IND_GROUP_ID
22: ;

Line 24: insert into BSC_TAB_IND_GROUPS_B (

20: and CSF_ID = X_CSF_ID
21: and IND_GROUP_ID = X_IND_GROUP_ID
22: ;
23: begin
24: insert into BSC_TAB_IND_GROUPS_B (
25: TAB_ID,
26: CSF_ID,
27: IND_GROUP_ID,
28: GROUP_TYPE,

Line 106: from BSC_TAB_IND_GROUPS_B

102: LEFT_POSITION,
103: TOP_POSITION,
104: WIDTH,
105: HEIGHT
106: from BSC_TAB_IND_GROUPS_B
107: where TAB_ID = X_TAB_ID
108: and CSF_ID = X_CSF_ID
109: and IND_GROUP_ID = X_IND_GROUP_ID
110: for update of TAB_ID nowait;

Line 185: update BSC_TAB_IND_GROUPS_B set

181: X_NAME in VARCHAR2,
182: X_HELP in VARCHAR2
183: ) is
184: begin
185: update BSC_TAB_IND_GROUPS_B set
186: GROUP_TYPE = X_GROUP_TYPE,
187: NAME_POSITION = X_NAME_POSITION,
188: NAME_JUSTIFICATION = X_NAME_JUSTIFICATION,
189: LEFT_POSITION = X_LEFT_POSITION,

Line 230: delete from BSC_TAB_IND_GROUPS_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from BSC_TAB_IND_GROUPS_B
231: where TAB_ID = X_TAB_ID
232: and CSF_ID = X_CSF_ID
233: and IND_GROUP_ID = X_IND_GROUP_ID;
234:

Line 246: from BSC_TAB_IND_GROUPS_B B

242: begin
243: delete from BSC_TAB_IND_GROUPS_TL T
244: where not exists
245: (select NULL
246: from BSC_TAB_IND_GROUPS_B B
247: where B.TAB_ID = T.TAB_ID
248: and B.CSF_ID = T.CSF_ID
249: and B.IND_GROUP_ID = T.IND_GROUP_ID
250: );