APPS.BSC_RESPONSIBILITY_PKG dependencies on BSC_RESPONSIBILITY_TL

Line 15: cursor C is select ROWID from BSC_RESPONSIBILITY_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_RESPONSIBILITY_TL
16: where APPLICATION_ID = X_APPLICATION_ID
17: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
18: and LANGUAGE = userenv('LANG')
19: ;

Line 21: insert into BSC_RESPONSIBILITY_TL (

17: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
21: insert into BSC_RESPONSIBILITY_TL (
22: APPLICATION_ID,
23: RESPONSIBILITY_ID,
24: RESPONSIBILITY_NAME,
25: CREATED_BY,

Line 49: from BSC_RESPONSIBILITY_TL T

45: from FND_LANGUAGES L
46: where L.INSTALLED_FLAG in ('I', 'B')
47: and not exists
48: (select NULL
49: from BSC_RESPONSIBILITY_TL T
50: where T.APPLICATION_ID = X_APPLICATION_ID
51: and T.RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
52: and T.LANGUAGE = L.LANGUAGE_CODE);
53:

Line 74: from BSC_RESPONSIBILITY_TL

70: cursor c1 is select
71: RESPONSIBILITY_NAME,
72: DESCRIPTION,
73: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
74: from BSC_RESPONSIBILITY_TL
75: where APPLICATION_ID = X_APPLICATION_ID
76: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
77: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
78: for update of APPLICATION_ID nowait;

Line 106: update BSC_RESPONSIBILITY_TL set

102: X_LAST_UPDATED_BY in NUMBER,
103: X_LAST_UPDATE_LOGIN in NUMBER
104: ) is
105: begin
106: update BSC_RESPONSIBILITY_TL set
107: RESPONSIBILITY_NAME = X_RESPONSIBILITY_NAME,
108: DESCRIPTION = X_DESCRIPTION,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
110: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 127: delete from BSC_RESPONSIBILITY_TL

123: X_APPLICATION_ID in NUMBER,
124: X_RESPONSIBILITY_ID in NUMBER
125: ) is
126: begin
127: delete from BSC_RESPONSIBILITY_TL
128: where APPLICATION_ID = X_APPLICATION_ID
129: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID;
130:
131: if (sql%notfound) then

Line 140: update BSC_RESPONSIBILITY_TL T set (

136:
137: procedure ADD_LANGUAGE
138: is
139: begin
140: update BSC_RESPONSIBILITY_TL T set (
141: RESPONSIBILITY_NAME,
142: DESCRIPTION
143: ) = (select
144: B.RESPONSIBILITY_NAME,

Line 146: from BSC_RESPONSIBILITY_TL B

142: DESCRIPTION
143: ) = (select
144: B.RESPONSIBILITY_NAME,
145: B.DESCRIPTION
146: from BSC_RESPONSIBILITY_TL B
147: where B.APPLICATION_ID = T.APPLICATION_ID
148: and B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
149: and B.LANGUAGE = T.SOURCE_LANG)
150: where (

Line 158: from BSC_RESPONSIBILITY_TL SUBB, BSC_RESPONSIBILITY_TL SUBT

154: ) in (select
155: SUBT.APPLICATION_ID,
156: SUBT.RESPONSIBILITY_ID,
157: SUBT.LANGUAGE
158: from BSC_RESPONSIBILITY_TL SUBB, BSC_RESPONSIBILITY_TL SUBT
159: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
160: and SUBB.RESPONSIBILITY_ID = SUBT.RESPONSIBILITY_ID
161: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
162: and (SUBB.RESPONSIBILITY_NAME <> SUBT.RESPONSIBILITY_NAME

Line 168: insert into BSC_RESPONSIBILITY_TL (

164: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
165: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
166: ));
167:
168: insert into BSC_RESPONSIBILITY_TL (
169: APPLICATION_ID,
170: RESPONSIBILITY_ID,
171: RESPONSIBILITY_NAME,
172: CREATED_BY,

Line 192: from BSC_RESPONSIBILITY_TL B, FND_LANGUAGES L

188: B.LAST_UPDATE_LOGIN,
189: B.DESCRIPTION,
190: L.LANGUAGE_CODE,
191: B.SOURCE_LANG
192: from BSC_RESPONSIBILITY_TL B, FND_LANGUAGES L
193: where L.INSTALLED_FLAG in ('I', 'B')
194: and B.LANGUAGE = userenv('LANG')
195: and not exists
196: (select NULL

Line 197: from BSC_RESPONSIBILITY_TL T

193: where L.INSTALLED_FLAG in ('I', 'B')
194: and B.LANGUAGE = userenv('LANG')
195: and not exists
196: (select NULL
197: from BSC_RESPONSIBILITY_TL T
198: where T.APPLICATION_ID = B.APPLICATION_ID
199: and T.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
200: and T.LANGUAGE = L.LANGUAGE_CODE);
201: end ADD_LANGUAGE;