APPS.BSC_KPI_SHELL_CMDS_PKG dependencies on BSC_KPI_SHELL_CMDS_TL

Line 10: cursor C is select ROWID from BSC_KPI_SHELL_CMDS_TL

6: X_SHELL_CMD_ID in NUMBER,
7: X_COMMAND in VARCHAR2,
8: X_NAME in VARCHAR2
9: ) is
10: cursor C is select ROWID from BSC_KPI_SHELL_CMDS_TL
11: where INDICATOR = X_INDICATOR
12: and SHELL_CMD_ID = X_SHELL_CMD_ID
13: and LANGUAGE = userenv('LANG')
14: ;

Line 16: insert into BSC_KPI_SHELL_CMDS_TL (

12: and SHELL_CMD_ID = X_SHELL_CMD_ID
13: and LANGUAGE = userenv('LANG')
14: ;
15: begin
16: insert into BSC_KPI_SHELL_CMDS_TL (
17: INDICATOR,
18: SHELL_CMD_ID,
19: NAME,
20: COMMAND,

Line 34: from BSC_KPI_SHELL_CMDS_TL T

30: from FND_LANGUAGES L
31: where L.INSTALLED_FLAG in ('I', 'B')
32: and not exists
33: (select NULL
34: from BSC_KPI_SHELL_CMDS_TL T
35: where T.INDICATOR = X_INDICATOR
36: and T.SHELL_CMD_ID = X_SHELL_CMD_ID
37: and T.LANGUAGE = L.LANGUAGE_CODE);
38:

Line 59: from BSC_KPI_SHELL_CMDS_TL

55: cursor c1 is select
56: COMMAND,
57: NAME,
58: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
59: from BSC_KPI_SHELL_CMDS_TL
60: where INDICATOR = X_INDICATOR
61: and SHELL_CMD_ID = X_SHELL_CMD_ID
62: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
63: for update of INDICATOR nowait;

Line 88: update BSC_KPI_SHELL_CMDS_TL set

84: X_COMMAND in VARCHAR2,
85: X_NAME in VARCHAR2
86: ) is
87: begin
88: update BSC_KPI_SHELL_CMDS_TL set
89: COMMAND = X_COMMAND,
90: NAME = X_NAME,
91: SOURCE_LANG = userenv('LANG')
92: where INDICATOR = X_INDICATOR

Line 106: delete from BSC_KPI_SHELL_CMDS_TL

102: X_INDICATOR in NUMBER,
103: X_SHELL_CMD_ID in NUMBER
104: ) is
105: begin
106: delete from BSC_KPI_SHELL_CMDS_TL
107: where INDICATOR = X_INDICATOR
108: and SHELL_CMD_ID = X_SHELL_CMD_ID;
109:
110: if (sql%notfound) then

Line 119: update BSC_KPI_SHELL_CMDS_TL T set (

115:
116: procedure ADD_LANGUAGE
117: is
118: begin
119: update BSC_KPI_SHELL_CMDS_TL T set (
120: NAME
121: ) = (select
122: B.NAME
123: from BSC_KPI_SHELL_CMDS_TL B

Line 123: from BSC_KPI_SHELL_CMDS_TL B

119: update BSC_KPI_SHELL_CMDS_TL T set (
120: NAME
121: ) = (select
122: B.NAME
123: from BSC_KPI_SHELL_CMDS_TL B
124: where B.INDICATOR = T.INDICATOR
125: and B.SHELL_CMD_ID = T.SHELL_CMD_ID
126: and B.LANGUAGE = T.SOURCE_LANG)
127: where (

Line 135: from BSC_KPI_SHELL_CMDS_TL SUBB, BSC_KPI_SHELL_CMDS_TL SUBT

131: ) in (select
132: SUBT.INDICATOR,
133: SUBT.SHELL_CMD_ID,
134: SUBT.LANGUAGE
135: from BSC_KPI_SHELL_CMDS_TL SUBB, BSC_KPI_SHELL_CMDS_TL SUBT
136: where SUBB.INDICATOR = SUBT.INDICATOR
137: and SUBB.SHELL_CMD_ID = SUBT.SHELL_CMD_ID
138: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
139: and (SUBB.NAME <> SUBT.NAME

Line 142: insert into BSC_KPI_SHELL_CMDS_TL (

138: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
139: and (SUBB.NAME <> SUBT.NAME
140: ));
141:
142: insert into BSC_KPI_SHELL_CMDS_TL (
143: INDICATOR,
144: SHELL_CMD_ID,
145: NAME,
146: COMMAND,

Line 156: from BSC_KPI_SHELL_CMDS_TL B, FND_LANGUAGES L

152: B.NAME,
153: B.COMMAND,
154: L.LANGUAGE_CODE,
155: B.SOURCE_LANG
156: from BSC_KPI_SHELL_CMDS_TL B, FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and B.LANGUAGE = userenv('LANG')
159: and not exists
160: (select NULL

Line 161: from BSC_KPI_SHELL_CMDS_TL T

157: where L.INSTALLED_FLAG in ('I', 'B')
158: and B.LANGUAGE = userenv('LANG')
159: and not exists
160: (select NULL
161: from BSC_KPI_SHELL_CMDS_TL T
162: where T.INDICATOR = B.INDICATOR
163: and T.SHELL_CMD_ID = B.SHELL_CMD_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165: end ADD_LANGUAGE;