APPS.BSC_SYS_IMAGES_MAP_PKG dependencies on BSC_SYS_IMAGES_MAP_TL

Line 15: cursor C is select ROWID from BSC_SYS_IMAGES_MAP_TL

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from BSC_SYS_IMAGES_MAP_TL
16: where SOURCE_TYPE = X_SOURCE_TYPE
17: and SOURCE_CODE = X_SOURCE_CODE
18: and TYPE = X_TYPE
19: and LANGUAGE = userenv('LANG')

Line 22: insert into BSC_SYS_IMAGES_MAP_TL (

18: and TYPE = X_TYPE
19: and LANGUAGE = userenv('LANG')
20: ;
21: begin
22: insert into BSC_SYS_IMAGES_MAP_TL (
23: SOURCE_TYPE,
24: SOURCE_CODE,
25: TYPE,
26: IMAGE_ID,

Line 50: from BSC_SYS_IMAGES_MAP_TL T

46: from FND_LANGUAGES L
47: where L.INSTALLED_FLAG in ('I', 'B')
48: and not exists
49: (select NULL
50: from BSC_SYS_IMAGES_MAP_TL T
51: where T.SOURCE_TYPE = X_SOURCE_TYPE
52: and T.SOURCE_CODE = X_SOURCE_CODE
53: and T.TYPE = X_TYPE
54: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 75: from BSC_SYS_IMAGES_MAP_TL

71: ) is
72: cursor c1 is select
73: IMAGE_ID,
74: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
75: from BSC_SYS_IMAGES_MAP_TL
76: where SOURCE_TYPE = X_SOURCE_TYPE
77: and SOURCE_CODE = X_SOURCE_CODE
78: and TYPE = X_TYPE
79: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 108: update BSC_SYS_IMAGES_MAP_TL set

104: X_LAST_UPDATED_BY in NUMBER,
105: X_LAST_UPDATE_LOGIN in NUMBER
106: ) is
107: begin
108: update BSC_SYS_IMAGES_MAP_TL set
109: IMAGE_ID = X_IMAGE_ID,
110: LAST_UPDATE_DATE = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_DATE,LAST_UPDATE_DATE),
111: LAST_UPDATED_BY = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATED_BY,LAST_UPDATED_BY),
112: LAST_UPDATE_LOGIN = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_LOGIN,LAST_UPDATE_LOGIN),

Line 130: delete from BSC_SYS_IMAGES_MAP_TL

126: X_SOURCE_CODE in NUMBER,
127: X_TYPE in NUMBER
128: ) is
129: begin
130: delete from BSC_SYS_IMAGES_MAP_TL
131: where SOURCE_TYPE = X_SOURCE_TYPE
132: and SOURCE_CODE = X_SOURCE_CODE
133: and TYPE = X_TYPE;
134:

Line 151: update BSC_SYS_IMAGES_MAP_TL T set (

147: -- row and it will fail. AUDSID is not PK. After meeting with
148: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
149: l_user := BSC_APPS.fnd_global_user_id;
150:
151: update BSC_SYS_IMAGES_MAP_TL T set (
152: IMAGE_ID
153: ) = (select
154: B.IMAGE_ID
155: from BSC_SYS_IMAGES_MAP_TL B

Line 155: from BSC_SYS_IMAGES_MAP_TL B

151: update BSC_SYS_IMAGES_MAP_TL T set (
152: IMAGE_ID
153: ) = (select
154: B.IMAGE_ID
155: from BSC_SYS_IMAGES_MAP_TL B
156: where B.SOURCE_TYPE = T.SOURCE_TYPE
157: and B.SOURCE_CODE = T.SOURCE_CODE
158: and B.TYPE = T.TYPE
159: and B.LANGUAGE = T.SOURCE_LANG)

Line 170: from BSC_SYS_IMAGES_MAP_TL SUBB, BSC_SYS_IMAGES_MAP_TL SUBT

166: SUBT.SOURCE_TYPE,
167: SUBT.SOURCE_CODE,
168: SUBT.TYPE,
169: SUBT.LANGUAGE
170: from BSC_SYS_IMAGES_MAP_TL SUBB, BSC_SYS_IMAGES_MAP_TL SUBT
171: where SUBB.SOURCE_TYPE = SUBT.SOURCE_TYPE
172: and SUBB.SOURCE_CODE = SUBT.SOURCE_CODE
173: and SUBB.TYPE = SUBT.TYPE
174: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 178: insert into BSC_SYS_IMAGES_MAP_TL (

174: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
175: and (SUBB.IMAGE_ID <> SUBT.IMAGE_ID
176: ));
177:
178: insert into BSC_SYS_IMAGES_MAP_TL (
179: SOURCE_TYPE,
180: SOURCE_CODE,
181: TYPE,
182: IMAGE_ID,

Line 202: from BSC_SYS_IMAGES_MAP_TL B, FND_LANGUAGES L

198: l_user,
199: l_user,
200: L.LANGUAGE_CODE,
201: B.SOURCE_LANG
202: from BSC_SYS_IMAGES_MAP_TL B, FND_LANGUAGES L
203: where L.INSTALLED_FLAG in ('I', 'B')
204: and B.LANGUAGE = userenv('LANG')
205: and not exists
206: (select NULL

Line 207: from BSC_SYS_IMAGES_MAP_TL T

203: where L.INSTALLED_FLAG in ('I', 'B')
204: and B.LANGUAGE = userenv('LANG')
205: and not exists
206: (select NULL
207: from BSC_SYS_IMAGES_MAP_TL T
208: where T.SOURCE_TYPE = B.SOURCE_TYPE
209: and T.SOURCE_CODE = B.SOURCE_CODE
210: and T.TYPE = B.TYPE
211: and T.LANGUAGE = L.LANGUAGE_CODE);