APPS.BIS_CREATE_REQUESTSET dependencies on BIS_CREATE_REQUESTSET

Line 1: package body BIS_CREATE_REQUESTSET AS

1: package body BIS_CREATE_REQUESTSET AS
2: /*$Header: BISCRSTB.pls 120.16 2006/09/07 14:30:19 aguwalan ship $*/
3:
4: g_set_application varchar2(30);
5: g_fnd_stats varchar2(30);

Line 288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');

284: commit;
285:
286: ---clean up global temp table whenever a request set is to be created
287: ---bug 4724296
288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');
289: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_IMPL_FLAG_TEMP';
290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');
291: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_STAGE_OBJECTS';
292:

Line 290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');

286: ---clean up global temp table whenever a request set is to be created
287: ---bug 4724296
288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');
289: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_IMPL_FLAG_TEMP';
290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');
291: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_STAGE_OBJECTS';
292:
293: exception
294: when others then

Line 1139: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.add_any_object_to_set';

1135: l_mode varchar2(30);
1136:
1137: -- FOR PING
1138: l_ping_result VARCHAR2(10);
1139: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.add_any_object_to_set';
1140:
1141:
1142: begin
1143:

Line 3171: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.create_rs_objects';

3167: l_object_owner varchar2(50):=null;
3168: l_set_app_id number;
3169: cursor c_owner is select distinct OBJECT_OWNER from bis_obj_dependency
3170: where object_type=p_object_type and object_name=p_object_name;
3171: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.create_rs_objects';
3172: l_func1 varchar2(300);
3173: l_func2 varchar2(300);
3174: l_cursor_id integer;
3175: l_rows integer;

Line 3281: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.object_has_data';

3277: l_sql varchar2(2000);
3278: l_count number;
3279: l_owner varchar2(30);
3280: l_timestamp date;
3281: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.object_has_data';
3282:
3283: begin
3284: ---First check if the object physically exists
3285: l_owner:=get_object_owner(p_object_name,p_object_type);

Line 4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);

4286: BIS_COLLECTION_UTILITIES.put_line(l_report_end);
4287:
4288: exception
4289: when others then
4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);
4291: errbuf := sqlerrm;
4292: retcode := '2';
4293: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
4294: end;

Line 4531: END BIS_CREATE_REQUESTSET;

4527: RETURN true;
4528: END IF;
4529: END;
4530:
4531: END BIS_CREATE_REQUESTSET;