APPS.FTP_REPRICE_PATTERN_PKG dependencies on FTP_REPRICE_PATTERN_TL

Line 45: insert into FTP_REPRICE_PATTERN_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into FTP_REPRICE_PATTERN_TL (
46: OBJECT_VERSION_NUMBER,
47: REPRICE_ID,
48: ADJUSTABLE_TYPE_CODE,
49: DESCRIPTION,

Line 73: from FTP_REPRICE_PATTERN_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from FTP_REPRICE_PATTERN_TL T
74: where T.REPRICE_ID = X_REPRICE_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: open c;

Line 108: from FTP_REPRICE_PATTERN_TL

104:
105: cursor c1 is select
106: DESCRIPTION,
107: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
108: from FTP_REPRICE_PATTERN_TL
109: where REPRICE_ID = X_REPRICE_ID
110: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
111: for update of REPRICE_ID nowait;
112: begin

Line 174: update FTP_REPRICE_PATTERN_TL set

170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: update FTP_REPRICE_PATTERN_TL set
175: DESCRIPTION = X_DESCRIPTION,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
178: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 192: delete from FTP_REPRICE_PATTERN_TL

188: procedure DELETE_ROW (
189: X_REPRICE_ID in NUMBER
190: ) is
191: begin
192: delete from FTP_REPRICE_PATTERN_TL
193: where REPRICE_ID = X_REPRICE_ID;
194:
195: if (sql%notfound) then
196: raise no_data_found;

Line 210: delete from FTP_REPRICE_PATTERN_TL T

206:
207: procedure ADD_LANGUAGE
208: is
209: begin
210: delete from FTP_REPRICE_PATTERN_TL T
211: where not exists
212: (select NULL
213: from FTP_REPRICE_PATTERN_B B
214: where B.REPRICE_ID = T.REPRICE_ID

Line 217: update FTP_REPRICE_PATTERN_TL T set (

213: from FTP_REPRICE_PATTERN_B B
214: where B.REPRICE_ID = T.REPRICE_ID
215: );
216:
217: update FTP_REPRICE_PATTERN_TL T set (
218: DESCRIPTION
219: ) = (select
220: B.DESCRIPTION
221: from FTP_REPRICE_PATTERN_TL B

Line 221: from FTP_REPRICE_PATTERN_TL B

217: update FTP_REPRICE_PATTERN_TL T set (
218: DESCRIPTION
219: ) = (select
220: B.DESCRIPTION
221: from FTP_REPRICE_PATTERN_TL B
222: where B.REPRICE_ID = T.REPRICE_ID
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (
225: T.REPRICE_ID,

Line 230: from FTP_REPRICE_PATTERN_TL SUBB, FTP_REPRICE_PATTERN_TL SUBT

226: T.LANGUAGE
227: ) in (select
228: SUBT.REPRICE_ID,
229: SUBT.LANGUAGE
230: from FTP_REPRICE_PATTERN_TL SUBB, FTP_REPRICE_PATTERN_TL SUBT
231: where SUBB.REPRICE_ID = SUBT.REPRICE_ID
232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
233: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
234: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 238: insert into FTP_REPRICE_PATTERN_TL (

234: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
235: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
236: ));
237:
238: insert into FTP_REPRICE_PATTERN_TL (
239: OBJECT_VERSION_NUMBER,
240: REPRICE_ID,
241: ADJUSTABLE_TYPE_CODE,
242: DESCRIPTION,

Line 262: from FTP_REPRICE_PATTERN_TL B, FND_LANGUAGES L

258: B.LAST_UPDATE_DATE,
259: B.LAST_UPDATE_LOGIN,
260: L.LANGUAGE_CODE,
261: B.SOURCE_LANG
262: from FTP_REPRICE_PATTERN_TL B, FND_LANGUAGES L
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL

Line 267: from FTP_REPRICE_PATTERN_TL T

263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL
267: from FTP_REPRICE_PATTERN_TL T
268: where T.REPRICE_ID = B.REPRICE_ID
269: and T.LANGUAGE = L.LANGUAGE_CODE);
270: end ADD_LANGUAGE;
271: