APPS.BSC_TAB_CSF_PKG dependencies on BSC_TAB_CSF_B

Line 12: cursor C is select ROWID from BSC_TAB_CSF_B

8: X_INTERMEDIATE_FLAG in NUMBER,
9: X_NAME in VARCHAR2,
10: X_HELP in VARCHAR2
11: ) is
12: cursor C is select ROWID from BSC_TAB_CSF_B
13: where TAB_ID = X_TAB_ID
14: and CSF_ID = X_CSF_ID
15: ;
16: begin

Line 17: insert into BSC_TAB_CSF_B (

13: where TAB_ID = X_TAB_ID
14: and CSF_ID = X_CSF_ID
15: ;
16: begin
17: insert into BSC_TAB_CSF_B (
18: TAB_ID,
19: CSF_ID,
20: CSF_TYPE,
21: INTERMEDIATE_FLAG

Line 73: from BSC_TAB_CSF_B

69: ) is
70: cursor c is select
71: CSF_TYPE,
72: INTERMEDIATE_FLAG
73: from BSC_TAB_CSF_B
74: where TAB_ID = X_TAB_ID
75: and CSF_ID = X_CSF_ID
76: for update of TAB_ID nowait;
77: recinfo c%rowtype;

Line 133: update BSC_TAB_CSF_B set

129: X_NAME in VARCHAR2,
130: X_HELP in VARCHAR2
131: ) is
132: begin
133: update BSC_TAB_CSF_B set
134: CSF_TYPE = X_CSF_TYPE,
135: INTERMEDIATE_FLAG = X_INTERMEDIATE_FLAG
136: where TAB_ID = X_TAB_ID
137: and CSF_ID = X_CSF_ID;

Line 169: delete from BSC_TAB_CSF_B

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: delete from BSC_TAB_CSF_B
170: where TAB_ID = X_TAB_ID
171: and CSF_ID = X_CSF_ID;
172:
173: if (sql%notfound) then

Line 184: from BSC_TAB_CSF_B B

180: begin
181: delete from BSC_TAB_CSF_TL T
182: where not exists
183: (select NULL
184: from BSC_TAB_CSF_B B
185: where B.TAB_ID = T.TAB_ID
186: and B.CSF_ID = T.CSF_ID
187: );
188: