APPS.SO_PRICING_RULES_PKG dependencies on SO_PRICING_RULES_TL

Line 91: insert into SO_PRICING_RULES_TL (

87: X_LAST_UPDATED_BY,
88: X_LAST_UPDATE_LOGIN
89: );
90:
91: insert into SO_PRICING_RULES_TL (
92: PRICING_RULE_ID,
93: DESCRIPTION,
94: NAME,
95: LAST_UPDATE_DATE,

Line 117: from SO_PRICING_RULES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from SO_PRICING_RULES_TL T
118: where T.PRICING_RULE_ID = X_PRICING_RULE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from SO_PRICING_RULES_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from SO_PRICING_RULES_TL
185: where PRICING_RULE_ID = X_PRICING_RULE_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of PRICING_RULE_ID nowait;
188: begin

Line 314: update SO_PRICING_RULES_TL set

310: if (sql%notfound) then
311: raise no_data_found;
312: end if;
313:
314: update SO_PRICING_RULES_TL set
315: NAME = X_NAME,
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 333: delete from SO_PRICING_RULES_TL

329: procedure DELETE_ROW (
330: X_PRICING_RULE_ID in NUMBER
331: ) is
332: begin
333: delete from SO_PRICING_RULES_TL
334: where PRICING_RULE_ID = X_PRICING_RULE_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 351: delete from SO_PRICING_RULES_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from SO_PRICING_RULES_TL T
352: where not exists
353: (select NULL
354: from SO_PRICING_RULES_B B
355: where B.PRICING_RULE_ID = T.PRICING_RULE_ID

Line 358: update SO_PRICING_RULES_TL T set (

354: from SO_PRICING_RULES_B B
355: where B.PRICING_RULE_ID = T.PRICING_RULE_ID
356: );
357:
358: update SO_PRICING_RULES_TL T set (
359: NAME,
360: DESCRIPTION
361: ) = (select
362: B.NAME,

Line 364: from SO_PRICING_RULES_TL B

360: DESCRIPTION
361: ) = (select
362: B.NAME,
363: B.DESCRIPTION
364: from SO_PRICING_RULES_TL B
365: where B.PRICING_RULE_ID = T.PRICING_RULE_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.PRICING_RULE_ID,

Line 373: from SO_PRICING_RULES_TL SUBB, SO_PRICING_RULES_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.PRICING_RULE_ID,
372: SUBT.LANGUAGE
373: from SO_PRICING_RULES_TL SUBB, SO_PRICING_RULES_TL SUBT
374: where SUBB.PRICING_RULE_ID = SUBT.PRICING_RULE_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.NAME <> SUBT.NAME
377: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: insert into SO_PRICING_RULES_TL (

378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381:
382: insert into SO_PRICING_RULES_TL (
383: PRICING_RULE_ID,
384: DESCRIPTION,
385: NAME,
386: LAST_UPDATE_DATE,

Line 404: from SO_PRICING_RULES_TL B, FND_LANGUAGES L

400: B.CREATED_BY,
401: B.LAST_UPDATE_LOGIN,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from SO_PRICING_RULES_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from SO_PRICING_RULES_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from SO_PRICING_RULES_TL T
410: where T.PRICING_RULE_ID = B.PRICING_RULE_ID
411: and T.LANGUAGE = L.LANGUAGE_CODE);
412: end ADD_LANGUAGE;
413: