APPS.OTA_SRT_SHD dependencies on OTA_SUPPLIABLE_RESOURCES

Line 21: If (p_constraint_name = 'OTA_SUPPLIABLE_RESOURCES_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_SUPPLIABLE_RESOURCES_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 53: from ota_suppliable_resources_tl

49: ,language
50: ,name
51: ,special_instruction
52: ,source_lang
53: from ota_suppliable_resources_tl
54: where supplied_resource_id = p_supplied_resource_id
55: and language = p_language;
56: --
57: l_fct_ret boolean;

Line 120: from ota_suppliable_resources_tl

116: ,language
117: ,name
118: ,special_instruction
119: ,source_lang
120: from ota_suppliable_resources_tl
121: where supplied_resource_id = p_supplied_resource_id
122: and language = p_language
123: for update nowait;
124: --

Line 166: fnd_message.set_token('TABLE_NAME', 'ota_suppliable_resources_tl');

162: -- The object is locked therefore we need to supply a meaningful
163: -- error message.
164: --
165: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
166: fnd_message.set_token('TABLE_NAME', 'ota_suppliable_resources_tl');
167: fnd_message.raise_error;
168: End lck;
169: --
170: -- ----------------------------------------------------------------------------

Line 182: delete from OTA_SUPPLIABLE_RESOURCES_TL T

178: -- ----------------------------------------------------------------------------
179: procedure ADD_LANGUAGE
180: is
181: begin
182: delete from OTA_SUPPLIABLE_RESOURCES_TL T
183: where not exists
184: (select NULL
185: from OTA_SUPPLIABLE_RESOURCES B
186: where B.SUPPLIED_RESOURCE_ID = T.SUPPLIED_RESOURCE_ID

Line 185: from OTA_SUPPLIABLE_RESOURCES B

181: begin
182: delete from OTA_SUPPLIABLE_RESOURCES_TL T
183: where not exists
184: (select NULL
185: from OTA_SUPPLIABLE_RESOURCES B
186: where B.SUPPLIED_RESOURCE_ID = T.SUPPLIED_RESOURCE_ID
187: );
188:
189: update OTA_SUPPLIABLE_RESOURCES_TL T set (

Line 189: update OTA_SUPPLIABLE_RESOURCES_TL T set (

185: from OTA_SUPPLIABLE_RESOURCES B
186: where B.SUPPLIED_RESOURCE_ID = T.SUPPLIED_RESOURCE_ID
187: );
188:
189: update OTA_SUPPLIABLE_RESOURCES_TL T set (
190: SPECIAL_INSTRUCTION,
191: NAME
192: ) = (select
193: B.SPECIAL_INSTRUCTION,

Line 195: from OTA_SUPPLIABLE_RESOURCES_TL B

191: NAME
192: ) = (select
193: B.SPECIAL_INSTRUCTION,
194: B.NAME
195: from OTA_SUPPLIABLE_RESOURCES_TL B
196: where B.SUPPLIED_RESOURCE_ID = T.SUPPLIED_RESOURCE_ID
197: and B.LANGUAGE = T.SOURCE_LANG)
198: where (
199: T.SUPPLIED_RESOURCE_ID,

Line 204: from OTA_SUPPLIABLE_RESOURCES_TL SUBB, OTA_SUPPLIABLE_RESOURCES_TL SUBT

200: T.LANGUAGE
201: ) in (select
202: SUBT.SUPPLIED_RESOURCE_ID,
203: SUBT.LANGUAGE
204: from OTA_SUPPLIABLE_RESOURCES_TL SUBB, OTA_SUPPLIABLE_RESOURCES_TL SUBT
205: where SUBB.SUPPLIED_RESOURCE_ID = SUBT.SUPPLIED_RESOURCE_ID
206: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
207: and (SUBB.SPECIAL_INSTRUCTION <> SUBT.SPECIAL_INSTRUCTION
208: or (SUBB.SPECIAL_INSTRUCTION is null and SUBT.SPECIAL_INSTRUCTION is not null)

Line 215: insert into OTA_SUPPLIABLE_RESOURCES_TL (

211: or (SUBB.NAME is null and SUBT.NAME is not null)
212: or (SUBB.NAME is not null and SUBT.NAME is null)
213: ));
214:
215: insert into OTA_SUPPLIABLE_RESOURCES_TL (
216: SUPPLIED_RESOURCE_ID,
217: NAME,
218: SPECIAL_INSTRUCTION,
219: CREATED_BY,

Line 237: from OTA_SUPPLIABLE_RESOURCES_TL B, FND_LANGUAGES L

233: B.LAST_UPDATED_BY,
234: B.LAST_UPDATE_LOGIN,
235: L.LANGUAGE_CODE,
236: B.SOURCE_LANG
237: from OTA_SUPPLIABLE_RESOURCES_TL B, FND_LANGUAGES L
238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL

Line 242: from OTA_SUPPLIABLE_RESOURCES_TL T

238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL
242: from OTA_SUPPLIABLE_RESOURCES_TL T
243: where T.SUPPLIED_RESOURCE_ID = B.SUPPLIED_RESOURCE_ID
244: and T.LANGUAGE = L.LANGUAGE_CODE);
245: end ADD_LANGUAGE;
246: --