APPS.PO_COMMODITIES_PKG dependencies on PO_COMMODITIES_TL

Line 40: insert into PO_COMMODITIES_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into PO_COMMODITIES_TL (
41: COMMODITY_ID,
42: NAME,
43: DESCRIPTION,
44: CREATION_DATE,

Line 66: from PO_COMMODITIES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from PO_COMMODITIES_TL T
67: where T.COMMODITY_ID = X_COMMODITY_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from PO_COMMODITIES_TL

95: cursor c1 is select
96: NAME,
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from PO_COMMODITIES_TL
100: where COMMODITY_ID = X_COMMODITY_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of COMMODITY_ID nowait;
103: begin

Line 160: update PO_COMMODITIES_TL set

156: if (sql%notfound) then
157: raise no_data_found;
158: end if;
159:
160: update PO_COMMODITIES_TL set
161: NAME = X_NAME,
162: DESCRIPTION = X_DESCRIPTION,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 179: delete from PO_COMMODITIES_TL

175: procedure DELETE_ROW (
176: X_COMMODITY_ID in NUMBER
177: ) is
178: begin
179: delete from PO_COMMODITIES_TL
180: where COMMODITY_ID = X_COMMODITY_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 197: delete from PO_COMMODITIES_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from PO_COMMODITIES_TL T
198: where not exists
199: (select NULL
200: from PO_COMMODITIES_B B
201: where B.COMMODITY_ID = T.COMMODITY_ID

Line 204: update PO_COMMODITIES_TL T set (

200: from PO_COMMODITIES_B B
201: where B.COMMODITY_ID = T.COMMODITY_ID
202: );
203:
204: update PO_COMMODITIES_TL T set (
205: NAME,
206: DESCRIPTION
207: ) = (select
208: B.NAME,

Line 210: from PO_COMMODITIES_TL B

206: DESCRIPTION
207: ) = (select
208: B.NAME,
209: B.DESCRIPTION
210: from PO_COMMODITIES_TL B
211: where B.COMMODITY_ID = T.COMMODITY_ID
212: and B.LANGUAGE = T.SOURCE_LANG)
213: where (
214: T.COMMODITY_ID,

Line 219: from PO_COMMODITIES_TL SUBB, PO_COMMODITIES_TL SUBT

215: T.LANGUAGE
216: ) in (select
217: SUBT.COMMODITY_ID,
218: SUBT.LANGUAGE
219: from PO_COMMODITIES_TL SUBB, PO_COMMODITIES_TL SUBT
220: where SUBB.COMMODITY_ID = SUBT.COMMODITY_ID
221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.NAME <> SUBT.NAME
223: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 228: insert into PO_COMMODITIES_TL (

224: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
225: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
226: ));
227:
228: insert into PO_COMMODITIES_TL (
229: COMMODITY_ID,
230: NAME,
231: DESCRIPTION,
232: CREATION_DATE,

Line 250: from PO_COMMODITIES_TL B, FND_LANGUAGES L

246: B.LAST_UPDATED_BY,
247: B.LAST_UPDATE_LOGIN,
248: L.LANGUAGE_CODE,
249: B.SOURCE_LANG
250: from PO_COMMODITIES_TL B, FND_LANGUAGES L
251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL

Line 255: from PO_COMMODITIES_TL T

251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL
255: from PO_COMMODITIES_TL T
256: where T.COMMODITY_ID = B.COMMODITY_ID
257: and T.LANGUAGE = L.LANGUAGE_CODE);
258: end ADD_LANGUAGE;
259: