DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on BIS_COLL_RS_HISTORY

Line 849: BIS_COLL_RS_HISTORY.insert_program_object_data

845:
846: if (p_prog_req_id is not null and l_root_req_id is not null )then
847: --Enh#4418520-aguwalan
848: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_req_id)) then
849: BIS_COLL_RS_HISTORY.insert_program_object_data
850: (
851: x_request_id => p_prog_req_id,
852: x_stage_req_id => null,
853: x_object_name => p_mv_name ,

Line 866: logmsg('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data: '||sqlerrm);

862: END IF;
863: end if;
864: exception
865: when others then
866: logmsg('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data: '||sqlerrm);
867: end;
868:
869: ---This procedure is added for bug 4406144
870: --It will compile MVs in RSG with status INVALID

Line 1404: BIS_COLL_RS_HISTORY.insert_program_object_data

1400: -----we will record them to history table in procedure CONSIDER_REFRESH
1401:
1402: -- Enh#4418520-aguwalan
1403: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN
1404: BIS_COLL_RS_HISTORY.insert_program_object_data
1405: (
1406: x_request_id => prog_request_id,
1407: x_stage_req_id => null,
1408: x_object_name => P_MVNAME ,

Line 1483: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => p_request_id,

1479: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);
1480: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);
1481: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);
1482:
1483: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => p_request_id,
1484: x_stage_req_id => null,
1485: x_object_name => p_object_name ,
1486: x_object_type => 'MV',
1487: x_refresh_type => p_refresh_type,