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_DEPENDENCY

Line 382: l_object_name bis_obj_dependency.object_name%TYPE;

378: X_OBJECT_NAME IN OUT NOCOPY VARCHAR2,
379: X_IS_OA_PAGE IN OUT NOCOPY VARCHAR2,
380: X_RETURN_STATUS OUT NOCOPY VARCHAR2
381: ) IS
382: l_object_name bis_obj_dependency.object_name%TYPE;
383: l_user_object_name VARCHAR2(480); --Enhancement 4106617
384: i NUMBER := 0;
385: j NUMBER := 0;
386: l_is_oa_page VARCHAR2(1);

Line 393: from fnd_form_functions_vl func, bis_obj_dependency dep

389: CURSOR c_page(p_user_object_name VARCHAR2, p_object_name VARCHAR2, p_is_oa_page VARCHAR2) IS
390: SELECT object_name, user_object_name, oa_page
391: FROM (-- portal pages existing in RSG
392: (select DISTINCT dep.object_name object_name, func.user_function_name user_object_name, 'N' oa_page
393: from fnd_form_functions_vl func, bis_obj_dependency dep
394: where upper(web_html_call)='ORACLESSWA.SWITCHPAGE'
395: and dep.object_type = 'PAGE'
396: and dep.object_name = substr(parameters,10))
397: UNION ALL

Line 400: from fnd_form_functions_vl func, bis_obj_dependency dep

396: and dep.object_name = substr(parameters,10))
397: UNION ALL
398: -- oa page existing in RSG repository
399: (select DISTINCT dep.object_name object_name, func.user_function_name user_object_name, 'Y' oa_page
400: from fnd_form_functions_vl func, bis_obj_dependency dep
401: where upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
402: and dep.object_type = 'PAGE'
403: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = func.function_name)
404: UNION ALL

Line 410: from fnd_form_functions f, bis_obj_dependency dep

406: select func.function_name object_name, func.user_function_name user_object_name, 'Y' oa_page
407: from fnd_form_functions_vl func
408: where upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
409: and func.function_name not in (select f.function_name
410: from fnd_form_functions f, bis_obj_dependency dep
411: where upper(f.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
412: and dep.object_type = 'PAGE'
413: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = f.function_name)
414: UNION ALL

Line 417: --from bis_obj_dependency_v objdep

413: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = f.function_name)
414: UNION ALL
415: -- page in RSG repository but w/o corresponding form function defined
416: (select DISTINCT objdep.object_name object_name, /*objdep.user_object_name user_object_name*/ objdep.object_name user_object_name, 'N' oa_page
417: --from bis_obj_dependency_v objdep
418: from bis_obj_dependency objdep
419: where objdep.object_type = 'PAGE'
420: and not exists (select 1 from fnd_form_functions func
421: where (upper(func.web_html_call) = 'ORACLESSWA.SWITCHPAGE'

Line 418: from bis_obj_dependency objdep

414: UNION ALL
415: -- page in RSG repository but w/o corresponding form function defined
416: (select DISTINCT objdep.object_name object_name, /*objdep.user_object_name user_object_name*/ objdep.object_name user_object_name, 'N' oa_page
417: --from bis_obj_dependency_v objdep
418: from bis_obj_dependency objdep
419: where objdep.object_type = 'PAGE'
420: and not exists (select 1 from fnd_form_functions func
421: where (upper(func.web_html_call) = 'ORACLESSWA.SWITCHPAGE'
422: and substr(func.parameters,10) = objdep.object_name)

Line 493: l_object_name bis_obj_dependency.object_name%TYPE;

489: P_USER_OBJECT_NAME IN VARCHAR2,
490: X_OBJECT_NAME IN OUT NOCOPY VARCHAR2,
491: X_RETURN_STATUS OUT NOCOPY VARCHAR2
492: ) is
493: l_object_name bis_obj_dependency.object_name%TYPE;
494: i NUMBER;
495:
496: ---fix bug 4067976. Added type WEBPORTLETX for portlet form
497: ---function

Line 530: -- bis_obj_dependency object

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
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

Line 532: from bis_obj_dependency_v d

528: AND prop.object_type = p_object_type)
529: UNION ALL
530: -- bis_obj_dependency object
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

Line 539: -- bis_obj_dependency depend_object

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
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

Line 541: FROM bis_obj_dependency_v d

537: AND prop.object_name = d.object_name))
538: UNION ALL
539: -- bis_obj_dependency depend_object
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

Line 547: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep

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
549: AND dep.object_name = d.depend_object_name))
550: UNION ALL
551: -- bis_obj_prog_linkages object

Line 559: AND NOT exists (SELECT 1 FROM bis_obj_dependency d

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)
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

Line 570: -- bis_obj_dependency object

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
570: -- bis_obj_dependency object
571: (select distinct d.object_name
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

Line 572: from bis_obj_dependency_v d

568: AND prop.object_name = p_object_name)
569: UNION ALL
570: -- bis_obj_dependency object
571: (select distinct d.object_name
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

Line 580: -- bis_obj_dependency depend_object

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
581: (SELECT DISTINCT d.depend_object_name
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

Line 582: FROM bis_obj_dependency_v d

578: AND prop.object_name = d.object_name))
579: UNION ALL
580: -- bis_obj_dependency depend_object
581: (SELECT DISTINCT d.depend_object_name
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

Line 589: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep

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
591: AND dep.object_name = d.depend_object_name))
592: UNION ALL
593: -- bis_obj_prog_linkages object

Line 602: AND NOT exists (SELECT 1 FROM bis_obj_dependency d

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)
604: OR (l.object_type = d.depend_object_type AND l.object_name = d.depend_object_name)));
605:
606: begin

Line 754: -- FROM (SELECT object_type, object_name, depend_object_type, depend_object_name FROM bis_obj_dependency WHERE enabled_flag = 'Y') d

750: CURSOR c_dep_loop (p_object_type VARCHAR2, p_object_name VARCHAR2, p_dep_object_type VARCHAR2, p_dep_object_name VARCHAR2) IS
751: SELECT obj_parents.object_name
752: FROM (SELECT object_type, object_name
753: -- bug 3492509: loop detection regardless of enabled flag condition
754: -- FROM (SELECT object_type, object_name, depend_object_type, depend_object_name FROM bis_obj_dependency WHERE enabled_flag = 'Y') d
755: FROM bis_obj_dependency d
756: START WITH d.depend_object_type = p_object_type AND d.depend_object_name = p_object_name
757: CONNECT BY PRIOR d.object_name = d.depend_object_name
758: AND PRIOR d.object_type = d.depend_object_type) obj_parents

Line 755: FROM bis_obj_dependency d

751: SELECT obj_parents.object_name
752: FROM (SELECT object_type, object_name
753: -- bug 3492509: loop detection regardless of enabled flag condition
754: -- FROM (SELECT object_type, object_name, depend_object_type, depend_object_name FROM bis_obj_dependency WHERE enabled_flag = 'Y') d
755: FROM bis_obj_dependency d
756: START WITH d.depend_object_type = p_object_type AND d.depend_object_name = p_object_name
757: CONNECT BY PRIOR d.object_name = d.depend_object_name
758: AND PRIOR d.object_type = d.depend_object_type) obj_parents
759: WHERE obj_parents.object_type = p_dep_object_type

Line 941: insert into bis_obj_dependency (

937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
938: FND_MSG_PUB.initialize;
939: END IF;
940:
941: insert into bis_obj_dependency (
942: OBJECT_TYPE,
943: OBJECT_OWNER,
944: OBJECT_NAME,
945: ENABLED_FLAG,

Line 1139: update bis_obj_dependency

1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:
1138: if (P_ROWID IS NOT NULL) THEN
1139: update bis_obj_dependency
1140: SET object_owner = p_object_owner,
1141: enabled_flag = P_ENABLED_FLAG,
1142: depend_object_type = P_DEPEND_OBJECT_TYPE,
1143: depend_object_owner = P_DEPEND_OBJECT_OWNER,

Line 1150: UPDATE BIS_OBJ_DEPENDENCY

1146: last_update_login = L_LAST_UPDATE_LOGIN,
1147: last_update_date = L_LAST_UPDATE_DATE
1148: where rowid = P_ROWID;
1149: else
1150: UPDATE BIS_OBJ_DEPENDENCY
1151: SET object_owner = p_object_owner,
1152: ENABLED_FLAG = P_ENABLED_FLAG,
1153: DEPEND_OBJECT_OWNER = P_DEPEND_OBJECT_OWNER,
1154: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,

Line 1284: delete from bis_obj_dependency

1280: P_ROWID in ROWID
1281: ) is
1282: BEGIN
1283:
1284: delete from bis_obj_dependency
1285: where rowid = P_ROWID;
1286:
1287: If (SQL%NOTFOUND) then
1288: RAISE NO_DATA_FOUND;

Line 1735: FROM BIS_OBJ_DEPENDENCY

1731: ) RETURN boolean
1732: IS
1733: cursor c_page_migrated(P_PAGE_NAME varchar2) is
1734: SELECT /*+ FIRST_ROWS*/ 'Y'
1735: FROM BIS_OBJ_DEPENDENCY
1736: WHERE OBJECT_TYPE = 'PAGE'
1737: AND P_PAGE_NAME like '%_OA'
1738: AND OBJECT_NAME = SUBSTR(P_PAGE_NAME, 1, LENGTH(P_PAGE_NAME) - 3)
1739: AND ROWNUM = 1;

Line 1800: bis_obj_dependency d

1796: cursor skip_migrate(P_PAGE_NAME varchar2) is
1797: select /*+ FIRST_ROWS*/ 'Y'
1798: from
1799: fnd_form_functions f,
1800: bis_obj_dependency d
1801: where
1802: d.object_name = f.function_name
1803: and d.object_type = 'PAGE'
1804: and UPPER(f.web_html_call) like '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'

Line 1826: update bis_obj_dependency

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
1829: object_type = 'PAGE'
1830: and object_name = P_PAGE_NAME;

Line 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');

1827: set object_name = P_NEW_PAGE_NAME
1828: where
1829: object_type = 'PAGE'
1830: and object_name = P_PAGE_NAME;
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

Line 1836: unlike the previous approach of getting it from bis_obj_dependency */

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,
1840: p_new_obj_owner IN VARCHAR2,

Line 1904: select CREATED_BY from bis_obj_dependency

1900:
1901: FUNCTION is_object_seeded( p_obj_name IN VARCHAR2, p_obj_type IN VARCHAR2) RETURN VARCHAR2 IS
1902:
1903: cursor c_obj_depend(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1904: select CREATED_BY from bis_obj_dependency
1905: where OBJECT_NAME = l_obj_name and OBJECT_TYPE = l_obj_type;
1906:
1907: cursor c_obj_depend_depend(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1908: select CREATED_BY from bis_obj_dependency

Line 1908: select CREATED_BY from bis_obj_dependency

1904: select CREATED_BY from bis_obj_dependency
1905: where OBJECT_NAME = l_obj_name and OBJECT_TYPE = l_obj_type;
1906:
1907: cursor c_obj_depend_depend(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1908: select CREATED_BY from bis_obj_dependency
1909: where DEPEND_OBJECT_NAME = l_obj_name and depend_OBJECT_TYPE = l_obj_type;
1910:
1911:
1912: cursor c_obj_prog(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is