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.BIS_IMPL_DEV_PKG dependencies on BIS_OBJ_PROPERTIES

Line 64: from bis_obj_properties

60: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
61:
62: cursor c_in_properties(p_object_name varchar2, p_object_type varchar2) is
63: select object_name
64: from bis_obj_properties
65: where object_name = p_object_name
66: and object_type = p_object_type;
67:
68: l_object_name bis_obj_properties.object_name%type;

Line 68: l_object_name bis_obj_properties.object_name%type;

64: from bis_obj_properties
65: where object_name = p_object_name
66: and object_type = p_object_type;
67:
68: l_object_name bis_obj_properties.object_name%type;
69:
70: begin
71: -- Initialize API message list if necessary.
72: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 106: /* create new rows in bis_obj_properties if it is a new object */

102: L_LAST_UPDATED_BY,
103: L_LAST_UPDATE_LOGIN,
104: L_LAST_UPDATE_DATE);
105:
106: /* create new rows in bis_obj_properties if it is a new object */
107:
108: /* temporarily remove this logic, leave this change to 4.0.9
109: open c_in_properties(p_object_name, p_object_type);
110: fetch c_in_properties into l_object_name;

Line 525: -- bis_obj_properties

521: and user_function_name = p_user_object_name
522: and function_name = p_function_name;
523:
524: cursor c_rsg_object(p_object_type varchar2, p_user_object_name varchar2) is
525: -- bis_obj_properties
526: (SELECT prop.object_name FROM bis_obj_properties prop
527: WHERE bis_impl_dev_pkg.get_user_object_name(prop.object_type,prop.object_name) = p_user_object_name
528: AND prop.object_type = p_object_type)
529: UNION ALL

Line 526: (SELECT prop.object_name FROM bis_obj_properties prop

522: and function_name = p_function_name;
523:
524: cursor c_rsg_object(p_object_type varchar2, p_user_object_name varchar2) is
525: -- bis_obj_properties
526: (SELECT prop.object_name FROM bis_obj_properties prop
527: WHERE bis_impl_dev_pkg.get_user_object_name(prop.object_type,prop.object_name) = p_user_object_name
528: AND prop.object_type = p_object_type)
529: UNION ALL
530: -- bis_obj_dependency object

Line 535: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

531: (select distinct d.object_name
532: from bis_obj_dependency_v d
533: where d.object_type = p_object_type
534: and d.user_object_name = p_user_object_name
535: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
536: WHERE prop.object_type = d.object_type
537: AND prop.object_name = d.object_name))
538: UNION ALL
539: -- bis_obj_dependency depend_object

Line 544: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

540: (SELECT DISTINCT d.depend_object_name
541: FROM bis_obj_dependency_v d
542: WHERE d.depend_object_type = p_object_type
543: AND d.user_depend_object_name = p_user_object_name
544: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
545: WHERE prop.object_type = d.object_type
546: AND prop.object_name = d.object_name)
547: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep
548: WHERE dep.object_type = d.depend_object_type

Line 556: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

552: (SELECT DISTINCT l.object_name
553: FROM bis_obj_prog_linkages l
554: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
555: AND l.object_type = p_object_type
556: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
557: WHERE prop.object_type = l.object_type
558: AND prop.object_name = l.object_name)
559: AND NOT exists (SELECT 1 FROM bis_obj_dependency d
560: WHERE (l.object_type = d.object_type AND l.object_name = d.object_name)

Line 564: -- bis_obj_properties

560: WHERE (l.object_type = d.object_type AND l.object_name = d.object_name)
561: OR (l.object_type = d.depend_object_type AND l.object_name = d.depend_object_name)));
562:
563: cursor c_rsg_object_name(p_object_type varchar2, p_user_object_name varchar2, p_object_name varchar2) is
564: -- bis_obj_properties
565: (SELECT prop.object_name FROM bis_obj_properties prop
566: WHERE bis_impl_dev_pkg.get_user_object_name(prop.object_type,prop.object_name) = p_user_object_name
567: AND prop.object_type = p_object_type
568: AND prop.object_name = p_object_name)

Line 565: (SELECT prop.object_name FROM bis_obj_properties prop

561: OR (l.object_type = d.depend_object_type AND l.object_name = d.depend_object_name)));
562:
563: cursor c_rsg_object_name(p_object_type varchar2, p_user_object_name varchar2, p_object_name varchar2) is
564: -- bis_obj_properties
565: (SELECT prop.object_name FROM bis_obj_properties prop
566: WHERE bis_impl_dev_pkg.get_user_object_name(prop.object_type,prop.object_name) = p_user_object_name
567: AND prop.object_type = p_object_type
568: AND prop.object_name = p_object_name)
569: UNION ALL

Line 576: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

572: from bis_obj_dependency_v d
573: where d.object_type = p_object_type
574: and d.user_object_name = p_user_object_name
575: AND d.object_name = p_object_name
576: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
577: WHERE prop.object_type = d.object_type
578: AND prop.object_name = d.object_name))
579: UNION ALL
580: -- bis_obj_dependency depend_object

Line 586: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

582: FROM bis_obj_dependency_v d
583: WHERE d.depend_object_type = p_object_type
584: AND d.depend_object_name = p_object_name
585: AND d.user_depend_object_name = p_user_object_name
586: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
587: WHERE prop.object_type = d.object_type
588: AND prop.object_name = d.object_name)
589: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep
590: WHERE dep.object_type = d.depend_object_type

Line 599: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

595: FROM bis_obj_prog_linkages l
596: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
597: AND l.object_type = p_object_type
598: AND l.object_name = p_object_name
599: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
600: WHERE prop.object_type = l.object_type
601: AND prop.object_name = l.object_name)
602: AND NOT exists (SELECT 1 FROM bis_obj_dependency d
603: WHERE (l.object_type = d.object_type AND l.object_name = d.object_name)

Line 925: from bis_obj_properties

921: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
922:
923: cursor c_in_properties(p_object_name varchar2, p_object_type varchar2) is
924: select object_name
925: from bis_obj_properties
926: where object_name = p_object_name
927: and object_type = p_object_type;
928:
929: l_object_name bis_obj_properties.object_name%type;

Line 929: l_object_name bis_obj_properties.object_name%type;

925: from bis_obj_properties
926: where object_name = p_object_name
927: and object_type = p_object_type;
928:
929: l_object_name bis_obj_properties.object_name%type;
930: l_return_status varchar2(10);
931: l_errorcode number;
932: l_msg_count number;
933: l_msg_data varchar2(4000);

Line 968: /* create new rows in bis_obj_properties if it is a new object */

964: L_LAST_UPDATED_BY,
965: L_LAST_UPDATE_LOGIN,
966: L_LAST_UPDATE_DATE);
967:
968: /* create new rows in bis_obj_properties if it is a new object */
969: if (p_from_ui is not null) then
970: -- check parent object
971: open c_in_properties(p_object_name, p_object_type);
972: fetch c_in_properties into l_object_name;

Line 1122: from bis_obj_properties

1118: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
1119:
1120: cursor c_in_properties(p_object_name varchar2, p_object_type varchar2) is
1121: select object_name
1122: from bis_obj_properties
1123: where object_name = p_object_name
1124: and object_type = p_object_type;
1125:
1126: l_object_name bis_obj_properties.object_name%type;

Line 1126: l_object_name bis_obj_properties.object_name%type;

1122: from bis_obj_properties
1123: where object_name = p_object_name
1124: and object_type = p_object_type;
1125:
1126: l_object_name bis_obj_properties.object_name%type;
1127: l_return_status varchar2(10);
1128: l_errorcode number;
1129: l_msg_count number;
1130: l_msg_data varchar2(4000);

Line 1163: /* create new rows in bis_obj_properties if it is a new object */

1159: AND DEPEND_OBJECT_NAME = P_DEPEND_OBJECT_NAME
1160: AND DEPEND_OBJECT_TYPE = P_DEPEND_OBJECT_TYPE;
1161: end if;
1162:
1163: /* create new rows in bis_obj_properties if it is a new object */
1164: if (p_from_ui is not null) then
1165: --check child object
1166: open c_in_properties(p_depend_object_name, p_depend_object_type);
1167: fetch c_in_properties into l_object_name;

Line 1186: execute immediate 'update bis_obj_properties set object_owner = :1

1182: close c_in_properties;
1183: end if;
1184:
1185: /* update the owner of the depend object in property and linkage for bug 3562027 */
1186: execute immediate 'update bis_obj_properties set object_owner = :1
1187: WHERE object_type = :2 AND object_name = :3'
1188: using P_DEPEND_OBJECT_OWNER, P_DEPEND_OBJECT_TYPE, P_DEPEND_OBJECT_NAME;
1189:
1190: execute immediate 'update bis_obj_prog_linkages set object_owner = :1

Line 1330: insert into bis_obj_properties (

1326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1327: FND_MSG_PUB.initialize;
1328: END IF;
1329:
1330: insert into bis_obj_properties (
1331: OBJECT_TYPE,
1332: OBJECT_NAME,
1333: OBJECT_OWNER,
1334: --SNAPSHOT_LOG_SQL,

Line 1448: update bis_obj_properties

1444: P_OBJECT_NAME in VARCHAR2,
1445: P_LAST_REFRESH_DATE in DATE
1446: ) IS
1447: Begin
1448: update bis_obj_properties
1449: set
1450: LAST_REFRESH_DATE = P_LAST_REFRESH_DATE
1451: WHERE OBJECT_TYPE = P_OBJECT_TYPE
1452: AND OBJECT_NAME = P_OBJECT_NAME ;

Line 1486: update bis_obj_properties

1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1483: FND_MSG_PUB.initialize;
1484: END IF;
1485:
1486: update bis_obj_properties
1487: set
1488: OBJECT_OWNER = P_OBJECT_OWNER,
1489: -- SNAPSHOT_LOG_SQL = P_SNAPSHOT_LOG_SQL,
1490: FAST_REFRESH_FLAG = P_FAST_REFRESH_FLAG,

Line 1611: update bis_obj_properties

1607: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1608: FND_MSG_PUB.initialize;
1609: END IF;
1610:
1611: update bis_obj_properties
1612: set
1613: OBJECT_OWNER = P_OBJECT_OWNER,
1614: SNAPSHOT_LOG_SQL = P_SNAPSHOT_LOG_SQL,
1615: FAST_REFRESH_FLAG = P_FAST_REFRESH_FLAG,

Line 1666: delete bis_obj_properties

1662: P_OBJECT_TYPE in VARCHAR2,
1663: P_OBJECT_NAME in VARCHAR2
1664: ) IS
1665: BEGIN
1666: delete bis_obj_properties
1667: where object_type = p_object_type
1668: and object_name = p_object_name;
1669:
1670: If (SQL%NOTFOUND) then

Line 1819: update bis_obj_properties

1815: --FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'bis.maigrate_page', 'no nned to migrate');
1816: RETURN;
1817: END IF;
1818:
1819: update bis_obj_properties
1820: set object_name = P_NEW_PAGE_NAME
1821: where
1822: object_type = 'PAGE'
1823: and object_name = P_PAGE_NAME;

Line 1824: --FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'bis.maigrate_page', SQL%rowcount || ' rows updated :' || P_PAGE_NAME || '->' || P_NEW_PAGE_NAME || ' in bis_obj_properties.object_name');

1820: set object_name = P_NEW_PAGE_NAME
1821: where
1822: object_type = 'PAGE'
1823: and object_name = P_PAGE_NAME;
1824: --FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'bis.maigrate_page', SQL%rowcount || ' rows updated :' || P_PAGE_NAME || '->' || P_NEW_PAGE_NAME || ' in bis_obj_properties.object_name');
1825:
1826: update bis_obj_dependency
1827: set object_name = P_NEW_PAGE_NAME
1828: where

Line 1835: /*Bug 4560963 : From now, we will get object owner from bis_obj_properties

1831: --FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'bis.maigrate_page', SQL%rowcount || ' rows updated :' || P_PAGE_NAME || '->' || P_NEW_PAGE_NAME || ' in bis_obj_dependency.object_name');
1832:
1833: END migrate_page;
1834: /* starts: bug 3562027 -- change owner for parent object */
1835: /*Bug 4560963 : From now, we will get object owner from bis_obj_properties
1836: unlike the previous approach of getting it from bis_obj_dependency */
1837: FUNCTION is_owner_changed (
1838: p_obj_name IN VARCHAR2,
1839: p_obj_type IN VARCHAR2,

Line 1846: FROM bis_obj_properties

1842: ) RETURN VARCHAR2 IS
1843:
1844: CURSOR c_owner(p_obj_name VARCHAR2, p_obj_type VARCHAR2) IS
1845: SELECT object_owner
1846: FROM bis_obj_properties
1847: WHERE object_type = p_obj_type
1848: AND object_name = p_obj_name;
1849:
1850: v_obj_owner VARCHAR2(50);

Line 1885: execute immediate 'update bis_obj_properties set object_owner = :1

1881: IF (p_obj_name IS NULL OR p_obj_type IS NULL OR p_obj_owner IS NULL) THEN
1882: RETURN;
1883: END IF;
1884:
1885: execute immediate 'update bis_obj_properties set object_owner = :1
1886: WHERE object_type = :2 AND object_name = :3'
1887: using p_obj_owner, p_obj_type, p_obj_name;
1888:
1889: execute immediate 'update bis_obj_prog_linkages set object_owner = :1

Line 1917: select CREATED_BY from bis_obj_properties

1913: select CREATED_BY from bis_obj_prog_linkages
1914: where OBJECT_NAME = l_obj_name and OBJECT_TYPE = l_obj_type;
1915:
1916: cursor c_obj_prop(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1917: select CREATED_BY from bis_obj_properties
1918: where OBJECT_NAME = l_obj_name and OBJECT_TYPE = l_obj_type;
1919:
1920: created_user number;
1921: