APPS.MTL_BILLING_SOURCE_PKG dependencies on MTL_BILLING_SOURCES_TL

Line 43: INSERT INTO mtl_billing_sources_tl

39:
40: -- INSERT INTO dp_debug VALUES('2');
41: -- commit;
42:
43: INSERT INTO mtl_billing_sources_tl
44: ( billing_source_id ,
45: name ,
46: description ,
47: creation_date ,

Line 70: from mtl_billing_sources_tl T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from mtl_billing_sources_tl T
71: where T.billing_source_id = x_billing_source_id
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: END INSERT_ROW;

Line 112: update mtl_billing_sources_tl set

108: if (sql%notfound) then
109: raise no_data_found;
110: end if;
111:
112: update mtl_billing_sources_tl set
113: name = x_name,
114: description = x_description,
115: last_update_date = x_last_update_date,
116: last_updated_by = x_last_updated_by,

Line 137: delete from mtl_billing_sources_tl

133: ) is
134: BEGIN
135:
136:
137: delete from mtl_billing_sources_tl
138: where billing_source_id = x_billing_source_id;
139:
140: if (sql%notfound) then
141: raise no_data_found;

Line 183: from mtl_billing_sources_tl

179: cursor c1 is select
180: name,
181: DESCRIPTION,
182: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
183: from mtl_billing_sources_tl
184: where billing_source_id = x_billing_source_id
185: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
186: for update of billing_source_id nowait;
187: begin

Line 229: delete from mtl_billing_sources_tl T

225: procedure ADD_LANGUAGE
226: is
227: begin
228:
229: delete from mtl_billing_sources_tl T
230: where not exists
231: (select NULL
232: from mtl_billing_sources_b B
233: where B.billing_source_id = T.billing_source_id

Line 236: update mtl_billing_sources_tl T

232: from mtl_billing_sources_b B
233: where B.billing_source_id = T.billing_source_id
234: );
235:
236: update mtl_billing_sources_tl T
237: set (
238: name,
239: description
240: ) = (select

Line 243: from mtl_billing_sources_tl B

239: description
240: ) = (select
241: B.name,
242: B.description
243: from mtl_billing_sources_tl B
244: where B.billing_source_id = T.billing_source_id
245: and B.language = T.source_lang)
246: where (
247: T.billing_source_id,

Line 253: from mtl_billing_sources_tl blsrcb, mtl_billing_sources_tl blsrct

249: )
250: in (select
251: blsrct.billing_source_id,
252: blsrct.language
253: from mtl_billing_sources_tl blsrcb, mtl_billing_sources_tl blsrct
254: where blsrcb.billing_source_id = blsrct.billing_source_id
255: and blsrcb.language = blsrct.source_lang
256: and (blsrcb.name <> blsrct.name
257: or blsrcb.description <> blsrct.description

Line 263: insert into mtl_billing_sources_tl

259: or (blsrcb.description is not null and blsrct.description is null)
260: )
261: );
262:
263: insert into mtl_billing_sources_tl
264: (
265: billing_source_id,
266: name,
267: description,

Line 286: from mtl_billing_sources_tl B, fnd_languages L

282: B.last_updated_by,
283: B.last_update_login,
284: L.language_code,
285: B.source_lang
286: from mtl_billing_sources_tl B, fnd_languages L
287: where L.installed_flag in ('I', 'B')
288: and B.language = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from mtl_billing_sources_tl T

287: where L.installed_flag in ('I', 'B')
288: and B.language = userenv('LANG')
289: and not exists
290: (select NULL
291: from mtl_billing_sources_tl T
292: where T.billing_source_id = B.billing_source_id
293: and T.language = L.language_code);
294:
295: end ADD_LANGUAGE;