APPS.BIS_CREATE_REQUESTSET dependencies on DUAL

Line 69: from dual

65: p_object_name varchar2) return varchar2 is
66: l_temp_impl_flag varchar2(1);
67: cursor c_impl_flag is
68: select 'Y'
69: from dual
70: where exists
71: (select 'Y'
72: from BIS_BIA_RSG_IMPL_FLAG_TEMP
73: where set_name=p_set_name

Line 171: from dual

167:
168: function check_bsc_auto_gen return varchar2 is
169: cursor c_exist is
170: select 'Y'
171: from dual
172: where exists
173: (select 'Y'
174: from user_objects
175: where object_name='BSC_DBGEN_UTILS' and object_type='PACKAGE' );

Line 802: from dual

798: l_dummy varchar2(1);
799:
800: cursor c_obj_has_program is
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

Line 1403: from dual

1399:
1400: function set_in_group(p_set_name varchar2,p_setapp varchar2,p_group_name varchar2,p_group_app varchar2) return varchar2 is
1401: cursor c_set_exist is
1402: select 'Y'
1403: from dual
1404: where exists
1405: (select a.request_set_name
1406: from fnd_request_sets a,
1407: fnd_request_group_units b,

Line 1544: from dual

1540: p_set_id number,
1541: p_set_stage_id number) return varchar2 is
1542: cursor c_stage_empty is
1543: select 'N'
1544: from dual
1545: where exists
1546: (select request_set_program_id
1547: from
1548: fnd_request_set_programs

Line 2168: from dual

2164: ----this function will return 'N' if the object has no direct dependency except dimensions
2165: function dependency_exist(p_object_name in varchar2, p_object_type in varchar2) return varchar2 is
2166: cursor c_dependency_exist is
2167: select 'Y'
2168: from dual
2169: where exists
2170: (select a.depend_object_name
2171: from bis_obj_dependency a,
2172: bis_obj_properties b

Line 3831: ---- select rtrim(ltrim(ltrim(P_OBJECT_NAME,substr(P_OBJECT_NAME,0,instr(P_OBJECT_NAME,'[')-1)),'['),']') into l_kpi from dual;

3827: l_kpi varchar2(30);
3828: l_sql varchar2(2000);
3829: l_table_owner varchar2(30);
3830: begin
3831: ---- select rtrim(ltrim(ltrim(P_OBJECT_NAME,substr(P_OBJECT_NAME,0,instr(P_OBJECT_NAME,'[')-1)),'['),']') into l_kpi from dual;
3832: --- select substr(ltrim(p_object_name,'BSC_S'),0,instr(ltrim(p_object_name,'BSC_S'),'_')-1) into l_kpi from dual;
3833: ----select substr(ltrim(p_object_name,'BSC_'),0,instr(ltrim(p_object_name,'BSC_'),'_')-1) into l_kpi from dual ;
3834:
3835: ---first check if the bsc table exists or not

Line 3832: --- select substr(ltrim(p_object_name,'BSC_S'),0,instr(ltrim(p_object_name,'BSC_S'),'_')-1) into l_kpi from dual;

3828: l_sql varchar2(2000);
3829: l_table_owner varchar2(30);
3830: begin
3831: ---- select rtrim(ltrim(ltrim(P_OBJECT_NAME,substr(P_OBJECT_NAME,0,instr(P_OBJECT_NAME,'[')-1)),'['),']') into l_kpi from dual;
3832: --- select substr(ltrim(p_object_name,'BSC_S'),0,instr(ltrim(p_object_name,'BSC_S'),'_')-1) into l_kpi from dual;
3833: ----select substr(ltrim(p_object_name,'BSC_'),0,instr(ltrim(p_object_name,'BSC_'),'_')-1) into l_kpi from dual ;
3834:
3835: ---first check if the bsc table exists or not
3836: l_table_owner:=get_object_owner(upper('bsc_kpi_analysis_measures_b'),'TABLE');

Line 3833: ----select substr(ltrim(p_object_name,'BSC_'),0,instr(ltrim(p_object_name,'BSC_'),'_')-1) into l_kpi from dual ;

3829: l_table_owner varchar2(30);
3830: begin
3831: ---- select rtrim(ltrim(ltrim(P_OBJECT_NAME,substr(P_OBJECT_NAME,0,instr(P_OBJECT_NAME,'[')-1)),'['),']') into l_kpi from dual;
3832: --- select substr(ltrim(p_object_name,'BSC_S'),0,instr(ltrim(p_object_name,'BSC_S'),'_')-1) into l_kpi from dual;
3833: ----select substr(ltrim(p_object_name,'BSC_'),0,instr(ltrim(p_object_name,'BSC_'),'_')-1) into l_kpi from dual ;
3834:
3835: ---first check if the bsc table exists or not
3836: l_table_owner:=get_object_owner(upper('bsc_kpi_analysis_measures_b'),'TABLE');
3837: if l_table_owner='NOTFOUND' then