eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_SYS_EFT_PF_TL

Line 1429: insert into IBY_FNDCPT_SYS_EFT_PF_TL (

1425: X_ACCOMPANY_LETTER_FORMAT,
1426: X_AUTOMATIC_PN_SUBMIT_FLAG
1427: );
1428:
1429: insert into IBY_FNDCPT_SYS_EFT_PF_TL (
1430: SYS_EFT_PROFILE_NAME,
1431: CREATED_BY,
1432: CREATION_DATE,
1433: LAST_UPDATED_BY,

Line 1455: from IBY_FNDCPT_SYS_EFT_PF_TL T

1451: from FND_LANGUAGES L
1452: where L.INSTALLED_FLAG in ('I', 'B')
1453: and not exists
1454: (select NULL
1455: from IBY_FNDCPT_SYS_EFT_PF_TL T
1456: where T.SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE
1457: and T.LANGUAGE = L.LANGUAGE_CODE);
1458:
1459: open c;

Line 1543: update IBY_FNDCPT_SYS_EFT_PF_TL set

1539: if (sql%notfound) then
1540: raise no_data_found;
1541: end if;
1542:
1543: update IBY_FNDCPT_SYS_EFT_PF_TL set
1544: SYS_EFT_PROFILE_NAME = X_SYS_EFT_PROFILE_NAME,
1545: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1546: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1547: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1561: delete from IBY_FNDCPT_SYS_EFT_PF_TL

1557: procedure SYS_EFT_PROF_DELETE_ROW (
1558: X_SYS_EFT_PROFILE_CODE in VARCHAR2
1559: ) is
1560: begin
1561: delete from IBY_FNDCPT_SYS_EFT_PF_TL
1562: where SYS_EFT_PROFILE_CODE = X_SYS_EFT_PROFILE_CODE;
1563:
1564: if (sql%notfound) then
1565: raise no_data_found;

Line 1579: delete from IBY_FNDCPT_SYS_EFT_PF_TL T

1575:
1576: procedure SYS_EFT_PROF_ADD_LANGUAGE
1577: is
1578: begin
1579: delete from IBY_FNDCPT_SYS_EFT_PF_TL T
1580: where not exists
1581: (select NULL
1582: from IBY_FNDCPT_SYS_EFT_PF_B B
1583: where B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE

Line 1586: update IBY_FNDCPT_SYS_EFT_PF_TL T set (

1582: from IBY_FNDCPT_SYS_EFT_PF_B B
1583: where B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE
1584: );
1585:
1586: update IBY_FNDCPT_SYS_EFT_PF_TL T set (
1587: SYS_EFT_PROFILE_NAME
1588: ) = (select
1589: B.SYS_EFT_PROFILE_NAME
1590: from IBY_FNDCPT_SYS_EFT_PF_TL B

Line 1590: from IBY_FNDCPT_SYS_EFT_PF_TL B

1586: update IBY_FNDCPT_SYS_EFT_PF_TL T set (
1587: SYS_EFT_PROFILE_NAME
1588: ) = (select
1589: B.SYS_EFT_PROFILE_NAME
1590: from IBY_FNDCPT_SYS_EFT_PF_TL B
1591: where B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE
1592: and B.LANGUAGE = T.SOURCE_LANG)
1593: where (
1594: T.SYS_EFT_PROFILE_CODE,

Line 1599: from IBY_FNDCPT_SYS_EFT_PF_TL SUBB, IBY_FNDCPT_SYS_EFT_PF_TL SUBT

1595: T.LANGUAGE
1596: ) in (select
1597: SUBT.SYS_EFT_PROFILE_CODE,
1598: SUBT.LANGUAGE
1599: from IBY_FNDCPT_SYS_EFT_PF_TL SUBB, IBY_FNDCPT_SYS_EFT_PF_TL SUBT
1600: where SUBB.SYS_EFT_PROFILE_CODE = SUBT.SYS_EFT_PROFILE_CODE
1601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1602: and (SUBB.SYS_EFT_PROFILE_NAME <> SUBT.SYS_EFT_PROFILE_NAME
1603: ));

Line 1605: insert into IBY_FNDCPT_SYS_EFT_PF_TL (

1601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1602: and (SUBB.SYS_EFT_PROFILE_NAME <> SUBT.SYS_EFT_PROFILE_NAME
1603: ));
1604:
1605: insert into IBY_FNDCPT_SYS_EFT_PF_TL (
1606: SYS_EFT_PROFILE_NAME,
1607: CREATED_BY,
1608: CREATION_DATE,
1609: LAST_UPDATED_BY,

Line 1627: from IBY_FNDCPT_SYS_EFT_PF_TL B, FND_LANGUAGES L

1623: B.OBJECT_VERSION_NUMBER,
1624: B.SYS_EFT_PROFILE_CODE,
1625: L.LANGUAGE_CODE,
1626: B.SOURCE_LANG
1627: from IBY_FNDCPT_SYS_EFT_PF_TL B, FND_LANGUAGES L
1628: where L.INSTALLED_FLAG in ('I', 'B')
1629: and B.LANGUAGE = userenv('LANG')
1630: and not exists
1631: (select NULL

Line 1632: from IBY_FNDCPT_SYS_EFT_PF_TL T

1628: where L.INSTALLED_FLAG in ('I', 'B')
1629: and B.LANGUAGE = userenv('LANG')
1630: and not exists
1631: (select NULL
1632: from IBY_FNDCPT_SYS_EFT_PF_TL T
1633: where T.SYS_EFT_PROFILE_CODE = B.SYS_EFT_PROFILE_CODE
1634: and T.LANGUAGE = L.LANGUAGE_CODE);
1635: end SYS_EFT_PROF_ADD_LANGUAGE;
1636:

Line 1758: update iby_fndcpt_sys_eft_pf_tl set

1754: X_LAST_UPDATE_DATE in DATE,
1755: X_OWNER in VARCHAR2)
1756: is
1757: begin
1758: update iby_fndcpt_sys_eft_pf_tl set
1759: SYS_EFT_PROFILE_NAME = X_SYS_EFT_PROFILE_NAME,
1760: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1761: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
1762: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,