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.PSB_POSITION_ATTRIBUTES_PVT dependencies on PSB_ATTRIBUTES_TL

Line 134: insert into PSB_ATTRIBUTES_TL (

130: p_CREATED_BY ,
131: p_CREATION_DATE
132: );
133:
134: insert into PSB_ATTRIBUTES_TL (
135: ATTRIBUTE_ID,
136: NAME,
137: DISPLAY_PROMPT,
138: LAST_UPDATE_DATE,

Line 160: from PSB_ATTRIBUTES_TL T

156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from PSB_ATTRIBUTES_TL T
161: where T.ATTRIBUTE_ID = P_ATTRIBUTE_ID
162: and T.LANGUAGE = L.LANGUAGE_CODE);
163:
164: open c1;

Line 312: update PSB_ATTRIBUTES_TL set

308: if (SQL%NOTFOUND) then
309: RAISE NO_DATA_FOUND;
310: end if;
311:
312: update PSB_ATTRIBUTES_TL set
313: NAME = P_NAME,
314: DISPLAY_PROMPT = P_DISPLAY_PROMPT,
315: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
316: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 417: delete from PSB_ATTRIBUTES_TL

413: end if;
414:
415: -- Perform the delete
416:
417: delete from PSB_ATTRIBUTES_TL
418: where ATTRIBUTE_ID = P_ATTRIBUTE_ID;
419:
420: if (sql%notfound) then
421: raise no_data_found;

Line 546: from PSB_ATTRIBUTES_TL

542: cursor c1 is select
543: NAME,
544: DISPLAY_PROMPT,
545: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
546: from PSB_ATTRIBUTES_TL
547: where ATTRIBUTE_ID = p_ATTRIBUTE_ID
548: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
549: for update of ATTRIBUTE_ID nowait;
550:

Line 1181: -- update the psb_attributes_tl table

1177: WHERE name = l_sys_attributes_tbl(l_rec).l_attribute_name
1178: AND business_group_id = p_business_group_id
1179: )
1180: LOOP
1181: -- update the psb_attributes_tl table
1182: UPDATE psb_attributes_tl
1183: SET name = name || '_X',
1184: last_update_date = sysdate,
1185: last_updated_by = 1,

Line 1182: UPDATE psb_attributes_tl

1178: AND business_group_id = p_business_group_id
1179: )
1180: LOOP
1181: -- update the psb_attributes_tl table
1182: UPDATE psb_attributes_tl
1183: SET name = name || '_X',
1184: last_update_date = sysdate,
1185: last_updated_by = 1,
1186: last_update_login = null

Line 1337: INSERT INTO PSB_ATTRIBUTES_TL(

1333: sysdate,
1334: 'Y'
1335: );
1336:
1337: INSERT INTO PSB_ATTRIBUTES_TL(
1338: ATTRIBUTE_ID,
1339: NAME,
1340: DISPLAY_PROMPT,
1341: LANGUAGE,

Line 1445: INSERT INTO PSB_ATTRIBUTES_TL(

1441: sysdate,
1442: NULL
1443: );
1444:
1445: INSERT INTO PSB_ATTRIBUTES_TL(
1446: ATTRIBUTE_ID,
1447: NAME,
1448: DISPLAY_PROMPT,
1449: LANGUAGE,

Line 1519: update psb_attributes_tl

1515: , last_updated_by = 1
1516: , last_update_login = null
1517: where attribute_id = c_org_rec.attribute_id;
1518:
1519: update psb_attributes_tl
1520: set name = name || '_X'
1521: , last_update_date = sysdate
1522: , last_updated_by = 1
1523: , last_update_login = null

Line 1574: INSERT INTO PSB_ATTRIBUTES_TL(

1570: -- 'Y'
1571: -- Bug No 2549894 End
1572: );
1573:
1574: INSERT INTO PSB_ATTRIBUTES_TL(
1575: ATTRIBUTE_ID,
1576: NAME,
1577: DISPLAY_PROMPT,
1578: LANGUAGE,

Line 1678: INSERT INTO PSB_ATTRIBUTES_TL(

1674: sysdate,
1675: NULL
1676: );
1677:
1678: INSERT INTO PSB_ATTRIBUTES_TL(
1679: ATTRIBUTE_ID,
1680: NAME,
1681: DISPLAY_PROMPT,
1682: LANGUAGE,

Line 1780: INSERT INTO PSB_ATTRIBUTES_TL(

1776: sysdate,
1777: NULL
1778: );
1779:
1780: INSERT INTO PSB_ATTRIBUTES_TL(
1781: ATTRIBUTE_ID,
1782: NAME,
1783: DISPLAY_PROMPT,
1784: LANGUAGE,

Line 1882: INSERT INTO PSB_ATTRIBUTES_TL(

1878: sysdate,
1879: NULL
1880: );
1881:
1882: INSERT INTO PSB_ATTRIBUTES_TL(
1883: ATTRIBUTE_ID,
1884: NAME,
1885: DISPLAY_PROMPT,
1886: LANGUAGE,

Line 2003: delete from PSB_ATTRIBUTES_TL T

1999:
2000: procedure ADD_LANGUAGE
2001: is
2002: begin
2003: delete from PSB_ATTRIBUTES_TL T
2004: where not exists
2005: (select NULL
2006: from PSB_ATTRIBUTES B
2007: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 2010: update PSB_ATTRIBUTES_TL T set (

2006: from PSB_ATTRIBUTES B
2007: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
2008: );
2009:
2010: update PSB_ATTRIBUTES_TL T set (
2011: NAME
2012: ) = (select
2013: B.NAME
2014: from PSB_ATTRIBUTES_TL B

Line 2014: from PSB_ATTRIBUTES_TL B

2010: update PSB_ATTRIBUTES_TL T set (
2011: NAME
2012: ) = (select
2013: B.NAME
2014: from PSB_ATTRIBUTES_TL B
2015: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
2016: and B.LANGUAGE = T.SOURCE_LANG)
2017: where (
2018: T.ATTRIBUTE_ID,

Line 2023: from PSB_ATTRIBUTES_TL SUBB, PSB_ATTRIBUTES_TL SUBT

2019: T.LANGUAGE
2020: ) in (select
2021: SUBT.ATTRIBUTE_ID,
2022: SUBT.LANGUAGE
2023: from PSB_ATTRIBUTES_TL SUBB, PSB_ATTRIBUTES_TL SUBT
2024: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
2025: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2026: and (SUBB.NAME <> SUBT.NAME
2027: ));

Line 2033: insert into PSB_ATTRIBUTES_TL (

2029: /*Bug#5237452. Added a new method to translate the name
2030: as per the session language. Also modified the sql to
2031: insert data for only the current session language */
2032:
2033: insert into PSB_ATTRIBUTES_TL (
2034: ATTRIBUTE_ID,
2035: NAME,
2036: /* Bug No 2777757 Start */
2037: DISPLAY_PROMPT,

Line 2059: from PSB_ATTRIBUTES_TL B, FND_LANGUAGES L,PSB_ATTRIBUTES S

2055: B.CREATED_BY,
2056: B.CREATION_DATE,
2057: USERENV('LANG'),
2058: USERENV('LANG')
2059: from PSB_ATTRIBUTES_TL B, FND_LANGUAGES L,PSB_ATTRIBUTES S
2060: where L.INSTALLED_FLAG = 'B'
2061: and B.LANGUAGE = L.LANGUAGE_CODE
2062: and S.attribute_id=B.attribute_id
2063: and not exists

Line 2065: from PSB_ATTRIBUTES_TL T

2061: and B.LANGUAGE = L.LANGUAGE_CODE
2062: and S.attribute_id=B.attribute_id
2063: and not exists
2064: (select NULL
2065: from PSB_ATTRIBUTES_TL T
2066: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
2067: and T.LANGUAGE = USERENV('LANG'));
2068: end ADD_LANGUAGE;
2069: