APPS.BIS_CREATE_REQUESTSET dependencies on BIS_OBJ_PROPERTIES

Line 461: from bis_obj_properties

457: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name
458: and prior obj.DEPEND_OBJECT_TYPE=obj.object_type ) depend_objects
459: union---the object itself could have program so we need union here
460: select object_type,object_name
461: from bis_obj_properties
462: where object_type= p_object_type
463: and object_name=p_object_name;
464:
465:

Line 1783: and EXISTS( Select 'Y' from bis_obj_properties b

1779: level
1780: from bis_obj_dependency a
1781: where a.enabled_flag='Y'
1782: and a.object_type<>'VIEW'
1783: and EXISTS( Select 'Y' from bis_obj_properties b
1784: where a.depend_object_name=b.object_name
1785: and a.depend_object_type=b.object_type
1786: and b.DIMENSION_FLAG='Y' )
1787: start with a.object_type= p_dim_type and a.object_name=p_dim_name

Line 1796: and EXISTS ( Select 'Y' from bis_obj_properties b

1792: cursor c_max_level is
1793: select max(level)
1794: from bis_obj_dependency a
1795: where a.enabled_flag='Y'
1796: and EXISTS ( Select 'Y' from bis_obj_properties b
1797: where a.depend_object_name=b.object_name
1798: and a.depend_object_type=b.object_type
1799: and b.DIMENSION_FLAG='Y')
1800: start with a.object_type= p_dim_type and a.object_name=p_dim_name

Line 2172: bis_obj_properties b

2168: from dual
2169: where exists
2170: (select a.depend_object_name
2171: from bis_obj_dependency a,
2172: bis_obj_properties b
2173: where a.depend_object_name=b.object_name(+)
2174: and a.depend_object_type=b.object_type(+)
2175: and a.object_name=p_object_name
2176: and a.object_type=p_object_type

Line 2843: bis_obj_properties d

2839: from
2840: fnd_request_set_programs a,
2841: fnd_concurrent_programs b,
2842: bis_obj_prog_linkages c,
2843: bis_obj_properties d
2844: where a.set_application_id=p_set_app_id
2845: and a.request_set_id=p_set_id
2846: and a.request_set_stage_id=p_stage_id
2847: and a.program_application_id=b.application_id

Line 3543: bis_obj_properties b

3539:
3540: cursor c_unimpl_obj_in_set is
3541: select distinct a.object_type, bis_impl_dev_pkg.get_user_object_name(a.object_type,a.object_name) user_object_name
3542: from bis_request_set_objects a,
3543: bis_obj_properties b
3544: where a.request_set_name=p_request_set_code
3545: and a.set_app_id=191
3546: and a.object_type=b.object_type
3547: and a.object_name=b.object_name

Line 3556: bis_obj_properties b,

3552:
3553: cursor c_set_with_unimpl_obj is
3554: select distinct c.user_request_set_name from
3555: bis_request_set_objects a,
3556: bis_obj_properties b,
3557: fnd_request_sets_vl c
3558: where a.object_name=b.object_name
3559: and a.object_type=b.object_type
3560: and b.implementation_flag='N'

Line 4194: l_invalid_obj_name bis_obj_properties.object_name%type;

4190: TYPE CurTyp IS REF CURSOR;
4191: cv CurTyp;
4192: l_invalid_obj_type varchar2(30);
4193: l_invalid_obj_owner varchar2(50);
4194: l_invalid_obj_name bis_obj_properties.object_name%type;
4195: l_report_title varchar2(500);
4196: l_report_comment varchar2(2000);
4197: l_report_end varchar2(500);
4198: l_obj_type_prompt varchar2(100);