APPS.IBY_ACCT_PMT_PROFILES_PKG dependencies on IBY_ACCT_PMT_PROFILES_TL

Line 85: insert into IBY_ACCT_PMT_PROFILES_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into IBY_ACCT_PMT_PROFILES_TL (
86: PAYMENT_PROFILE_ID,
87: PAYMENT_PROFILE_NAME,
88: CREATED_BY,
89: CREATION_DATE,

Line 111: from IBY_ACCT_PMT_PROFILES_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from IBY_ACCT_PMT_PROFILES_TL T
112: where T.PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: open c;

Line 172: from IBY_ACCT_PMT_PROFILES_TL

168:
169: cursor c1 is select
170: PAYMENT_PROFILE_NAME,
171: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
172: from IBY_ACCT_PMT_PROFILES_TL
173: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID
174: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
175: for update of PAYMENT_PROFILE_ID nowait;
176: begin

Line 290: update IBY_ACCT_PMT_PROFILES_TL set

286: if (sql%notfound) then
287: raise no_data_found;
288: end if;
289:
290: update IBY_ACCT_PMT_PROFILES_TL set
291: PAYMENT_PROFILE_NAME = X_PAYMENT_PROFILE_NAME,
292: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
293: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
294: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 308: delete from IBY_ACCT_PMT_PROFILES_TL

304: procedure DELETE_ROW (
305: X_PAYMENT_PROFILE_ID in NUMBER
306: ) is
307: begin
308: delete from IBY_ACCT_PMT_PROFILES_TL
309: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID;
310:
311: if (sql%notfound) then
312: raise no_data_found;

Line 326: delete from IBY_ACCT_PMT_PROFILES_TL T

322:
323: procedure ADD_LANGUAGE
324: is
325: begin
326: delete from IBY_ACCT_PMT_PROFILES_TL T
327: where not exists
328: (select NULL
329: from IBY_ACCT_PMT_PROFILES_B B
330: where B.PAYMENT_PROFILE_ID = T.PAYMENT_PROFILE_ID

Line 333: update IBY_ACCT_PMT_PROFILES_TL T set (

329: from IBY_ACCT_PMT_PROFILES_B B
330: where B.PAYMENT_PROFILE_ID = T.PAYMENT_PROFILE_ID
331: );
332:
333: update IBY_ACCT_PMT_PROFILES_TL T set (
334: PAYMENT_PROFILE_NAME
335: ) = (select
336: B.PAYMENT_PROFILE_NAME
337: from IBY_ACCT_PMT_PROFILES_TL B

Line 337: from IBY_ACCT_PMT_PROFILES_TL B

333: update IBY_ACCT_PMT_PROFILES_TL T set (
334: PAYMENT_PROFILE_NAME
335: ) = (select
336: B.PAYMENT_PROFILE_NAME
337: from IBY_ACCT_PMT_PROFILES_TL B
338: where B.PAYMENT_PROFILE_ID = T.PAYMENT_PROFILE_ID
339: and B.LANGUAGE = T.SOURCE_LANG)
340: where (
341: T.PAYMENT_PROFILE_ID,

Line 346: from IBY_ACCT_PMT_PROFILES_TL SUBB, IBY_ACCT_PMT_PROFILES_TL SUBT

342: T.LANGUAGE
343: ) in (select
344: SUBT.PAYMENT_PROFILE_ID,
345: SUBT.LANGUAGE
346: from IBY_ACCT_PMT_PROFILES_TL SUBB, IBY_ACCT_PMT_PROFILES_TL SUBT
347: where SUBB.PAYMENT_PROFILE_ID = SUBT.PAYMENT_PROFILE_ID
348: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
349: and (SUBB.PAYMENT_PROFILE_NAME <> SUBT.PAYMENT_PROFILE_NAME
350: ));

Line 352: insert into IBY_ACCT_PMT_PROFILES_TL (

348: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
349: and (SUBB.PAYMENT_PROFILE_NAME <> SUBT.PAYMENT_PROFILE_NAME
350: ));
351:
352: insert into IBY_ACCT_PMT_PROFILES_TL (
353: PAYMENT_PROFILE_ID,
354: PAYMENT_PROFILE_NAME,
355: CREATED_BY,
356: CREATION_DATE,

Line 374: from IBY_ACCT_PMT_PROFILES_TL B, FND_LANGUAGES L

370: B.LAST_UPDATE_LOGIN,
371: B.OBJECT_VERSION_NUMBER,
372: L.LANGUAGE_CODE,
373: B.SOURCE_LANG
374: from IBY_ACCT_PMT_PROFILES_TL B, FND_LANGUAGES L
375: where L.INSTALLED_FLAG in ('I', 'B')
376: and B.LANGUAGE = userenv('LANG')
377: and not exists
378: (select NULL

Line 379: from IBY_ACCT_PMT_PROFILES_TL T

375: where L.INSTALLED_FLAG in ('I', 'B')
376: and B.LANGUAGE = userenv('LANG')
377: and not exists
378: (select NULL
379: from IBY_ACCT_PMT_PROFILES_TL T
380: where T.PAYMENT_PROFILE_ID = B.PAYMENT_PROFILE_ID
381: and T.LANGUAGE = L.LANGUAGE_CODE);
382: end ADD_LANGUAGE;
383: