APPS.FRM_DELIVERY_OPTIONS_PKG dependencies on FRM_DELIVERY_OPTIONS_TL

Line 48: insert into FRM_DELIVERY_OPTIONS_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into FRM_DELIVERY_OPTIONS_TL (
49: DELIVERY_ID,
50: USER_NAME,
51: CREATION_DATE,
52: CREATED_BY,

Line 72: from FRM_DELIVERY_OPTIONS_TL T

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

Line 109: from FRM_DELIVERY_OPTIONS_TL

105:
106: cursor c1 is select
107: USER_NAME,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from FRM_DELIVERY_OPTIONS_TL
110: where DELIVERY_ID = X_DELIVERY_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of DELIVERY_ID nowait;
113: begin

Line 177: update FRM_DELIVERY_OPTIONS_TL set

173: if (sql%notfound) then
174: raise no_data_found;
175: end if;
176:
177: update FRM_DELIVERY_OPTIONS_TL set
178: USER_NAME = X_USER_NAME,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
181: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 195: delete from FRM_DELIVERY_OPTIONS_TL

191: procedure DELETE_ROW (
192: X_DELIVERY_ID in NUMBER
193: ) is
194: begin
195: delete from FRM_DELIVERY_OPTIONS_TL
196: where DELIVERY_ID = X_DELIVERY_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 213: delete from FRM_DELIVERY_OPTIONS_TL T

209:
210: procedure ADD_LANGUAGE
211: is
212: begin
213: delete from FRM_DELIVERY_OPTIONS_TL T
214: where not exists
215: (select NULL
216: from FRM_DELIVERY_OPTIONS_B B
217: where B.DELIVERY_ID = T.DELIVERY_ID

Line 220: update FRM_DELIVERY_OPTIONS_TL T set (

216: from FRM_DELIVERY_OPTIONS_B B
217: where B.DELIVERY_ID = T.DELIVERY_ID
218: );
219:
220: update FRM_DELIVERY_OPTIONS_TL T set (
221: USER_NAME
222: ) = (select
223: B.USER_NAME
224: from FRM_DELIVERY_OPTIONS_TL B

Line 224: from FRM_DELIVERY_OPTIONS_TL B

220: update FRM_DELIVERY_OPTIONS_TL T set (
221: USER_NAME
222: ) = (select
223: B.USER_NAME
224: from FRM_DELIVERY_OPTIONS_TL B
225: where B.DELIVERY_ID = T.DELIVERY_ID
226: and B.LANGUAGE = T.SOURCE_LANG)
227: where (
228: T.DELIVERY_ID,

Line 233: from FRM_DELIVERY_OPTIONS_TL SUBB, FRM_DELIVERY_OPTIONS_TL SUBT

229: T.LANGUAGE
230: ) in (select
231: SUBT.DELIVERY_ID,
232: SUBT.LANGUAGE
233: from FRM_DELIVERY_OPTIONS_TL SUBB, FRM_DELIVERY_OPTIONS_TL SUBT
234: where SUBB.DELIVERY_ID = SUBT.DELIVERY_ID
235: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
236: and (SUBB.USER_NAME <> SUBT.USER_NAME
237: ));

Line 239: insert into FRM_DELIVERY_OPTIONS_TL (

235: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
236: and (SUBB.USER_NAME <> SUBT.USER_NAME
237: ));
238:
239: insert into FRM_DELIVERY_OPTIONS_TL (
240: DELIVERY_ID,
241: USER_NAME,
242: CREATION_DATE,
243: CREATED_BY,

Line 259: from FRM_DELIVERY_OPTIONS_TL B, FND_LANGUAGES L

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

Line 264: from FRM_DELIVERY_OPTIONS_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from FRM_DELIVERY_OPTIONS_TL T
265: where T.DELIVERY_ID = B.DELIVERY_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268: