APPS.BSC_SYS_MM_CONTROLS_PKG dependencies on BSC_SYS_MM_CONTROLS_TL

Line 10: cursor C is select ROWID from BSC_SYS_MM_CONTROLS_TL

6: X_COMMAND in VARCHAR2,
7: X_NAME in VARCHAR2,
8: X_HELP in VARCHAR2
9: ) is
10: cursor C is select ROWID from BSC_SYS_MM_CONTROLS_TL
11: where BUTTON_ID = X_BUTTON_ID
12: and LANGUAGE = userenv('LANG')
13: ;
14: begin

Line 15: insert into BSC_SYS_MM_CONTROLS_TL (

11: where BUTTON_ID = X_BUTTON_ID
12: and LANGUAGE = userenv('LANG')
13: ;
14: begin
15: insert into BSC_SYS_MM_CONTROLS_TL (
16: BUTTON_ID,
17: NAME,
18: HELP,
19: COMMAND,

Line 33: from BSC_SYS_MM_CONTROLS_TL T

29: from FND_LANGUAGES L
30: where L.INSTALLED_FLAG in ('I', 'B')
31: and not exists
32: (select NULL
33: from BSC_SYS_MM_CONTROLS_TL T
34: where T.BUTTON_ID = X_BUTTON_ID
35: and T.LANGUAGE = L.LANGUAGE_CODE);
36:
37: open c;

Line 58: from BSC_SYS_MM_CONTROLS_TL

54: COMMAND,
55: NAME,
56: HELP,
57: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
58: from BSC_SYS_MM_CONTROLS_TL
59: where BUTTON_ID = X_BUTTON_ID
60: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
61: for update of BUTTON_ID nowait;
62: begin

Line 87: update BSC_SYS_MM_CONTROLS_TL set

83: X_NAME in VARCHAR2,
84: X_HELP in VARCHAR2
85: ) is
86: begin
87: update BSC_SYS_MM_CONTROLS_TL set
88: COMMAND = X_COMMAND,
89: NAME = X_NAME,
90: HELP = X_HELP,
91: SOURCE_LANG = userenv('LANG')

Line 104: delete from BSC_SYS_MM_CONTROLS_TL

100: procedure DELETE_ROW (
101: X_BUTTON_ID in NUMBER
102: ) is
103: begin
104: delete from BSC_SYS_MM_CONTROLS_TL
105: where BUTTON_ID = X_BUTTON_ID;
106:
107: if (sql%notfound) then
108: raise no_data_found;

Line 116: update BSC_SYS_MM_CONTROLS_TL T set (

112:
113: procedure ADD_LANGUAGE
114: is
115: begin
116: update BSC_SYS_MM_CONTROLS_TL T set (
117: NAME,
118: HELP
119: ) = (select
120: B.NAME,

Line 122: from BSC_SYS_MM_CONTROLS_TL B

118: HELP
119: ) = (select
120: B.NAME,
121: B.HELP
122: from BSC_SYS_MM_CONTROLS_TL B
123: where B.BUTTON_ID = T.BUTTON_ID
124: and B.LANGUAGE = T.SOURCE_LANG)
125: where (
126: T.BUTTON_ID,

Line 131: from BSC_SYS_MM_CONTROLS_TL SUBB, BSC_SYS_MM_CONTROLS_TL SUBT

127: T.LANGUAGE
128: ) in (select
129: SUBT.BUTTON_ID,
130: SUBT.LANGUAGE
131: from BSC_SYS_MM_CONTROLS_TL SUBB, BSC_SYS_MM_CONTROLS_TL SUBT
132: where SUBB.BUTTON_ID = SUBT.BUTTON_ID
133: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
134: and (SUBB.NAME <> SUBT.NAME
135: or SUBB.HELP <> SUBT.HELP

Line 138: insert into BSC_SYS_MM_CONTROLS_TL (

134: and (SUBB.NAME <> SUBT.NAME
135: or SUBB.HELP <> SUBT.HELP
136: ));
137:
138: insert into BSC_SYS_MM_CONTROLS_TL (
139: BUTTON_ID,
140: NAME,
141: HELP,
142: COMMAND,

Line 152: from BSC_SYS_MM_CONTROLS_TL B, FND_LANGUAGES L

148: B.HELP,
149: B.COMMAND,
150: L.LANGUAGE_CODE,
151: B.SOURCE_LANG
152: from BSC_SYS_MM_CONTROLS_TL B, FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and B.LANGUAGE = userenv('LANG')
155: and not exists
156: (select NULL

Line 157: from BSC_SYS_MM_CONTROLS_TL T

153: where L.INSTALLED_FLAG in ('I', 'B')
154: and B.LANGUAGE = userenv('LANG')
155: and not exists
156: (select NULL
157: from BSC_SYS_MM_CONTROLS_TL T
158: where T.BUTTON_ID = B.BUTTON_ID
159: and T.LANGUAGE = L.LANGUAGE_CODE);
160: end ADD_LANGUAGE;
161: