APPS.BSC_USER_PARAMETERS_PKG dependencies on BSC_USER_PARAMETERS_B

Line 33: cursor C is select PARAM_LIST_ID from BSC_USER_PARAMETERS_B

29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31:
32: l_param_list_id number;
33: cursor C is select PARAM_LIST_ID from BSC_USER_PARAMETERS_B
34: where PARAM_LIST_ID = l_param_list_id;
35: begin
36:
37: select BSC_USER_PARAM_LIST_ID_S.nextval

Line 44: insert into BSC_USER_PARAMETERS_B (

40: --dbms_output.put_line('PARAM_LIST_ID =' || l_param_list_id);
41: -- decode(X_VIEW_TYPE, 1, 1, 0),
42: -- decode(X_VALID_FLAG, 1, 1, 0),
43:
44: insert into BSC_USER_PARAMETERS_B (
45: PARAM_LIST_ID,
46: APPLICATION_ID,
47: INDICATOR,
48: VIEW_TYPE,

Line 165: update BSC_USER_PARAMETERS_B set

161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: begin
165: update BSC_USER_PARAMETERS_B set
166: APPLICATION_ID = X_APPLICATION_ID,
167: INDICATOR = X_INDICATOR,
168: VIEW_TYPE = X_VIEW_TYPE,
169: VALID_FLAG = X_VALID_FLAG,

Line 213: delete from BSC_USER_PARAMETERS_B

209: procedure DELETE_ROW (
210: X_PARAM_LIST_ID in NUMBER
211: ) is
212: begin
213: delete from BSC_USER_PARAMETERS_B
214: where PARAM_LIST_ID = X_PARAM_LIST_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 235: from BSC_USER_PARAMETERS_B B

231: begin
232: delete from BSC_USER_PARAMETERS_TL T
233: where not exists
234: (select NULL
235: from BSC_USER_PARAMETERS_B B
236: where B.PARAM_LIST_ID = T.PARAM_LIST_ID
237: );
238:
239: update BSC_USER_PARAMETERS_TL T set (