DBA Data[Home] [Help]

APPS.ZPB_ACVAL_PVT dependencies on ZPB_MEASURE_SCOPE

Line 2951: delete FROM zpb_measure_scope WHERE instance_ac_id = p_analysis_cycle_id;

2947:
2948: update zpb_analysis_cycles set status_code = 'MARKED_FOR_DELETION' where analysis_cycle_id = p_analysis_cycle_id ;
2949: update ZPB_DC_OBJECTS set DELETE_INSTANCE_MEASURES_FLAG = 'Y' where ac_instance_id = p_analysis_cycle_id ;
2950:
2951: delete FROM zpb_measure_scope WHERE instance_ac_id = p_analysis_cycle_id;
2952: delete FROM zpb_measure_scope_exempt_users WHERE BUSINESS_PROCESS_ENTITY_ID = p_analysis_cycle_id;
2953:
2954:
2955: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' View Deleted with Analysis Cycleid' || p_analysis_cycle_id || '.');

Line 2952: delete FROM zpb_measure_scope_exempt_users WHERE BUSINESS_PROCESS_ENTITY_ID = p_analysis_cycle_id;

2948: update zpb_analysis_cycles set status_code = 'MARKED_FOR_DELETION' where analysis_cycle_id = p_analysis_cycle_id ;
2949: update ZPB_DC_OBJECTS set DELETE_INSTANCE_MEASURES_FLAG = 'Y' where ac_instance_id = p_analysis_cycle_id ;
2950:
2951: delete FROM zpb_measure_scope WHERE instance_ac_id = p_analysis_cycle_id;
2952: delete FROM zpb_measure_scope_exempt_users WHERE BUSINESS_PROCESS_ENTITY_ID = p_analysis_cycle_id;
2953:
2954:
2955: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' View Deleted with Analysis Cycleid' || p_analysis_cycle_id || '.');
2956: