APPS.MTL_BILLING_HEADER_RULES_PKG dependencies on MTL_BILLING_RULE_HEADERS_TL

Line 40: INSERT INTO mtl_billing_rule_headers_tl

36: x_last_updated_by ,
37: x_last_update_login
38: );
39:
40: INSERT INTO mtl_billing_rule_headers_tl
41: (
42: billing_rule_header_id ,
43: name ,
44: description ,

Line 68: from mtl_billing_rule_headers_tl T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: ( select 1
68: from mtl_billing_rule_headers_tl T
69: where T.billing_rule_header_id = x_billing_rule_header_id
70: and T.LANGUAGE = L.LANGUAGE_CODE
71: );
72:

Line 118: update mtl_billing_rule_headers_tl set

114: if (sql%notfound) then
115: raise no_data_found;
116: end if;
117:
118: update mtl_billing_rule_headers_tl set
119: name = x_name,
120: description = x_description ,
121: creation_date = x_creation_date,
122: created_by = x_created_by,

Line 143: delete from mtl_billing_rule_headers_tl

139: procedure DELETE_ROW (
140: x_billing_rule_header_id in NUMBER
141: ) is
142: begin
143: delete from mtl_billing_rule_headers_tl
144: where billing_rule_header_id = x_billing_rule_header_id;
145:
146: if (sql%notfound) then
147: raise no_data_found;

Line 189: from mtl_billing_rule_headers_tl

185:
186: cursor c1 is select
187: name,
188: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
189: from mtl_billing_rule_headers_tl
190: where billing_rule_header_id = x_billing_rule_header_id
191: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
192: for update of billing_rule_header_id nowait;
193: begin

Line 233: delete from mtl_billing_rule_headers_tl T

229: procedure ADD_LANGUAGE
230: is
231: begin
232:
233: delete from mtl_billing_rule_headers_tl T
234: where not exists
235: (select NULL
236: from mtl_billing_rule_headers_b B
237: where B.billing_rule_header_id = T.billing_rule_header_id

Line 240: update mtl_billing_rule_headers_tl T

236: from mtl_billing_rule_headers_b B
237: where B.billing_rule_header_id = T.billing_rule_header_id
238: );
239:
240: update mtl_billing_rule_headers_tl T
241: set (
242: name,
243: description
244: ) = (select

Line 247: from mtl_billing_rule_headers_tl B

243: description
244: ) = (select
245: B.name,
246: B.description
247: from mtl_billing_rule_headers_tl B
248: where B.billing_rule_header_id = T.billing_rule_header_id
249: and B.language = T.source_lang
250: )
251: where (

Line 257: from mtl_billing_rule_headers_tl blrulb, mtl_billing_rule_headers_tl blrult

253: T.language
254: ) in (select
255: blrult.billing_rule_header_id,
256: blrult.language
257: from mtl_billing_rule_headers_tl blrulb, mtl_billing_rule_headers_tl blrult
258: where blrulb.billing_rule_header_id = blrult.billing_rule_header_id
259: and blrulb.language = blrult.source_lang
260: and (blrulb.name <> blrult.name
261: or blrulb.description <> blrult.description

Line 268: insert into mtl_billing_rule_headers_tl

264: )
265: );
266:
267:
268: insert into mtl_billing_rule_headers_tl
269: (
270: billing_rule_header_id,
271: name,
272: description,

Line 292: from mtl_billing_rule_headers_tl B, fnd_languages L

288: B.last_updated_by,
289: B.last_update_login,
290: L.language_code,
291: B.source_lang
292: from mtl_billing_rule_headers_tl B, fnd_languages L
293: where L.installed_flag in ('I', 'B')
294: and B.language = userenv('LANG')
295: and not exists
296: (select NULL

Line 297: from mtl_billing_rule_headers_tl T

293: where L.installed_flag in ('I', 'B')
294: and B.language = userenv('LANG')
295: and not exists
296: (select NULL
297: from mtl_billing_rule_headers_tl T
298: where T.billing_rule_header_id = B.billing_rule_header_id
299: and T.language = L.language_code
300: );
301: