APPS.FRM_DELIVERY_CONFIGS_PKG dependencies on FRM_DELIVERY_CONFIGURATIONS_TL

Line 42: insert into FRM_DELIVERY_CONFIGURATIONS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into FRM_DELIVERY_CONFIGURATIONS_TL (
43: CONFIGURATION_ID,
44: USER_NAME,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from FRM_DELIVERY_CONFIGURATIONS_TL T

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

Line 99: from FRM_DELIVERY_CONFIGURATIONS_TL

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

Line 161: update FRM_DELIVERY_CONFIGURATIONS_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update FRM_DELIVERY_CONFIGURATIONS_TL set
162: USER_NAME = X_USER_NAME,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 179: delete from FRM_DELIVERY_CONFIGURATIONS_TL

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

Line 197: delete from FRM_DELIVERY_CONFIGURATIONS_TL T

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

Line 204: update FRM_DELIVERY_CONFIGURATIONS_TL T set (

200: from FRM_DELIVERY_CONFIGURATIONS_B B
201: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
202: );
203:
204: update FRM_DELIVERY_CONFIGURATIONS_TL T set (
205: USER_NAME
206: ) = (select
207: B.USER_NAME
208: from FRM_DELIVERY_CONFIGURATIONS_TL B

Line 208: from FRM_DELIVERY_CONFIGURATIONS_TL B

204: update FRM_DELIVERY_CONFIGURATIONS_TL T set (
205: USER_NAME
206: ) = (select
207: B.USER_NAME
208: from FRM_DELIVERY_CONFIGURATIONS_TL B
209: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.CONFIGURATION_ID,

Line 217: from FRM_DELIVERY_CONFIGURATIONS_TL SUBB, FRM_DELIVERY_CONFIGURATIONS_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.CONFIGURATION_ID,
216: SUBT.LANGUAGE
217: from FRM_DELIVERY_CONFIGURATIONS_TL SUBB, FRM_DELIVERY_CONFIGURATIONS_TL SUBT
218: where SUBB.CONFIGURATION_ID = SUBT.CONFIGURATION_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.USER_NAME <> SUBT.USER_NAME
221: ));

Line 223: insert into FRM_DELIVERY_CONFIGURATIONS_TL (

219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.USER_NAME <> SUBT.USER_NAME
221: ));
222:
223: insert into FRM_DELIVERY_CONFIGURATIONS_TL (
224: CONFIGURATION_ID,
225: USER_NAME,
226: CREATION_DATE,
227: CREATED_BY,

Line 243: from FRM_DELIVERY_CONFIGURATIONS_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_LOGIN,
240: B.LAST_UPDATE_DATE,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from FRM_DELIVERY_CONFIGURATIONS_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from FRM_DELIVERY_CONFIGURATIONS_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from FRM_DELIVERY_CONFIGURATIONS_TL T
249: where T.CONFIGURATION_ID = B.CONFIGURATION_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252: