[Home] [Help]
801: select 'Y'
802: from dual
803: where exists
804: (select 1
805: from bis_obj_prog_linkages
806: where object_type=p_object_type
807: and object_name=p_object_name
808: and enabled_flag='Y');
809: begin
1053: object_owner,
1054: object_type,
1055: object_name,
1056: 1 mylevel
1057: from bis_obj_prog_linkages
1058: where object_type=p_object_type
1059: and object_name=p_object_name
1060: order by mylevel desc;
1061:
1087: select distinct
1088: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1089: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1090: from
1091: bis_obj_prog_linkages a,
1092: fnd_concurrent_programs b
1093: where a.object_name=p_objectname
1094: and a.object_type=p_objecttype
1095: and a.enabled_flag='Y'
1806: select distinct
1807: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1808: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1809: from
1810: bis_obj_prog_linkages a,
1811: fnd_concurrent_programs b
1812: where a.object_name=p_objectname
1813: and a.object_type=p_objecttype
1814: and a.enabled_flag='Y'
2362: ) depend_objects
2363: where depend_objects.obj_type='MV'
2364: or (depend_objects.obj_type in ('MV','TABLE') and
2365: depend_objects.obj_type||depend_objects.obj_name in
2366: (select object_type||object_name from bis_obj_prog_linkages where enabled_flag='Y'));
2367:
2368: l_all_objects object_table;
2369: l_pages_rec c_pages%rowtype;
2370: l_obj_rec c_objects%rowtype;
2799: c.object_name
2800: from
2801: fnd_request_set_programs a,
2802: fnd_concurrent_programs b,
2803: bis_obj_prog_linkages c,
2804: BIS_BIA_RSG_STAGE_OBJECTS d
2805: where a.set_application_id=p_set_app_id
2806: and a.request_set_id=p_set_id
2807: and a.request_set_stage_id=p_stage_id
2838: distinct d.CUSTOM_API custom_api
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